SQL for Data Analysis

Course Overview Are you looking to gain a new in-demand skill from the comfort of your home? Well, look no …

SQL for Data Analysis

SQL for Data Analysis




1 Year Access


8 Students


10 hours, 47 minutes

Gift this course

Course Overview

Are you looking to gain a new in-demand skill from the comfort of your home? Well, look no further; you’ve come to the right place!

Our easy-to-follow SQL for Data Analysis will provide you with all the deep knowledge and insight you need to know about this topic. This comprehensive course has been broken down into several manageable modules, which we believe will assist you to easily grasp each concept – from the fundamental to the more advanced aspects of the course. 

Learn the most in-demand skills from the safety & comfort of your home. Enjoy the freedom to learn at your own comfortable pace and prepare yourself for the market of the future.

Learning Outcomes

Whether you are an aspiring professional or a complete beginner, this course will improve your expertise and boost your CV with key skills and an accredited certification attesting to your knowledge. 

Entry Requirement

    • This course is available to all learners of all academic backgrounds.
    • Learners should be aged 16 or over to undertake the qualification.
    • Some basic understanding of the English language and numeracy.  


After you have successfully completed the course, you will be able to obtain an Accredited Certificate of Achievement. You can, however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at the cost of £29 or in PDF format at the cost of £19.

    • PDF certificate’s turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days

Career path

SQL for Data Analysis is a useful qualification to possess and would be beneficial for any related profession or industry. 

Course Curriculum

Unit 01: Introduction
Introduction 00:01:00
Tools Used in This Course 00:01:00
Unit 02: Setting up Course Tools
Download PostgreSQL 00:02:00
Install PostgreSQL 00:03:00
Download SQLectron 00:02:00
Install SQLectron 00:01:00
Connect to PostgreSQL – Credentials 00:01:00
Connect to PostgreSQL Using SQLectron 00:02:00
Import Course Data Using SQLectron 00:02:00
FOR WINDOWS 32-BIT USERS: Download, Install, Configure & Import Data 00:08:00
Unit 03: Browsing & Filtering Data
Check Imported Data 00:06:00
What is a Database? 00:01:00
SQL Data Types 00:02:00
Finally Some Fun! Extracting Data Based on Requirements 00:01:00
Filtering Data using WHERE Keyword 00:08:00
Filter Data by Range Using BETWEEN 00:03:00
Filter Data by Set of Values Using IN 00:03:00
Filter Data by Date 00:05:00
More Filtering by Date 00:03:00
Another Query Filtering by Date 00:01:00
Filter Data by Strings 00:04:00
More Filtering by Strings 00:05:00
More Filtering by Strings 2 00:10:00
More Filtering by Strings 3 00:02:00
How to Ignore Caps when Filtering by String 00:04:00
Unit 04: Filter Data with AND, OR, NOT Operators
AND Operator 00:10:00
OR Operator 00:12:00
NOT Operator 00:09:00
AND, OR & NOT Operators: Which Has the Highest Priority? 00:06:00
Unit 05: Math Operations
Basic Math Operations 00:06:00
Modulo Operatorb 00:04:00
Calculate The Net Salary for Employees 00:06:00
Filter Data with Math Equations 00:03:00
Unit 06: String Concatenation
Concatenate Strings with ‘||’ Operator 00:06:00
Concatenate Strings with Numbers 00:02:00
Unit 07: Tidy Up Your Results: Sorting, Alias Names, Limit Records
Give Your Report Fields A Cool Name 00:04:00
A Report for Payroll 00:07:00
Order Records by Column 00:06:00
Order Records by Multiple Columns 00:12:00
How Alias Names Cannot Be Used with WHERE 00:02:00
LIMIT Record Count Fetched by Your Query 00:08:00
Unit 08: NULL, DISTINCT & CASE Statements
Fetch A Field’s Unique Values Using DISTINCT 00:03:00
Using DISTINCT Keyword with Multiple Columns 00:06:00
What is a NULL Value Anyway? 00:05:00
Build More Sophisticated Queries with CASE Statements 00:10:00
Your Knowledge So Far Under A Great Test 00:09:00
Unit 09: Functions in SQL: Multiple-Row Functions
Let Me Introduce You to Functions 00:04:00
SUM Function 00:04:00
AVG (Average) Function 00:04:00
COUNT Function 00:07:00
MIN & MAX Functions 00:04:00
How To Count Your Field’s Unique Values 00:04:00
GROUP BY Clause: Use Functions with Dimensions 00:06:00
GROUP BY More Than One Dimension 00:05:00
Now For Some Tough Workout 00:09:00
Filter By Aggregate Functions with HAVING Clause 00:08:00
Unit 10: Functions in SQL: Single-Row Functions
Character Functions – UPPER, LOWER & INITCAP 00:08:00
Character Functions – CONCAT & LENGTH 00:10:00
Character Functions – LPAD & RPAD 00:13:00
Character Functions – TRIM 00:04:00
Character Functions – REPLACE 00:09:00
Character Functions – SUBSTR 00:10:00
Number Functions – MOD & ROUND 00:11:00
Number Functions – TRUNC 00:07:00
Unit 11: Nested Queries
Selectception: A Select Query inside another Select Query! 00:06:00
Unit 12: Casting & Data Conversion
Auto Data Conversion in SQL 00:11:00
Cast Date to Character 00:10:00
Cast Number to Character 00:09:00
Cast Timestamp to Character 00:07:00
Cast Character to Number 00:08:00
Cast Character to Date & Timestamp 00:09:00
Unit 13: Combination Relationships
UNION 00:03:00
UNION ALL 00:02:00
Important Note about Combining Queries 00:02:00
INTERSECT 00:01:00
EXCEPT 00:01:00
Unit 14: Joins in SQL
Employees & Departments Tables Revised 00:03:00
Entity Relationship Diagram (ERD) 00:09:00
Cartesian Join 00:09:00
Table Aliases with Joins 00:07:00
Why I Don’t Recommend Cartesian Joins 00:08:00
Inner Join 00:06:00
In-Depth Look into Join Types in SQL 00:03:00
Outer Join – Right, Left & Full 00:08:00
Unit 15: Data Manipulation (DML)
INSERT a New Record to a Table 00:09:00
Insert Without Specifying Column Names 00:09:00
UPDATE a Record’s Field Values 00:07:00
CAUTION! How an UPDATE Query Can Go Wrong 00:04:00
Update a Record Using Single-Row Functions 00:04:00
A Good Exercise: Extract Employee’s Email Address 00:02:00
Solution: Extract Employee’s Email Address 00:13:00
DELETE a Table’s Record 00:06:00
Insert Records with Nested Select Queries 00:06:00
Unit 16: SQL Data Definition Language (DDL)
SQL Data Types Revised 00:13:00
Bookstore Data Set: Let’s Move It to Database 00:04:00
Create Your First Table! 00:08:00
Insert Data to Your New Table 00:08:00
Change Column Data Type 00:07:00
Rename Column 00:04:00
Add a New Column to Table 00:04:00
Constraints in SQL 00:01:00
Primary Keys 00:14:00
NOT NULL Constraint 00:05:00
UNIQUE Constraint 00:04:00
DEFAULT Constraint 00:04:00
Foreign Keys 00:08:00
Use Foreign Keys with Joins – Books & Publishers 00:06:00
Foreign Keys – Properties 00:06:00
Drop Column 00:01:00
DROP Table 00:01:00
Create a New Table with Select Statement 00:05:00
A Trick to Create an Empty Table with Select Statement 00:03:00
Insert New Records Using Select Statement 00:06:00
Views 00:03:00
Create & Use Schemas 00:04:00
Schemas 00:02:00
Resources – SQL for Data Analysis 00:00:00
Assignment – SQL for Data Analysis 00:00:00

Course Ratings


  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Ratings found for this course.

How Do Our Courses Work?

Purchase and payment

Add your chosen course to your basket. Once you’ve added all the courses you need.

Course access

Add your chosen course to your basket. Once you’ve added all the courses you need.


Add your chosen course to your basket. Once you’ve added all the courses you need.

Continued support

Add your chosen course to your basket. Once you’ve added all the courses you need.

Dive into an enriching online learning journey with Alpha Academy. We pride ourselves on offering a diverse range of courses tailored to your needs. Elevate your expertise or discover a new passion. With Alpha Academy, your pursuit of knowledge has no bounds.


For Business

Certificate validator

Payment methods possible


    Your Cart
    Your cart is emptyReturn to Shop

    WINTER SALE :: ALL COURSES for $64.09 / year


    No more than 50 active courses at any one time. Membership renews after 12 months. Cancel anytime from your account. Certain courses are not included. Can't be used in conjunction with any other offer.

      Apply Coupon