This course introduces learners to the fundamentals of SQL and relational databases.

You will learn how to write queries, filter and sort data, join tables, create basic reports, and understand real-world database structures.

By the end of the course, learners will be able to work confidently with databases and write effective queries for data analysis and application development.

Learning Outcomes

SQL Foundations

• What is SQL?

• How databases work

• Tables, columns, keys

• Basic query structure

Basic Query Writing

• SELECT statements

• Filtering with WHERE

• Sorting with ORDER BY

• Limiting results

Working With Data

• INSERT

• UPDATE

• DELETE

• Creating simple tables

Joins & Relationships

• INNER JOIN

• LEFT JOIN

• RIGHT JOIN

• Combining tables

Aggregations & Grouping

• COUNT, SUM, AVG, MIN, MAX

• GROUP BY

• HAVING filters

• Basic reporting

Data Filtering Techniques

• Logical operators

• Wildcards (LIKE)

• IN, BETWEEN

• NULL handling

Subqueries & Nested Queries

• Inline subqueries

• Filtering with subqueries

• Reusable query patterns

Business Applications

• Sales reports

• Customer analytics

• Inventory checks

• Performance metrics

Project Work

• Write a full SQL report for a business dataset

• Create queries for sales, customers, and products