SQL
Learn SQL from scratch and master database queries, joins, indexing, and reporting for real-world data work.
Manjula
Last Updated: August 27, 2026
Description
Start with SQL fundamentals and move into relational database design, filtering, joins, subqueries, aggregation, and performance tuning. Build practical skills for working with MySQL, PostgreSQL, and modern analytics workflows.
Course Requirements
- No prior database experience required
- A computer with internet access
- Willingness to practice quiz and query exercises
What You Will Learn
- Write SQL queries using SELECT, WHERE, GROUP BY, and ORDER BY
- Use joins to combine data from multiple tables
- Design and query relational databases confidently
- Improve performance with indexing and query optimization
Video: What SQL Is and How Relational Databases Work
Video: Database, Schema, Table, Row and Column Concepts
Video: Primary Keys, Foreign Keys and Constraints
Video: CREATE DATABASE and CREATE TABLE
Video: Data Types and NULL Handling
Video: ALTER, DROP and TRUNCATE
Video: SELECT, DISTINCT and Column Aliases
Video: WHERE Conditions and Comparison Operators
Video: AND, OR and NOT Logic
Video: IN, BETWEEN and LIKE
Video: ORDER BY and LIMIT
Video: CASE Expressions
Video: INSERT Single and Multiple Rows
Video: UPDATE with Safe Filtering
Video: DELETE and Data Integrity
Video: Upsert Patterns and INSERT SELECT
Video: Transactions and COMMIT / ROLLBACK
Video: Practical CRUD Exercise
Video: INNER JOIN
Video: LEFT JOIN and RIGHT JOIN
Video: SELF JOIN and Cross Join
Video: Joining Three or More Tables
Video: Many-to-Many Relationships
Video: Real-World Relational Query Practice
Video: COUNT, SUM, AVG, MIN and MAX
Video: GROUP BY
Video: HAVING
Video: Conditional Aggregation
Video: Date and String Aggregation Patterns
Video: Building Business Summary Queries
Video: Scalar and Single-Row Subqueries
Video: IN and EXISTS Subqueries
Video: Correlated Subqueries
Video: Derived Tables
Video: Common Table Expressions
Video: Breaking Complex Problems into Query Steps
Video: Window Functions and PARTITION BY
Video: ROW_NUMBER, RANK and DENSE_RANK
Video: LAG and LEAD
Video: Running Totals and Moving Averages
Video: Top-N Per Group Problems
Video: Advanced Reporting Queries
Video: Entity Relationship Modeling
Video: Functional Dependencies
Video: First, Second and Third Normal Forms
Video: Denormalization Trade-Offs
Video: Referential Integrity and Cascades
Video: Designing a Production-Ready Schema
Video: How Database Indexes Work
Video: Single-Column and Composite Indexes
Video: EXPLAIN and Query Execution Plans
Video: Index Selectivity and Covering Indexes
Video: Common SQL Performance Problems
Video: Optimization Workshop
Video: E-Commerce Database Case Study
Video: Employee and Payroll Analytics Case Study
Video: Sales Dashboard Query Pack
Video: Data Cleaning and Validation Queries
Video: SQL Interview Problem Solving
Video: Capstone: Build a Reporting Database
Manjula
Java Champion and Spring Boot expert with 8 years of enterprise development experience. Worked at Wipro and TCS before moving to full-time education. Passionate about clean architecture and microservices.
Reviews (5)
Siddharth Joshi
3 weeks agoAmazing course! I was a complete beginner and now feel confident enough to work on real projects. Thank you!
Arjun Kumar
1 month agoThe hands-on projects are really practical and relevant to real-world scenarios. The instructor is very responsive to questions.
Sneha Sharma
1 month agoBest course I have taken online. The depth of content is incredible and the examples are very easy to follow.
Kavitha Murugan
2 months agoThe course content is up to date and covers everything you need to get started professionally.
Preethi Krishnan
3 months agoGood course overall. The video quality is great and the explanations are clear. Would love more practice exercises.
