Table of Contents: SQL Practice Pack
Lost? No problem! Here's a complete table of contents for this course:
Introduction
Introduction
Get started here - we'll go over what you'll learn in this course and how to navigate through sections and lessons.
Practice questions
Cocoa Confections
Let's get started with an introduction to Cocoa Confections and its database.
Getting productive
Let's try using CREATE and INSERT commands to make a new table and insert a row of data.
Making connections
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?
Referral fever
Cocoa Confections has added a new column to its customers table to keep track of referrals. Let's check it out!
Oopsie Daisy!
Use SELECT and UPDATE queries to correct a mistake that Emma has made in her database.
Cookie coupons
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.
Pie projections
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?
Cha-ching!
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!