Scope of the Course:
Understanding relational databases and their role in the digital world
Learning how to write and execute basic SQL queries
Gaining the ability to retrieve and analyze data from real-world datasets
Preparing students for higher-level courses in Data Analytics, BI, and Data Science
Syllabus:
Module 1: Introduction to Databases
What is Data?
What is a Database?
Types of Databases (Relational vs. Non-Relational)
Introduction to RDBMS
Module 2: SQL Basics
SQL Introduction, Structure, and Syntax
SELECT, FROM, WHERE, ORDER BY
DISTINCT, LIMIT, and Basic Filtering
Module 3: Data Handling
INSERT, UPDATE, DELETE Statements
Data Types and Constraints
Introduction to Primary Keys and Foreign Keys
Module 4: Data Retrieval and Sorting
Sorting Data with ORDER BY
Filtering Data with WHERE and AND/OR
Module 5: Joins and Aggregations (Basic Level)
INNER JOIN Introduction
Basic Aggregate Functions (COUNT, SUM, AVG, MIN, MAX)
GROUP BY and HAVING (Intro level)
Eligibility:
Any graduate (non-technical or technical) looking to enter the IT field
No prior programming knowledge required
Basic computer literacy is enough
Outcomes After Course Completion:
Understand the role and structure of databases in IT systems
Write basic SQL queries to insert, update, delete, and retrieve data
Analyze and sort data using simple SQL commands
Build a foundation for career tracks in Data Analytics, Software Testing, and Business
Intelligence
Be eligible for intermediate-level SQL or Power BI certification courses