SQL Basics
Data Manipulation
Advanced SQL
Querying Data
Database Design
Master the language of data with this practical course on Structured Query Language (SQL). Whether you're a beginner or looking to sharpen your skills, this course will teach you how to read, write, and run SQL queries to extract and manage data efficiently from relational databases.
You’ll learn how to use SQL to create tables, insert and update records, perform complex queries, join multiple tables, and filter data like a pro. This course is perfect for aspiring data analysts, software developers, business professionals, and students who want to work confidently with databases.
What You’ll Learn:
- SQL basics: SELECT, WHERE, ORDER BY, LIMIT
- Filtering and sorting data
- Working with multiple tables using JOINs
- Creating and modifying tables (CREATE, ALTER, DROP)
- Inserting, updating, and deleting data
- Aggregate functions: COUNT, SUM, AVG, MAX, MIN
- GROUP BY and HAVING clauses
- Real-world practice with sample databases
Who This Course is For:
- Beginners with no prior SQL experience
- Data analysts and business intelligence learners
- Developers working with database-driven apps
- Students in tech or data-related fields
By the end of the course, you’ll be able to write effective SQL queries, manage data with confidence, and apply your skills to real-world database problems in any industry.
1. Introduction to database system (SQL)
2. INSTALLATION PROCESS
3. IMPORTING DATA
4. SELECT QUERY
5. QUERY USING SELECT AND FROM
6. AGGREGATE FUNCTIONS
7. WHERE SYNTAX
8. COUNT SYNTAX
9. GROUP BY AND ORDER BY SYNTAX
10. LIMIT SYNTAX
11. DATA VISUALIZATION
12. INTRODUCTION PART 2
13. REGULAR EXPRESSION
14. IF STATEMENT
15. CASE STATEMENT
16. SUBQUERIES
17. INNER JOIN
18. LEFT JOIN
19. RIGHT JOIN
0 Reviews
Scholar | Investment Banker | Apostle of Finance | Incoming CBN Governor | Philanthropist.