Publisher's Synopsis
Students won't just learn "generic" SQL: they'll learn SQL to get results with the world's top database platforms: Oracle 12c for the enterprise and Microsoft Access 2016 for the desktop. Based on John Patrick's legendary hands-on SQL course at the University of California, Berkeley Extension, this book shows exactly how to retrieve the data you want, when you need it, in any application: from ad hoc reports to the data warehouse. Thoroughly updated for the newest versions of Oracle and Access, this book contains more exercises, techniques, and solutions than ever before, including more than 200 downloadable code examples. Students learn exactly how to write SQL queries that are easy to understand, verify, modify, and extend-even if they've never worked with databases before.
SQL Fundamentals, Fourth Edition teaches students how to
- Build simple statements to retrieve, store, or modify data
- Craft complex queries that draw information from multiple tables
- Sort and summarize data
- Create and edit tables
- Protect the integrity of data
- Create more efficient, high-performance queries
- Work with unions, subqueries, self joins, cross joins, inner joins, and outer joins
- Use the Oracle Data Dictionary, and more
This guide is perfect for beginners who want to thoroughly understand SQL and its features, and for everyone who wants to write SQL code that will work in the real world!
