From the course: SQL Practice: Intermediate Queries
What you should know - SQL Tutorial
From the course: SQL Practice: Intermediate Queries
What you should know
- [Tutor] In this Code Challenge Course, I expect you to be familiar with writing queries in SQL. We'll spend time grouping and filtering data, joining tables, and transforming values. These challenges each combine a couple of intermediate difficulty concepts, that are often used in data reporting and data preparation. If you need to refresh your SQL knowledge, take a look at these courses in the LinkedIn Learning Library. In the challenges, we provide a database that describes a small neighborhood restaurant. We'll see tables like employees, reservations, orders, dishes, and so on. Each challenge will give you an entity relationship diagram to describe the table or tables being used. And feel free to SELECT * on the tables to look at the actual data. If you do, the interface will show that output is a wrong answer. But don't worry, there's no points or time, or anything like that, that you'll lose or risk having taken away. To work on these challenges, you don't need to install any separate software. The Coding Challenge environment is part of the LinkedIn Learning COurse Page. We'll explore how that works in the next video!
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.