Month 2: SQL Fundamentals
Week 1 – SQL Basics and Retrieving Data
- Day 1: Introduction to SQL, Importance of SQL, Installation of SQL software (like MySQL or PostgreSQL)
- Day 2: Understanding databases, tables, and columns. The relational model.
- Day 3: Basic SQL queries: SELECT, FROM
- Day 4: DISTINCT keyword and the WHERE clause
- Day 5: Logical Operators in SQL (AND, OR, NOT) and introduction to NULL values.
Week 2 – Advanced Data Retrieval and Aggregation
- Day 1: Sorting results using ORDER BY
- Day 2: Limiting Results with the LIMIT keyword. OFFSET keyword.
- Day 3: Introduction to aggregate functions (COUNT, SUM, AVG, MAX, MIN)
- Day 4: GROUP BY and HAVING clauses
- Day 5: Using Aliases in SQL, introduction to CONCAT function
Week 3 – Modifying Data and Data Integrity
- Day 1: Inserting data into a table using INSERT INTO statement
- Day 2: Updating existing records using UPDATE and SET keywords
- Day 3: Deleting data from tables with DELETE FROM
- Day 4: Ensuring data integrity with transactional commands (BEGIN, COMMIT, ROLLBACK)
- Day 5: Understanding primary and foreign keys, introduction to constraints
Week 4 – Advanced SQL Topics
- Day 1: Introduction to subqueries and nested queries
- Day 2: SQL JOIN operations: INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL OUTER JOIN
- Day 3: UNION, INTERSECT, and EXCEPT operations
- Day 4: Introduction to Views, Stored Procedures, and Functions
- Day 5: Indexes and performance considerations, conclusion and next steps
dowhatkennydoes.com 