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.
Lessons and practices
Lesson 1: Exploring Databases and Relational Data Structures
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
Lesson 2: Navigating the SQL SELECT Statement
Selecting Specific Columns in SQL
Selecting Columns with Aliases in SQL
Fix the SQL Query
Renaming Columns with SQL
Navigating Advanced SQL Queries
Lesson 3: Application of WHERE Clause
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
Lesson 4: Mastering SELECT Statements with Logical Operators
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
Lesson 5: Understanding ORDER BY Clause for Sorting Data
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
Interested in this course? Learn and practice with Cosmo!
Practice is how you turn knowledge into actual skills.