SQL in 24 Hours, Sams Teach Yourself, 7th Edition

Hour 25

Bonus Workshop for the Road

What You’ll Learn in This Hour:

• ▶   Explore the expansion of the sample database used for examples and exercises

• ▶   Use SQL to define and modify new database objects

• ▶   Manage transactions within your database to create SQL queries and composite queries with multiple types of joins

• ▶   Use functions to dig deeper into information and group data sets

• ▶   Create more advanced queries with views and subqueries

• ▶   Use SQL to generate SQL code

In this hour, you expand upon the current BIRDS database and walk through numerous additional examples using the SQL knowledge you have learned in this book. Afterward, you perform a final set of exercises. The goal of this bonus hour is to bring everything together ...