What you should know - SQL教程

- [Instructor] This course is designed for anybody using a relational database, that is, a database that can support multiple tables that can be joined at runtime using queries. Different database products use different versions of SQL. This particular course is built around code challenges that run on something called the H2 Database Engine. This is an open source database product that can mimic the behavior of various database products. These code challenges work with H2 Database Engine in its compatibility mode, which means that its syntax is the same as with the product MySQL and MariaDB. When working through these code challenges, you'll be using a database schema, a set of tables that are designed to link together. They're built for a fictional restaurant brand, and so you have customers of the restaurant, dishes that the restaurant serves, orders, a table that links the orders and dishes tables together, and then reservations and events. None of the code challenges are going to use all of these tables, and at the beginning of each challenge, I'll show you which tables in this schema will be used. Before you try these challenges, you may want to watch some instructional content, and I highly recommend the course SQL Essential Training, which takes you through the basic concepts of SQL and the most common commands that you'll use when you work with relational databases.