The SQL MicroDegree 2022: From SQL Basics To MySQL Mastery

Extract product names and unit prices from the products table, then create a new price column by multiplying unit price by two and display both columns.

Combine multiple conditions using and, or, and not to filter customers by birth date, points, and state. Learn operator precedence, how parentheses alter evaluation, and how not negates a condition.

Identify missing data with the NULL operator in SQL and filter customers by phone number using where is null or not, highlighting those without a phone number.

Learn how to join the items table with the products table using the product key and display each product’s name with the price the customer paid.

Perform multi-table joins on payments, clients, and payment_method to produce a concise result showing date, customer name, amount, and payment method name, using explicit join syntax and aliases.

Insert hierarchical rows across related tables by using insert into, last_insert_id, and referential integrity between the order and order_items tables in a relational database.

This exercise demonstrates updating the comments of customers with points greater than 3000 to the string gold via a nested query, focusing on customer_id for the update.

Explore the rollup operator in SQL to sum values from aggregate results, generating subtotals by state and city and an overall total.

Master date and time operations using date add to append days, months, or years to the date, and use date diff and time to set to compute seconds since midnight.

Explore how to replace multiple if conditions with the case operator in SQL, labeling orders by year as current, active, or archived, and handling future cases.

Update or delete views using drop view and create or replace view, and save view scripts to folders for reuse alongside stored procedures.

Discover how to drop a stored procedure, use if exists checks to delete or recreate it safely, and save or share the new procedure with your team.