SQL for Data Science – DataSosi

Current Status

Not Enrolled

Price

Free

Get Started

Log In to Enroll

Course Content

Expand All

Course Overview

Instructions and Lecture 4 Topics

Expand

Lesson Content

0% Complete 0/4 Steps

Instructions to Download SQL

SQL Tables Video Link

Unit 1: Introduction to SQL

Overview 5 Topics | 1 Quiz

Expand

Lesson Content

0% Complete 0/5 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

Overview 7 Topics | 1 Quiz

Expand

Lesson Content

0% Complete 0/7 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

Overview 5 Topics | 1 Quiz

Expand

Lesson Content

0% Complete 0/5 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

Overview 10 Topics | 1 Quiz

Expand

Lesson Content

0% Complete 0/10 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

Overview 8 Topics | 1 Quiz

Expand

Lesson Content

0% Complete 0/8 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

Overview 4 Topics | 1 Quiz

Expand

Lesson Content

0% Complete 0/4 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

UNIT 7: Capston Project

Project Files and Instructions

Cancel Preloader