SQL for Oracle, Access--and the real world!The hands-on, real-world SQL guide for every business and IT professionalMaster SQL for the world's two top databases: Oracle and Microsoft AccessHow to write SQL queries that are easy to understand, verify, modify, and extendCovers everything from basic SELECT statements to complex joinsCD-ROM: extensive library of sample databases and codeDon't just learn "generic" SQL: learn SQL to get results with the world's top database platforms-Oracle for the enterprise, and Microsoft Access for the desktop! Based on John Patrick's hands-on SQL course at the University of California, Berkeley, 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. From the simplest SELECT statements to the most sophisticated joins, Patrick shows you exactly how to write SQL queries that are easy to understand, verify, modify, and extend. "SQL Fundamentals, Second Edition" teaches you to: Write simple statements to retrieve, store, or modify dataBuild complex queries that draw information from multiple tablesCreate your own tablesSummarize your data: basic and advanced techniquesUnderstand and ensure data integrityWork with unions, subqueries, self joins, cross joins, inner joins, and outer joinsCD-ROM INCLUDEDThe accompanying CD-ROM contains all the SQL code and tables from the book, Microsoft Access databases, and code for building the corresponding Oracle databases.