Module Breakdown
Live Module 1: Introduction to SQL & Relational Databases
- What is SQL and why does it matter in the modern digital workplace
- Types of Databases: Relational vs Non-Relational
- Key Terminology: Tables, Rows, Columns, Schemas
- Setting up a SQL environment (e.g., MySQL, SQLite)
Live Module 2: Basic Data Retrieval
- SELECT statement basics
- Filtering data with WHERE
- Using operators like IN, BETWEEN, LIKE
- Sorting results with ORDER BY
Live Module 3: Working with Multiple Tables
- Understanding Joins: INNER, LEFT, RIGHT, FULL
- Using JOIN with ON conditions
- Practical use cases for joins in business and analytics
Live Module 4: Data Manipulation Techniques
- INSERT INTO, UPDATE, DELETE statements
- Ensuring data integrity with PRIMARY KEY, FOREIGN KEY
- Transactions and rollbacks (basic intro)
Live Module 5: Aggregate Functions & Grouping
- COUNT, SUM, AVG, MIN, MAX
- GROUP BY and HAVING clause
- Real-world reporting examples (sales data, user metrics)
Live Module 6: Practical Application & Final Assessment
- Case study: Analyze a sample e-commerce database
- Mini Project: Create queries to extract business insights
- Final quiz or submission of query scripts for review
Reviews
There are no reviews yet.