Introducing the Practice2:34 with Andrew Chalkley
An overview of the reports you need to generate.
[MUSIC] 0:00 Hello world Andrew here, database user, lifelong learner and 0:04 teacher here at Treehouse. 0:07 Here's more practice for you. 0:09 Practice helps you make what you've learned last longer. 0:11 These practice sessions are to help you on your road to SQL mastery. 0:14 You'll be more confident and a better analyst or developer. 0:18 So let's practice some more basic SQL to make sure your knowledge sticks. 0:22 This practice session covers simple SQL queries. 0:27 From selecting all information from a table, and 0:30 selecting and aliasing specific columns. 0:33 This practice session is intended to follow up 0:36 after the second section of the SQL basics course. 0:38 If you haven't taken that course already or 0:42 find this practice session too difficult then take the SQL Basics course first. 0:44 Check the teachers note for a link to the course. 0:50 Launch the SQL Playground with this video. 0:53 This SQL Playground is for an online retailer. 0:55 There are three tables, a customers table containing all customers for our retailer. 0:58 A products table that lists all the products available and 1:05 a sales table listing all the sales entries. 1:09 Pause the video and familiarize yourself with the tables. 1:13 There are several coding areas on the left here, each with a particular challenge. 1:17 The first challenge is to retrieve all product information. 1:23 The second challenge is to create a mailing list for email marketing. 1:28 You'll be tasked to retrieve the first and last names and the email address. 1:32 Third, you're going to create a list of information containing customer names and 1:37 addresses to send to the marketing department. 1:41 The marketing department can then send out a physical coupon for 1:45 each of our customers. 1:48 Fourth you need to create a list of names and addresses associated with 1:50 the orders to create mailing labels for packages to be sent out. 1:55 Finally, imagine you're creating a report for a colleague. 1:59 Present all relevant information from the sales for 2:03 someone who wants to know what was sold and how much revenue was generated. 2:06 Instead of using column names at the top of each column, include aliases for 2:11 the sales table. 2:16 I've included a link to the SQL Basics cheat sheet in the teacher's notes but 2:17 try to see if you can do it without refreshing your memory. 2:21 It's okay to try a couple of different queries before you get the right query. 2:24 If you're stuck and need reference, use the cheat sheet. 2:28 But try to do it without the cheat sheet first. 2:32
You need to sign up for Treehouse in order to download course files.Sign up