Why SQL?
- Data Management and Querying: SQL is the language of data, allowing you to manage, query, and analyze large datasets with ease.
- Data Analysis and Reporting: SQL enables you to extract insights from data and create reports that inform business decisions.
- Data Integration and Automation: SQL’s advanced features enable you to integrate data from multiple sources and automate tasks, streamlining workflows and improving efficiency.
Session's Calendar
Virtual Classes
Online live classes
Duration
2 months
Matriculation date
December 20 2025
Graduation date
February 28 2025
Time:
Default time schedule – Saturdays & Sundays 4:00pm – 6:00pm WAT
WHAT YOU WILL LEARN IN SQL
| What is SQL?, Introduction to Databases, DBMS, Setting up environment, SELECT, DISTINCT, LIMIT |
| Filtering rows (WHERE, AND, OR, NOT), Comparison operators, Sorting (ORDER BY), Filtering with IN, LIKE, BETWEEN, NULL handling |
| COUNT, SUM, AVG, MIN, MAX functions, GROUP BY, HAVING, Aliases with AS |
| INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL OUTER JOIN, SELF JOIN, CROSS JOIN (Cartesian Product) |
Introduction to subqueries, Subqueries in SELECT/FROM/WHERE, Correlated subqueries, EXISTS and NOT EXISTS
INSERT, UPDATE, DELETE, Transaction management (COMMIT, ROLLBACK), Best practices for modifying data
| String functions (CONCAT, LENGTH, SUBSTR), Date and time functions, Window functions (ROW_NUMBER, RANK, LEAD/LAG), Statistical functions, CASE statements, Common Table Expressions (CTEs), Advanced Window functions (NTILE, FIRST_VALUE, LAST_VALUE) |
| SQL execution plans, Indexing, Query optimization, Final Project: Applying concepts for analysis, Capstone project. |
