Data Analytics
752 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 Match Details
First Half Match Events
Filtering Match Events with BETWEEN
Finding Matches from 2005
Utilizing Conditional Operators in SQL
Utilize SQL Conditional Operators
Fixing Errors in Subqueries
Subqueries in Action
Refining Event Timing Queries
Mastering Subqueries for Data Analysis
Subquery Magic in Action
Categorize Matches with IF Function
Categorize Matches by Date
Categorize Match Events by Minutes
Creating and Querying Match Statistics in SQL
Categorizing Match Events 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
