SQL for Data Analysis: Basic to Advanced SQL Querying Techniques.
Offered by
Benaadir Research, Consultancy & Evaluation Center (BRCE)

-
LevelAll Levels
-
Total Enrolled7
-
Duration8 hours
-
Last Updated02/08/2025
-
CertificateCertificate of completion
Course Description
Master the art of data analysis with SQL, the universal language for data manipulation and querying. This comprehensive course is designed to take you from beginner to advanced levels, equipping you with the skills to extract, manipulate, and analyze data efficiently. Whether you’re a data enthusiast or a professional looking to enhance your data querying skills, this course offers the tools and techniques to unlock the potential of SQL in real-world applications.
Why should you take this course?
- In-Demand Skill: Master SQL, the essential tool for data analysis and management.
- Hands-On Projects: Work on real-world projects like Pizza Sales and Bank Loan Reports.
- Comprehensive Learning: Learn SQL from basics to advanced querying techniques.
- Boost Career Prospects: Enhance your résumé and stand out in data-driven roles.
- Flexible for All Levels: Designed for beginners and those refining their skills.
- Universal Application: Applicable in industries like finance, marketing, and technology.
- Clear Structure: Step-by-step modules for easy understanding and practical application.
- Practical Skills: Gain the ability to extract insights and solve real-world problems.
Who is this course for?
- Aspiring data analysts, business analysts, and data scientists.
- Professionals working in data-driven industries looking to enhance their SQL skills.
- Students and enthusiasts who want to explore data analysis techniques for academic or career purposes.
- Anyone interested in turning raw data into actionable insights using SQL.
What you’ll learn:
- SQL Fundamentals: Gain a solid foundation in SQL concepts, database types, and basic operations.
- Data Aggregation and Analysis: Learn to summarize and group data with advanced filtering techniques.
- Working with Multiple Tables: Master various JOIN operations to integrate and analyze data across multiple tables.
- Data Manipulation and Transformation: Transform and clean data using string, date, and conditional logic functions.
- Advanced Querying with Subqueries: Explore complex querying techniques using subqueries in different SQL clauses.
- Real-world Capstone Projects: Apply your skills in hands-on projects such as pizza sales and bank loan reports, generating actionable insights through advanced SQL techniques.
Course Curriculum
Module One: Introduction to SQL for Data Analysis
-
Lesson 1. Introduction to databases and SQL
09:34 -
Lesson 2. Types of SQL (DQL, DDL,DGL and DML))
11:17 -
Lesson 3. Types of Database (Relational & Non-Relational database)
03:55 -
Lesson 4. How to download MYSQL
08:34 -
Lesson 5. Create table, Insert Values, Drop table, Alter table on SQL Server
23:39
Module Two: Aggregation and Grouping Data
-
Lesson 1. Aggregate functions: AVG(), SUM(), COUNT (), MIN(), MAX()
49:32 -
Lesson 2. Grouping data with GROUP BY
08:40 -
Lesson 3. Grouping Data by Calculated Fields
10:44 -
Lesson 4. Filtering grouped data with HAVING
10:54 -
Lesson 5. Combining GROUP BY with aggregation functions
08:54 -
Lesson 6. Combining WHERE and HAVING Clauses.
08:54
Module Three: Working with Multiple Tables (Joins)
-
Lesson 1. Basic Understanding JOIN TABLES
04:03 -
Lesson 2. INNER JOIN
14:12 -
Lesson 3. LEFT JOIN
09:34 -
Lesson 4. RIGHT JOIN
08:39 -
Lesson 5. FULL JOIN
09:29
Module 4: Data Manipulation and Transformation
-
Lesson 1: Using CASE and IF statements for conditional logic
21:41 -
Lesson 2. Using string functions (UPPER( ), LOWER( ), CONCAT ( )
08:55 -
Lesson 3. Date and time functions
40:38 -
Lesson 4. Performing data transformation with SQL functions
18:54
Module 5: Subquery in advance SQL
-
Lesson 1. Understanding Subquery and its types
09:03 -
Lesson 2. Subqueries in the FROM Statement
16:24 -
Lesson 3. Subquery in the SELECT Clause
11:18 -
Lesson 4. Subqueries in the JOIN Clause
20:58 -
Lesson 5. Subquery in WHERE Clause
11:04
Module 6. Capstone PROJECT 1 PIZZA SALES REPORT
-
A. Key Performance Indicators (KPIs) Requirements
20:24 -
B. Daily Trend for Total Orders
05:21 -
C. Monthly Trend for Orders
03:36 -
D. % of Sales by Pizza Category
07:25 -
E. % of Sales by Pizza Size
05:53 -
F. Total Pizzas Sold by Pizza Category
02:56 -
G. Top 5 Pizzas by Revenue
03:10 -
H. Bottom 5 Pizzas by Revenue
02:23 -
I. Top 5 Pizzas by Quantity
02:06 -
J. Bottom 5 Pizzas by Quantity
02:02
Module 7: Project 2 BANK LOAN REPORT
-
A. Key Performance Indicators (KPIs) Requirements
45:53 -
B. Good loan Issue
08:45 -
C. Bad loan Issue
09:09 -
D. Loan Status
09:44 -
E. Loan by State
09:44
Hano shahado la aqoonsanyahay
baro xirfad heer sare ah oo technology-da ku saleysan oo hano shahado ku marag kacda.

Student Ratings & Reviews
About the instructors

Offered by

BRCE waa xarun ka shaqaysa horu marinta iyo barashada arimaha la xariira xirfadaha Casriga ah oo ku salaysan Technology-ga.