Table of Contents: SQL Practice Pack
Lost? No problem! Here's a complete table of contents for this course:
Get started here - we'll go over what you'll learn in this course and how to navigate through sections and lessons.
Let's get started with an introduction to Cocoa Confections and its database.
Let's try using CREATE and INSERT commands to make a new table and insert a row of data.
Can you create a foreign key that will link Cocoa Confections' order and products tables?
Bills, bills, bills
One of Cocoa Confections' customers wants to see a summary of her payment history. Can you write a SELECT query to help out?
Cocoa Confections has added a new column to its customers table to keep track of referrals. Let's check it out!
Use SELECT and UPDATE queries to correct a mistake that Emma has made in her database.
It's time to get fancy with SELECT queries: we need to pull the e-mail addresses of customers who have ordered Cookies - but only if those customers have Gmail addresses.
Emma wants to project Pie sales for the next year - and to do that, she'll need some historical data. Can you help her out?
Case in point
Emma and her marketing manager, Jim, are having something of a disagreement. Can you write a query to help them resolve it?
It's the end of the year, and Emma wants to send 'thank-you' notes to her top customers. Let's write a query to help her out!