# Advanced Querying - Introduction
# Initialize the Magic Store Database
- DROP the tables from your previous assignment(s), if necessary
- Run the following script to populate your database -> MagicStoreScript (github.com)
- Magic Store Database Overview: SQL - W3 Magic Store Database Overview
SQL - W3 Magic Store Database Overview
Magic Store Database Overview Initialize the Magic Store Database DROP the tables from your previous assignment(s), if necessary Run the following script to...
# Lessons
- SQL - W10 Advanced Querying - Introduction
- Next: SQL - W10 Advanced Querying - Aggregate Functions
SQL - W10 Advanced Querying - Aggregate Functions
Advanced Querying - Aggregate Functions Practice Questions Use the magic store database for the following queries. Write a query to find the total...
- SQL - W10 Advanced Querying - Column Aliasing
SQL - W10 Advanced Querying - Column Aliasing
Advanced Querying - Column Aliasing Practice Questions Use the magic store database for the following queries. Write a query to show all products...
- SQL - W10 Advanced Querying - Calculating Values
SQL - W10 Advanced Querying - Calculating Values
Advanced Querying Topics Part 1 - Calculating Values Practice Questions Use the magic store database for the following queries. Write a query to...
- SQL - W10 Advanced Querying - Northwind Database
SQL - W10 Advanced Querying - Northwind Database
Northwind Database Initialize the Northwind Database DROP the tables from your previous assignment(s), if necessary Run the following script to populate your database...
- SQL - W10 Advanced Querying - GROUP BY
- SQL - W10 Advanced Querying - Data Analytics with GROUP BY
- SQL - W10 Advanced Querying and Data Analytics Assignment
SQL - W10 Advanced Querying and Data Analytics Assignment
Advanced Querying and Data Analytics Assignment Use the Magic Store database for the following queries. Each query is worth 5 points. Write...