Week 1: At a Glance
Week 1 introduces SQL from a historical and theoretical perspective. The first statement you learn about is the SELECT statement, which enables you to retrieve data from the database based on various user-specified options. During Week 1, you study SQL functions, query joins, and SQL subqueries (a query within a query). Many examples help you understand these important topics. These examples use Oracle, Sybase SQL Server, Microsoft Access, and Microsoft Query, and they highlight some of the similarities and differences among the products. The content of the examples should be useful and interesting to a broad group of readers.
Week 1 covers the following:
Day 1 covers some of the preliminary terms and concepts that you need ...
Get Sams Teach Yourself SQL in 21 Days, Fourth 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.
