SQL for Data Science – DataSosi

Current Status

Not Enrolled

Price

Free

Get Started

Log In to Enroll

Course Content

Expand All

Course Overview

Module 1: Foundations of SQL and Relational Thinking

Module 1 : Overview

SQL Lecture Theory

Unit 0 : SQL Roadmap 2 Topics | 1 Quiz

Expand

Lesson Content

0% Complete 0/2 Steps

Lecture 0 Voiceover

Unit 1 : SQL Querying Data 2 Topics | 1 Quiz

Expand

Lesson Content

0% Complete 0/2 Steps

Lecture 1 Voiceover

Unit 2 : SQL Filtering Logic 2 Topics | 1 Quiz

Expand

Lesson Content

0% Complete 0/2 Steps

Lecture 2 Voiceover

Unit 3 : SQL Aggregation Joins 2 Topics | 1 Quiz

Expand

Lesson Content

0% Complete 0/2 Steps

Lecture 3 Voiceover

Unit 4 : SQL Data Tables 2 Topics | 1 Quiz

Expand

Lesson Content

0% Complete 0/2 Steps

Lecture 4 Voiceover

Module 2: Applied SQL: Practice and Operationalization

Module 2 : Overview

Download Instructions and Forming Tables 3 Topics

Expand

Lesson Content

0% Complete 0/3 Steps

Instructions to Download SQL

SQL Tables Video Link

Unit 1: Introduction to SQL 6 Topics | 1 Quiz

Expand

Lesson Content

0% Complete 0/6 Steps

Basic SQL Queries

Querying and Filtering Data

DISTINCT Clause in SQL

Sorting Results Using ORDER BY in SQL

Video Lecture Link

Unit 2: Working with NULLs 8 Topics | 1 Quiz

Expand

Lesson Content

0% Complete 0/8 Steps

Understanding Null in SQL

Checking for NULL Values (IS NULL)

Checking for Non-NULL Values (IS NOT NULL)

Replacing NULL Values (COALESCE())

Preventing Errors (NULLIF())

Categorizing NULLs with CASE

Video Lecture Link

Unit 3: Data Type Conversion 6 Topics | 1 Quiz

Expand

Lesson Content

0% Complete 0/6 Steps

Example 1: Converting Hire Date to String

Example 2: Converting Salary to Decimal

Example 3: Handling NULL Values While Converting Department Number to String

Video Lecture Link

Unit 4: Data Aggregation 11 Topics | 1 Quiz

Expand

Lesson Content

0% Complete 0/11 Steps

Data Aggregation

Grouping by Department and Counting Job Titles

Grouping by Department and Counting Attendance Records

Finding Maximum and Minimum Hire Date per Department

Finding the Most Common Job Title

Counting Employees by Job Title

Counting Employees Who Checked In Today

Filtering Departments with More Than 5 Employees (HAVING)

Finding Departments Where Employees Have Worked the Longest

Video Lecture Link

Unit 5: Working with Dates 9 Topics | 1 Quiz

Expand

Lesson Content

0% Complete 0/9 Steps

Extract the Year from Employees’ Hire Dates

Extract the Year from Attendance Records

Count Attendance Records for Each Month

Identify Employees Hired in a Specific Year

Identify Attendance Records on a Specific Date

Calculate Total Attendance per Employee

Count Employees Hired in Each Year

Video Lecture Link

Unit 6: Set Operations 5 Topics | 1 Quiz

Expand

Lesson Content

0% Complete 0/5 Steps

UNION: Combine Job Titles and Departments

UNION ALL: Combine Job Titles and Departments (with Duplicates)

INTERSECT: Find Common Employees in Job Titles and Attendance

Video Lecture Link

Module 3: SQL Capstone — Integrating Theory and Practice

Module 3 : Overview

Unit 7: Capston Project 1 Topic

Expand

Lesson Content

0% Complete 0/1 Steps

Project Files and Instructions

Discussion Forum

Cancel Preloader