课程: Level Up: SQL

SQL code challenges - SQL教程

课程: Level Up: SQL

开始一个月试用 购买团队方案

SQL code challenges

“

(lively music) - Hi, I'm Scott Simpson, and welcome to this series of videos where I'll challenge you to write SQL statements to solve various problems. The challenges will start out at a low difficulty level and will become more difficult toward the end. The goal of these challenges is not to always arrive at the same conclusion I do, but to use the challenges as an opportunity to think about how to approach solving real-world problems. In these videos, we'll use two different databases, one containing information about a popular neighborhood restaurant and one containing information about a small town library which has a collection of a few hundred classic books. You can download these databases from the exercise files or from the GitHub repository, or if you're using the Code Spaces interactive environment, the files are already there for you. These databases are the files restaurant.db and library.db. In the Code Spaces environment we'll be able to view the contents of databases and we'll be able to write and run SQL code without installing anything on our local system. If you're following along in a different environment, I recommend DB Browser for SQL Lite, a free cross-platform application that works with SQL Lite databases, which you can use to explore the databases and write queries to respond to each challenge. The challenges will assume that you've already taken a look at the databases and know a little bit about their structure before writing your solutions. We'll explore how to do that in a moment, but first I'd like to introduce my colleague, Ray, to show us around the Code Spaces environment.

内容