Data Analytics
724 learners
Advanced Query Techniques and Conditional Logic in SQL
This advanced SQL course will enhance your ability to write complex queries, use conditional logic, and conduct sophisticated data analysis. Ideal for learners who have mastered basic SQL and are eager to tackle more challenging problems.
MySQL
4 lessons
20 practices
1 hour
Data Querying and Retrieval
Lessons and practices
Fix SQL Query Syntax Error
Logical Operations in SQL Queries
Refining SQL Queries with Conditions
Logical Operations with AND/OR in SQL Queries
Retrieve Specific Order Details
Fix the SQL Query for Retrieving Products
Filtering Products with BETWEEN
Finding Orders from 2022
Utilizing Conditional Operators in SQL
Utilize SQL Conditional Operators
Fixing Errors in Subqueries
Subqueries in Action
Refining Product Pricing Queries
Mastering Subqueries for Data Analysis
Subquery Magic in Action
Categorize Orders with IF Function
Categorize Orders by Date
Categorize Products by Price
Creating and Querying Products Statistics in SQL
Categorizing Products with SQL
Meet Cosmo:
The smartest AI guide in the universe
Our built-in AI guide and tutor, Cosmo, prompts you with challenges that are built just for you and unblocks you when you get stuck.
Join the 1M+ learners on CodeSignal
Be a part of our community of 1M+ users who develop and demonstrate their skills on CodeSignal
