Module 1: SQL Set Up
- Setting up the environment for SQL development.
Module 2: Introduction to SQL
- Basic introduction to SQL and databases.
- Explaining DBMS, tables, records, rows, and columns.
Module 3: Data Types in SQL
- Detailed explanation of string, numeric, date & time data types.
Module 4: Working with Databases
- Creating, using, and listing databases.
Module 5: Working with Tables
- Creating tables, describing their structure, and inserting records.
Module 6: Fetching Records from a Table
- Retrieving data from tables based on various criteria.
Module 7: Comparison Operators in SQL
- Detailed exploration of WHERE clause and comparison operators.
Module 8: Understanding NULL & NOT NULL Values
- Handling NULL values in SQL queries.
Module 9: Logical Operators in SQL
- Using logical operators (AND, OR, NOT) and other operators like IN, BETWEEN, LIKE.
Module 10: Data Sorting in SQL
- Sorting query results in ascending and descending order.
Module 11: Constraints in SQL
- Types of constraints such as NOT NULL, UNIQUE, PRIMARY KEY, AUTO_INCREMENT.
Module 12: Aliases in SQL
- Using aliases to simplify column or table names.
Module 13: Arithmetic Operators in SQL
- Performing arithmetic operations in SQL queries.
Module 14: Selecting Distinct Items
- Using SELECT DISTINCT to fetch unique records.
Module 15: Altering Tables in SQL
- Modifying table structure with ALTER TABLE statements.
Module 16: MODIFY & DROP
- Modifying and dropping columns or tables.
Module 17: SHOW Statements
- Using SHOW statements to display information about databases and tables.
Module 18: Update & Delete Records from a Table
- Updating and deleting records in tables.
Module 19: Copying Tables
- Techniques for duplicating tables within or between databases.
Module 20: Statistical Functions in SQL
- Using aggregate functions like MIN, MAX, SUM, AVERAGE, etc.
Module 21: Miscellaneous Functions in SQL
- Additional functions like CONCAT, REVERSE, NOW, etc.
Module 22: GROUP BY & HAVING Clause
- Aggregating data using GROUP BY and filtering groups with HAVING.
Module 23: Relationship Between Tables in SQL
- Exploring relationships and advantages of using multiple tables.
Module 24: Data Modification Anomalies & SQL Keys
- Understanding anomalies and different types of SQL keys.
Module 25: Normalization in SQL
- Steps to normalize databases up to BCNF.
Module 26: FOREIGN Key
- Working with FOREIGN keys to establish relationships between tables.
Module 27: ON DELETE & ON UPDATE Clause
- Managing actions when records are deleted or updated in related tables.
Module 28: JOIN & UNION in SQL
- Different types of joins (INNER, LEFT, RIGHT, FULL) and UNION operations.
