Mode: Online (Live Classes in Tamil)
Platform: Open Skools Academy
Class Duration: 1 Hour/day
Total Duration: 30 Hours/ 1 month
The SQL Edge – Beginner-friendly learning program designed to introduce learners to the fundamentals of Structured Query Language (SQL). This course focuses on building a strong foundation in database concepts and practical SQL query writing skills required to manage, retrieve, and analyze data efficiently.
|
MODULE
|
TOPIC
|
KEY CONCEPTS
|
ACTIVITIES / DEMO
|
|---|---|---|---|
|
1
|
Introduction to SQL
|
What is SQL, Databases, DBMS, Types of Databases
|
Overview of database structure
|
|
2
|
Database & Table Basics
|
Database creation, Tables, Rows, Columns, Data Types
|
Create database and table
|
|
3
|
SELECT Statement
|
SELECT syntax, Selecting columns, SELECT *
|
Fetch records from table
|
|
4
|
WHERE Clause & Filtering
|
WHERE, AND, OR, NOT, Comparison operators
|
Filter records using conditions
|
|
5
|
ORDER BY & DISTINCT
|
Sorting data, ASC, DESC, DISTINCT
|
Sort and remove duplicate records
|
|
6
|
LIMIT, LIKE & Wildcards
|
LIMIT, LIKE operator, %, _ wildcards
|
Search-based queries
|
|
7
|
Aggregate Functions
|
COUNT, SUM, AVG, MIN, MAX, GROUP BY
|
Generate summary reports
|
|
8
|
HAVING Clause
|
HAVING vs WHERE, Aggregate filtering
|
Filter grouped data
|
|
9
|
Joins – Basics
|
INNER JOIN, LEFT JOIN, RIGHT JOIN
|
Join multiple tables
|
|
10
|
Subqueries
|
Nested queries, Subquery in WHERE
|
Advanced data filtering
|
|
11
|
Data Manipulation
|
INSERT, UPDATE, DELETE
|
Modify table records
|
|
12
|
Mini Project
|
All SQL concepts
|
Student / Employee / Sales database project
|
Learners who complete all modules and the mini project will receive a “SQL Edge Certificate” from Open Skools Academy.
Apply now to join the SQL Edge course at OpenSkools and build strong database skills through hands-on practice and real-world examples.
1️⃣ Submit application
2️⃣ Attend demo / counselling
3️⃣ Confirm admission
