LESSON 2Introducing the Query
Welcome to Lesson 2! By the end of this lesson, you will be able to do the following:
• Understand what a query is and how it is used.
• Understand the syntax and use of SELECT and FROM.
• Select and list all rows and columns from a table.
• Select and list specific columns from a table.
• Select and list columns from different tables.
Exploring SQL’s Background
To fully use the power of a relational database as described briefly in Lesson 1, “Getting Started with SQL,” you need to communicate with it. The ultimate communication would be to turn to your computer and say, in a clear, distinct voice, “Show me all the left-handed, brown-eyed bean counters who have worked for this company for at least 10 years.” A ...
Get Sams Teach Yourself SQL in One Hour a Day, 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.
