logo
Courses 100 SQL Challenges Login

Think SQL: Go from Zero to Hero (Recorded)

Our SQL for data analytics course is the perfect choice for Data Analysts, Data Engineers, and Data Scientists who want to take their SQL skills to next level. This course will take you from basics of SQL syntax to advanced techniques for data manipulation, data analysis and complex problem solving. Kick start your career with mastering the most in demand data skill called SQL.
✅ 15+ sessions with lifetime access to recordings. & Assignments after each class.
✅ No pre-requisite required ( Learn From Absolute Scratch)
✅ Hand-picked SQL problems (asked in FAANG and product-based companies) set for practice.
✅ Includes 2 portfolio projects on real datasets
✅ Introductory session to Tableau to pursue various data roles within the industry.

About the course

This course will cover everything you need about SQL for data analytics. The course will start with fundamental SQL syntax, and writing your first statement and by the end of the course, you will be able to solve advanced SQL problems. Join this batch to upskill yourself.

Recorded Classes Lifetime Access

Watch Anywhere, Anytime

Learn from Basic to Advance

Discuss with the Educator

Course Content:

Introduction to SQL:

🎯 What are database and SQL and how they can be used together to drive analytics on big data?
🎯 How to store and modify the data in a database:
🎯 DDL Commands: CREATE, ALTER, DROP, TRUNCATE, etc.
🎯 Data Types: VARCHAR, INT, DECIMAL, DATE, BOOLEAN, etc.
🎯 Constraints: PRIMARY KEY UNIQUE KEY and NOT NULL etc.
🎯 DML Operations : INSERT, UPDATE, DELETE etc.

How to retrieve data: The SELECT Statement

🎯 Basic select clause operations: Distinct, Limit, Order By
🎯 The filter(WHERE) clause: Logical operators, Comparison operators, Advance filters
🎯 Aggregation and Advance Aggregation: Group by, Partition By, Rows 🎯 Between clause, Rolling Calculations, Filter with Having clause
🎯 SQL JOINS: INNER, LEFT, RIGHT, FULL OUTER, SELF, CROSS
🎯 SET Operations: UNION, UNION ALL, MINUS, INTERSECT
🎯 Calculated Columns and SQL Functions: CASE WHEN, Date Functions, String Functions, Data type conversion functions, etc.

Advanced SQL Concepts:
🚀 Queries within queries: Subqueries and CTE (With Clause)
🚀 Window Analytical Functions: RANK, ROW_NUMBER, DENSE_RANK, LEAD/LAG, NTILE
🚀 Performance Tuning: Clustered and non-clustered indexes, best practices for SQL Optimization
🚀 SQL problems set for interview preparations.
🚀 SQL Project with a real dataset.
🚀 Introduction to Tableau.

Who can take this Course?

Tech Enthusiasts

Working Professionals

Managers, Developers

Freelancers

College Students

School Students

Anyone who is looking to learn a new skill or upskill themselves can take this course

LIMITED SEATS - ENROLL NOW

Testimonial & Reviews

Great course designed by Ankit. The way he delivered the sessions made it very simple for me to understand the concepts. The quality of assignments was also top notch as all the questions made me use the concepts taught in the sessions which only helped me get better at them. Anybody looking to learn SQL can enroll for this course without giving a second thought.

By - Ankit Gupta

Best path to learn SQL. This course has created a thinking mindset how to solve a complex SQL problem and write it very easily. The best part is we need to practice a lot of questions post completion of the course, which helped me a lot. Thanks Ankit for the guidance.


By - Hemanth Kumar

Syllabus

Reviews and Testimonials

Launch your GraphyLaunch your Graphy
100K+ creators trust Graphy to teach online
NamasteSQL 2025 Privacy policy Terms of use Contact us Refund policy