Join the 'SQL' Learning Programme.

What is a Database?

Types of Databases

Introduction to SQL

Setting Up the Environment (MySQL/PostgreSQL)

Creating and Managing Databases

Tables and Data Types

Inserting, Updating, and Deleting Data

Simple SELECT Queries

Filtering Data with WHERE Clause

Aggregate Functions (SUM, COUNT, AVG, etc.)

Grouping Data with GROUP BY

Filtering Groups with HAVING

Sorting Data with ORDER BY

Using Subqueries

Principles of Database Design

Normal Forms (1NF, 2NF, 3NF, BCNF)

Creating Entity-Relationship (ER) Diagrams

Implementing Relationships (One-to-One, One-to-Many, Many-to-Many)

Introduction to Joins (INNER, OUTER, LEFT, RIGHT)

Cross Joins and Self Joins

Combining Data from Multiple Tables

Working with Views

Understanding Indexes

Creating and Managing Indexes

Query Optimization Techniques

Understanding Execution Plans

ACID Properties

Implementing Transactions in SQL

Managing Locks and Deadlocks

Isolation Levels

Introduction to Stored Procedures

Creating and Executing Stored Procedures

Using SQL Functions

Error Handling in Procedures

Using Window Functions

Pivot and Unpivot Operations

Ranking and Analytics Functions

Case Studies in Data Analysis

Designing a Real-World Database

Writing Complex Queries

Implementing Optimization Techniques

Presenting Insights and Results