Skip to content
Login/Register
Email: info@datasosi.com
DataSosiDataSosi
  • Category
    • Foundation Campus: Self-paced Learning
    • Foundation Courses
    • Mentorship Academy
  • Home
  • About CiAI
  • About Us
    • Our Story
    • Vision & Mission
    • Curriculum Director
    • Meet The Team
    • Our Approach
    • Why Datasosi
  • FAQ’s
  • Academies
    • Coding Academy
    • AI Academy
    • Data Science Academy
    • Business Intelligence Academy
  • Blog
  • Contact Us
    • Submit Ticket
0

Currently Empty: USD$0.00

Continue shopping

Try for free
DataSosiDataSosi
  • Home
  • About CiAI
  • About Us
    • Our Story
    • Vision & Mission
    • Curriculum Director
    • Meet The Team
    • Our Approach
    • Why Datasosi
  • FAQ’s
  • Academies
    • Coding Academy
    • AI Academy
    • Data Science Academy
    • Business Intelligence Academy
  • Blog
  • Contact Us
    • Submit Ticket
Home Β» Courses Β» SQL Intermediate

SQL Intermediate

  • By admincourse
    (0.0/ 0 Rating)
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape

Current Status

Not Enrolled
Enroll in this course to get access

Price

USD$15.99 /month

Get Started

Take this Course

Course Content

Overview 1 Topic
You don't currently have access to this content
Lesson Content
0% Complete 0/1 Steps
SQL Tables
Part 1. Advanced Retrieval Patterns
Subqueries (in SELECT, WHERE, FROM) 6 Topics
You don't currently have access to this content
Lesson Content
0% Complete 0/6 Steps
Subqueries in SELECT
Subqueries in WHERE
Subqueries in FROM
CTEs (Common Table Expressions)
Nested Subqueries
Subquery vs CTE vs Derived Table Comparison
Capstone 1 Topic
You don't currently have access to this content
Lesson Content
0% Complete 0/1 Steps
Part -1 Capstone Project
Part 2. Advanced Filtering & Logic
EXISTS
You don't currently have access to this content
ANY / ALL
You don't currently have access to this content
CASE (Advanced Patterns)
You don't currently have access to this content
COALESCE / IFNULL (Applied)
You don't currently have access to this content
CASE with Aggregations β€” Conditional Counting and Summarizing
You don't currently have access to this content
NULL-Safe Filtering β€” IS NULL and IS NOT NULL
You don't currently have access to this content
Capstone 1 Topic
You don't currently have access to this content
Lesson Content
0% Complete 0/1 Steps
Part -2 Capstone Project
Part 3. Data Cleaning with SQL
TRIM, UPPER, LOWER
You don't currently have access to this content
CAST / CONVERT
You don't currently have access to this content
Handling Messy Strings
You don't currently have access to this content
Date functions (DATEADD, DATEDIFF, EXTRACT)
You don't currently have access to this content
NULL handling and imputation (COALESCE, default values)
You don't currently have access to this content
Duplicate detection and removal (DISTINCT, GROUP BY, ROW_NUMBER)
You don't currently have access to this content
Capstone 1 Topic
You don't currently have access to this content
Lesson Content
0% Complete 0/1 Steps
Part -3 Capstone Project

Course Includes:

  • Price:$15.99
  • Lessons:17
  • Certifications:Yes
More Info
cropped-Logo-original-header-fit.png

Democratizing AIβ€”One Student at a Time, Through CiAI.

DataSoSi is the education platform of the Canadian Institute of Artificial Intelligence (CiAI).
Location:Β 
#301 – 1321 Blanshard Street
Victoria, BC V8W 0B6
Email: info@datasosi.com

Links

  • About
  • Course
  • Instructor Details

More

  • News & Articles
  • FAQ’s

Follow Us

Stay connected and follow us for the latest updates, insights, and learning resources!

Icon-facebook Icon-linkedin2 Icon-instagram Icon-twitter Icon-youtube
Copyright 2026 DataSoSi | All Rights Reserved
DataSosiDataSosi
Cancel Preloader
Sign inSign up

Sign in

Don’t have an account? Sign up
Lost your password?

Sign up

Already have an account? Sign in
Are you human? Please solve:Captcha