SQL course

Week 1: Introduction to Relational Databases and SQL - Introduction to databases and RDBMS concepts. - Relational database terminology (tables, rows, columns, keys). - Overview of SQL and its importance. - Setting up the development environment. - Introduction to basic SQL syntax. Week 2: Creating and Managing Tables - Data types in SQL. - Creating tables using CREATE TABLE. - Defining primary keys, foreign keys, and constraints. - Modifying tables using ALTER TABLE. - Deleting tables using DROP TABLE. Week 3: Data Manipulation Language (DML) - Inserting data using INSERT INTO. - Retrieving data using SELECT. - Filtering data using WHERE. - Updating data using UPDATE. - Deleting data using DELETE. Week 4: Filtering and Sorting Data - Using comparison operators (=, !=, >, <, >=, <=). - Using logical operators (AND, OR, NOT). - Using ORDER BY for sorting. - Using LIMIT and OFFSET for pagination. Week 5: SQL Functions and Operators -Aggregate functions (COUNT, SUM, AVG, MIN, MAX). -String functions (SUBSTRING, CONCAT, UPPER, LOWER). -Date and time functions. -Mathematical operators. Week 6: Joining Tables -Understanding different types of joins (INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN). -Using JOIN clauses to combine data from multiple tables. -Using aliases for tables and columns. Week 7: Subqueries and Views -Using subqueries to retrieve data based on other queries. -Creating and using views. -Understanding the benefits of views. Week 8: Data Integrity and Constraints -Understanding data integrity. -Using NOT NULL, UNIQUE, CHECK, and FOREIGN KEY constraints. -Understanding transactions and ACID properties. Week 9: Advanced SQL Techniques -Using GROUP BY and HAVING clauses. -Using CASE statements for conditional logic. -Window functions (if time allows, depending on level). Week 10: Database Design and Normalization -Introduction to database design principles. -Understanding normalization (1NF, 2NF, 3NF). -Designing a database schema for a real-world scenario.