Skip to content
Login/Register
Email: info@datasosi.com
Category
Foundation Campus: Self-paced Learning
Foundation Courses
Mentorship Academy
Home
About Us
Instructor
Vision & Mission
Our Approach
FAQ’s
Blog
Contact Us
Submit Ticket
CodeCore
Explore All Courses
0
Currently Empty:
USD
$
0
.00
Continue shopping
Try for free
Home
About Us
Instructor
Vision & Mission
Our Approach
FAQ’s
Blog
Contact Us
Submit Ticket
CodeCore
Explore All Courses
Home
Course
SQL Intermediate
SQL Intermediate
By admincourse
(0.0/ 0 Rating)
Current Status
Not Enrolled
This course is not available
Price
USD$17.23 /month
Course Content
Expand All
Lessons
Overview
Part 1. Advanced Retrieval Patterns
Subqueries (in SELECT, WHERE, FROM)
6 Topics
Expand
Subqueries (in SELECT, WHERE, FROM)
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
Part 2. Advanced Filtering & Logic
EXISTS
ANY / ALL
CASE (Advanced Patterns)
COALESCE / IFNULL (Applied)
CASE with Aggregations — Conditional Counting and Summarizing
NULL-Safe Filtering — IS NULL and IS NOT NULL
Part 3. Data Cleaning with SQL
TRIM, UPPER, LOWER
CAST / CONVERT
Handling Messy Strings
Date functions (DATEADD, DATEDIFF, EXTRACT)
NULL handling and imputation (COALESCE, default values)
Duplicate detection and removal (DISTINCT, GROUP BY, ROW_NUMBER)
Course Includes:
Price:
$17.23
Lessons:
14
Certifications:
No
More Info
Cancel Preloader
Sign in
Sign up
Sign in
Don’t have an account?
Sign up
Remember me
Lost your password?
Sign up
Already have an account?
Sign in
Login
Accessing this course requires a login. Please enter your credentials below!
Username or Email Address
Password
Remember Me
Lost Your Password?
Register
Don't have an account? Register one!
Register an Account
Lessons:14
Lessons:14