Introduction to SQL
Learn what SQL is and explore different types of commands that can be used in it.
We'll cover the following...
Imagine running a popular online store.
Every day, thousands of customers place orders, new products are added, and stock levels fluctuate. To make informed business decisions, we need answers to questions such as: What were our top ten best-selling products last month? Or which customers have not made a purchase in the past six months?
But how do we ask our database for this information? We cannot simply type the question in plain English. We need a specialized language that the database can interpret—Structured Query Language (SQL). Welcome to the world of SQL!
It is the tool that enables us to unlock the potential of the relational databases we have been studying.
By the end of this lesson, we will be able to:
Explain what SQL is and why it’s the industry standard for relational databases.
Understand the different categories of SQL commands.
Set up a complete, working database environment on our own computer.
Load our course database,
OnlineStore, so we’re ready for the hands-on lessons ahead. ...