Data Analytics
724 learners
Getting Started with SQL
Dive into the fascinating world of SQL using data from an online shopping platform as your playground. This course will help you master SQL from the ground up, teaching you how to query databases effectively, uncover hidden patterns, and drive insightful data analysis.
MySQL
5 lessons
26 practices
2 hours
Data Querying and Retrieval
Lessons and practices
Running Your First SQL Queries
Selecting all Records from Categories Table
Displaying All Records from the Categories Table
Unveiling the Database's Tables
Exploring Database Tables with SQL
Selecting Specific Columns in SQL
Selecting Columns with Aliases in SQL
Fix the SQL Query
Renaming Columns with SQL
Navigating Advanced SQL Queries
Select Orders After 2020
Selecting Specific Orders Using SQL
Filtering Shop Orders Effortlessly
Fixing an SQL Query to Filter by Year
Selecting Orders by Year
Using the AND Operator in SQL Queries
Refining SQL Query with AND Operator
Using the IN Operator for Orders Selection
Using BETWEEN Operator to Filter Order Dates
Fetch Data with Logical Operators in SQL Queries
Selecting All Products
Sorting Product Names Reverse Alphabetically
Sorting Orders by Date
Using ORDER BY with Conditional Filtering
Sorting Filtered Products by Price
Sorting Selected Category Products by Price
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
