Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Getting Started with SQL

Go to class Write review

Overview

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.

Syllabus

Unit 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

Unit 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

Unit 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

Unit 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

Unit 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

Reviews

Start your review of Getting Started with SQL