Introducing the Practice2:47 with Andrew Chalkley
An overview of the reports you need to generate.
[MUSIC] 0:00 Hello world Andrew here, database user, life longer learner and 0:04 teacher here at Treehouse. 0:07 Here's another practice session for you. 0:09 Practice helps you make what you've learned last longer. 0:13 These practice sessions help you on your road to SQL mastery, 0:15 you'll be more confident and a better analyst or developer. 0:19 Let's practice some basic SQL to make sure your knowledge sticks. 0:22 This practice session covers SQL queries with simple WHERE clauses, with comparison 0:26 operators, such as equality, and inequality, and relational operators. 0:31 You'll also be tasked with writing queries with ranges and 0:36 filters with sets of values. 0:39 This practice session is intended to be a followup for 0:42 the third section of this SQL basics course. 0:45 If you haven't taken that course yet or 0:47 if you found this practice session too difficult, then take SQL basics first and 0:49 then take the other practice session before this one. 0:54 In the teacher's notes I've added a link for the course and 0:58 the other practice session. 1:01 Launch the SQL playground with this video, this SQL playground is for 1:02 an online retailer. 1:06 There are three tables, a customers table containing all customers of our retailer, 1:07 a products table that contains a list of all products that are available. 1:13 And a sales table containing all the sales entries. 1:17 Pause this video and familiarize yourself with the tables and their contents. 1:21 There are several coding areas here on the left hand side. 1:27 Each of the coding areas have a particular challenge. 1:31 Challenge one is to get all mailing information for 1:34 orders that have taken place on the 20th of April. 1:37 Challenge two is to retrieve name and 1:40 pricing information on all Playstation four models. 1:42 Think of three possible ways you could do this, and 1:46 then think about which way would be best. 1:49 Challenge three is to get the mailing address for 1:52 customers without email addresses. 1:54 This is so we can send coupons via snail mail. 1:56 Challenge four is the opposite to get a list of email addresses for 2:00 customers with an email address present. 2:04 Then we can email them coupons. 2:07 Challenge five is to check what products that we have in surplus in our warehouse. 2:09 That way we can run promotions on those products to clear some space to make way 2:13 for newer products. 2:17 Challenge six is to search for all orders with totals between $225 and $245. 2:18 The final challenge is to find all products with 4k support. 2:25 I've included a link to the SQL cheat sheet in the teacher's notes. 2:29 But try to see if you can do it without refreshing your memory 2:34 It's okay to try a couple of different queries before you get the right query. 2:37 If you're stuck and need some reference you can use the cheat sheet. 2:41 But try and do it without it first. 2:45
You need to sign up for Treehouse in order to download course files.Sign up