Hour 7. Introduction to the Database Query

What You’ll Learn in This Hour:

What a database query is

How to use the SELECT statement

Adding conditions to queries using the WHERE clause

Using column aliases

Selecting data from another user’s table

In this seventh hour, you learn about database queries, which involve the use of the SELECT statement. The SELECT statement is the most frequently used of all SQL commands after a database’s establishment. The SELECT statement enables you to view data that is stored in the database.

What Is a Query?

A query is an inquiry into the database using the SELECT statement. A query is used to extract data from the database in a readable format according to the user’s request. For instance, if you ...

Get Sams Teach Yourself SQL in 24 Hours, Fifth Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.