CERTIFICATE IN SQL ( S-SQL202504 )

Module 1: Introduction to Data, Databases & MySQL Installation

• What is Data, Database and it’s types (Relational, NoSQL, etc.)
• Introduction to SQL & Why SQL?
• SQL vs MySQL
• Popular SQL Tools
• Data Types in MySQL
• Installing MySQL & Workbench

Module 2: Creating, Querying & Manipulating Data

• Database/Table Basics: CREATE DATABASE, CREATE TABLE
• ALTER, DROP, TRUNCATE & RENAME
• SELECT, INSERT, UPDATE, DELETE
• Filtering Data using WHERE
• Comparison Operators: =, !=, <, >, IN, LIKE, BETWEEN, IS NULL
• ORDER BY and LIMIT

Module 3: Aggregation, Grouping & Joins

• Aggregate Functions: COUNT(), SUM(), AVG(), MIN(), MAX()
• GROUP BY and HAVING
• SQL Constraints: PRIMARY KEY, FOREIGN KEY, UNIQUE, DEFAULT, CHECK, NOT NULL
• Joins: INNER, LEFT, RIGHT, FULL OUTER, SELF, CROSS JOIN
• Set Operations: UNION, UNION ALL, INTERSECT, EXCEPT

Module 4: Advanced SQL – Subqueries, CASE & Window Functions

• Subqueries in SELECT, WHERE, FROM
• CASE Statements for Conditional Logic
• Common Table Expressions (CTE) with WITH
• Window Functions: ROW_NUMBER(), RANK(), DENSE_RANK(), LEAD(), LAG()

Module 5: Data Import/Export & Analytics

• Import CSV files into MySQL using Workbench
• Export result sets to Excel
• Basic Data Modeling and Normalization Overview (1NF, 2NF, 3NF)