Back to Courses

SQL

Master SQL queries, joins, subqueries, and database design fundamentals.

2 Weeks
8 Modules

Course Curriculum

Module 1: SQL Fundamentals

  • Introduction to Databases
  • RDBMS Concepts
  • SQL Syntax
  • Data Types
  • Creating Databases & Tables

Module 2: Data Manipulation

  • INSERT Statements
  • UPDATE Statements
  • DELETE Statements
  • SELECT Queries
  • WHERE Clause & Operators

Module 3: Advanced Queries

  • ORDER BY & LIMIT
  • GROUP BY & HAVING
  • Aggregate Functions
  • DISTINCT & Aliases
  • CASE Statements

Module 4: Joins

  • INNER JOIN
  • LEFT & RIGHT JOIN
  • FULL OUTER JOIN
  • CROSS JOIN
  • Self Joins

Module 5: Subqueries

  • Single Row Subqueries
  • Multiple Row Subqueries
  • Correlated Subqueries
  • EXISTS & NOT EXISTS
  • Subqueries in FROM Clause

Module 6: Database Design

  • Normalization (1NF, 2NF, 3NF)
  • Primary & Foreign Keys
  • Constraints
  • Indexes
  • Views

Module 7: Advanced SQL

  • Transactions
  • Stored Procedures
  • Functions
  • Triggers
  • Performance Optimization

Module 8: Practical SQL

  • Real-world Queries
  • Reporting Queries
  • Data Analysis
  • Best Practices
  • SQL Interview Questions