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 ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access