+233 54 123 9290
support@festman.io
English flag
English
Select a Language
English flag
English
GH₵
GHS
Select a Currency
Ghanaian cedi
GH₵
Euro Member Countries
€
Nigeria Naira
₦
United States Dollar
$
0
Login Create Account
Categories
Home Courses Career Tracks Live Bootcamps Pricing
Start Learning
Part 1: SQL fundamentals for Data Science
Courses SQL

Part 1: SQL fundamentals for Data Science

(1)
131 Students
73 Lectures
Thomas Festus Cudjoe
Thomas Festus Cudjoe

Instructor

About the Course
Content
Comments 0
Reviews 1

About This Course

Thomas Festus Cudjoe
Thomas Festus Cudjoe
(20)
35 Courses
2187 Students
Festus is a Senior Data Analyst, Finance Professional, and Chartered Accountant (CIMA & ICAG) with 7+ years of experience in analytics and business intelligence. He specializes in Power BI, SQL, Python, financial modeling, and AI-driven analytics. At FestMan, he delivers practical, project-based training in Excel, Power BI, Python, SQL, and Applied AI for work. Festus is a Microsoft Certified Trainer, Power BI Certified Analyst, Microsoft Excel Expert, and a 4x Microsoft Data Platform MVP.
Thomas Festus Cudjoe Book a Meeting

Recent Reviews

See what students are saying about the course.

More Reviews
Christine Patience Manful
Christine Patience Manful 18 Aug 2023
Course was well taught and explained with good examples for hands-on practice.
Curriculum Overview

This course includes 7 modules, 73 lessons, and 3:41 hours of materials.

Installing Microsoft SQL Server and MYSQL
8 Parts | 0:29 Hours
Install Microsoft SQL Server and SSMS
Free

Learn how to install Microsoft SQL Server and SSMS

Study Duration 10 Minutes
Attachments 0
Read
Optional: Installing MYSQL Workbench and Server
Free

Download and install MYSQL Server and Workbench

Study Duration 9 Minutes
Attachments 0
Read
Exploring the interface of MYSQL Workbench

Exploring the interface of MYSQL Workbench

Study Duration 10 Minutes
Attachments 0
SQL Scripting
18 Parts | 1:22 Hours
Creating Databases

Learn how to create databases.

Study Duration 5 Minutes
Attachments 0
Creating table

Learn how to create tables within databases.

Study Duration 9 Minutes
Attachments 0
View tables with SELECT statement

Learn how to view tables with the SELECT statement.

Study Duration 2 Minutes
Attachments 0
Adding new columns to a Table

Adding new columns to existing tables

Study Duration 4 Minutes
Attachments 0
Changing data type of a column

Learn how to change the column of an existing column

Study Duration 6 Minutes
Attachments 0
Drop columns in a table

How to drop or delete columns in a table.

Study Duration 3 Minutes
Attachments 0
Rename columns in a table

How to rename an existing column in a table

Study Duration 5 Minutes
Attachments 0
Rename existing tables

Rename existing tables

Study Duration 3 Minutes
Attachments 0
Using the DROP statement

Using the DROP statement

Study Duration 3 Minutes
Attachments 0
Inserting values into tables

Inserting values into tables

Study Duration 8 Minutes
Attachments 0
Inserting values into tables 2

Inserting values into tables

Study Duration 7 Minutes
Attachments 0
Using the UPDATE statement

Updating records in a table

Study Duration 6 Minutes
Attachments 0
Using the UPDATE statement 2

Update records with the UPDATE statement

Study Duration 2 Minutes
Attachments 0
Delete records with the DELETE statement

Delete records from tables

Study Duration 4 Minutes
Attachments 0
Delete records using TRUNCATE statement

Using the truncate statement

Study Duration 2 Minutes
Attachments 0
Drop TOP N records from a table

Delete top N records in a table

Study Duration 3 Minutes
Attachments 0
Qualified Assessment

Test your knowledge

Study Duration 10 Minutes
Attachments 0
SQL Constraints
9 Parts | 0:49 Hours
Introduction to SQL Constraints

Introduction to SQL Constraints

Study Duration 4 Minutes
Attachments 0
Introduction to SQL Constraints 2

Introduction to SQL Constraints

Study Duration 3 Minutes
Attachments 0
Working with NULL Constraint

Working with NULL Constraint

Study Duration 6 Minutes
Attachments 0
Working with UNIQUE Constraint

Working with UNIQUE Constraint

Study Duration 5 Minutes
Attachments 0
Working with DEFAULT Constraint

Working with DEFAULT Constraint

Study Duration 5 Minutes
Attachments 0
Working with the PRIMARY KEY Constraint

Working with the PRIMARY KEY Constraint

Study Duration 7 Minutes
Attachments 0
Working with FOREIGN KEY constraint

Working with FOREIGN KEY constraint

Study Duration 13 Minutes
Attachments 0
Working with IDENTITY constraint

Working with IDENTITY constraint

Study Duration 6 Minutes
Attachments 0
Viewing Database objects
Volume 32.31 MB
Working with External Data
2 Parts
Import Data from Flat file
Volume 55.48 MB
Importing Data from Microsoft Excel
Volume 60.66 MB
Getting started with Azure Data Studio
3 Parts | 0:14 Hours
Exploring Azure Data Studio Interface

Exploring Azure Data Studio Interface

Study Duration 4 Minutes
Attachments 0
Working with the Query editor

Working with the Query editor

Study Duration 5 Minutes
Attachments 0
Working with Notebooks

Working with Notebooks

Study Duration 5 Minutes
Attachments 0
Exploring Data with SQL
14 Parts | 0:43 Hours
Exploring the datasets

Exploring the datasets

Study Duration 5 Minutes
Attachments 0
Retrieving data with the SELECT statement

Retrieving data with the SELECT statement

Study Duration 5 Minutes
Attachments 0
Copy data from one table to another

Copy data from one table to another

Study Duration 5 Minutes
Attachments 0
Select Distinct Values

Select Distinct Values

Study Duration 6 Minutes
Attachments 0
Sort data with ORDER BY Clause
Volume 20.89 MB
Select TOP N items
Volume 20.19 MB
Filter data with WHERE Clause
Volume 16.60 MB
Filter data with WHERE Clause & AND
Volume 14.58 MB
Introduction to Aggregate functions
Volume 16.43 MB
Summarize values with Aggregate functions
Volume 13.21 MB
Using Alias
Volume 12.00 MB
Qualified Assessment

Apply your skills to a real world data.

Study Duration 20 Minutes
Attachments 0
Course conclusion
Volume 4.36 MB
Course review

Course review

Study Duration 2 Minutes
Attachments 0
Certificates
1 Parts
Course Certificate
Course Certificate
If you pass all the lessons in this course, you will receive this certificate.
Type Course Certificate
Leave a Comment
Please log in to leave a comment.
Reply to Comment
Comments Approval

Your comment will be visible after admin approval.

5.00
1 Reviews
Content Quality (5)
Instructor Skills (5)
Value for Money (5)
Support Quality (5)
Christine Patience Manful
Christine Patience Manful
18 Aug 2023 11:47 am
Course was well taught and explained with good examples for hands-on practice.
Reply to Review
Submit Reply

Your reply to this review will be visible to all users.

Part 1: SQL fundamentals for Data Science
GH₵199
Enroll with Pro Account

This Course Includes

Downloadable Content
Official Certificate
Instructor Support
Course Forum
Favorite
Share
Report Content

Course Specifications

Sections
7
Lessons
73
Capacity
Unlimited
Duration
1:30 Hours
Students
131
Created Date
26 Jul 2023
Updated Date
28 Aug 2025
Thomas Festus Cudjoe
Thomas Festus Cudjoe

Founder & Lead Instructor

(20)
Microsoft Certified Trainer
Microsoft Certified Excel Expert
Microsoft Certified Power BI Analyst
Google Certified Data Analyst
Microsoft Office Specialist: Excel 2013
Microsoft MVP
10 courses launched
Microsoft Certified Excel Expert
Profile

Send Course as Gift

Send as a gift to friends

Tags

SQL for Analytics Data science Data analytics
Part 1: SQL fundamentals for Data Science
You are viewing
Part 1: SQL fundamentals for Data Science
footer cta btn icon
Let’s get started now!

Take the First Step in Tech!

Explore courses

Learn

Self paced courses Career tracks Bootcamps Certificate Validation Pricing

Explore

Microsoft Excel Power BI SQL Generative AI Python

Contact Us

1st Floor, World Trade Centre, Accra
+233 54 123 9290
+233 54 123 9290
support@festman.io
© 2025 FestMan Learning. All Rights Reserved. Empowering digital pioneers.
LinkedIn Facebook Instagram Whatsapp
Cart
Subtotal
View Cart