Content

No Pre-requisites required

Mock Interview Included

Learn SQL in 8 Classes (2.5 Hours Each)

Module 1: Introduction to SQL and Databases

• Overview of SQL and its importance in data science

• Introduction to relational databases

• Basic database concepts (tables, rows, columns, keys)

• SQL syntax and structure

• Installing and setting up a SQL environment

• Basic SQL commands: `SELECT`, `FROM`, `WHERE`

• Hands-on practice and Q&A

Module 2: Advanced Data Retrieval

• - Filtering data with `WHERE` clause and logical operators

• - Sorting results with `ORDER BY`

• - Using `LIMIT` for result control

• - Introduction to `DISTINCT`

• - Combining conditions with `AND`, `OR`, `NOT`

• - Hands-on exercises and Q&A

Module 3: Aggregation and Grouping

• Aggregate functions: `COUNT`, `SUM`, `AVG`, `MIN`, `MAX`

• Grouping data with `GROUP BY`

• Filtering grouped data with `HAVING`

• Combining aggregate functions with `GROUP BY`

• Practical exercises and Q&A

Module 4: Working with Multiple Tables

• Understanding joins: `INNER JOIN`, `LEFT JOIN`, `RIGHT JOIN`, `FULL JOIN`

• Using aliases for readability

• Combining multiple joins

• Subqueries and nested queries

• Hands-on practice with join queries and Q&A

Module 5: Data Manipulation

• Inserting data into tables: `INSERT INTO`

• Updating data: `UPDATE`

• Deleting data: `DELETE`

• Using transactions: `BEGIN`, `COMMIT`, `ROLLBACK`

• Practical exercises and Q&A

Module 6: Advanced SQL Functions and Operators

• - String functions: `CONCAT`, `SUBSTRING`, `UPPER`, `LOWER`

• - Date and time functions: `NOW`, `DATE`, `DATEDIFF`

• - Mathematical functions: `ROUND`, `CEIL`, `FLOOR`

• - Conditional statements: `CASE WHEN`

• - Practical exercises and Q&A

Module 7: Database Design and Normalization

• Principles of database design

• Normalization: 1NF, 2NF, 3NF

• Creating and altering tables: `CREATE TABLE`, `ALTER TABLE`

• Indexes and their importance

• Foreign keys and constraints

• Practical exercises and Q&A

Module 8: Performance Tuning and Advanced Topics

• Query optimization techniques

• Indexing strategies

• Using views for simplified querying

• Introduction to stored procedures and triggers

• Best practices for writing efficient SQL

• Final project: building a complete database query application

• Review, wrap-up, and Q&A

Extra:

• Mock interview No.1- One hour

• Mock Interview No.2- 45mins

Each class includes a mix of theoretical concepts, practical exercises, and time for questions and answers to reinforce learning and ensure a comprehensive understanding of SQL.