Instant download A Comprehensive Solution Manual for SQL Fundamentals, 3/E By John J. Patrick pdf docx epub after payment.
Product details:
- ISBN-10 : 9780137126026
- ISBN-13 : 978-0137126026
- Author: John J. Patrick
SQL for the Real World
Don’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 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, Access, and the SQL standard, this book contains more exercises, techniques, and solutions than ever before. You’ll learn exactly how to write SQL queries that are easy to understand, verify, modify, and extend–even if you’ve never worked with databases before.
Table of contents:
Chapter 1: Storing Information in Tables 1
Chapter 2: Getting Information from a Table 31
Chapter 3: Compound Conditions in the Where Clause 83
Chapter 4: Saving Your Results 133
Chapter 5: The Data Dictionary and Other Oracle Topics 171
Chapter 6: Creating Your Own Tables 209
Chapter 7: Formats, Sequences, and Indexes 245
Chapter 8: Data Integrity 281
Chapter 9: Row Functions 321
Chapter 10: Using Row Functions 361
Chapter 11: Summarizing Data 399
Chapter 12: Controlling the Level of Summarization 435
Chapter 13: Inner Joins 473
Chapter 14: Outer Joins 517
Chapter 15: Union and Union All 555
Chapter 16: Cross Joins, Self Joins, and CrossTab Queries 597
Chapter 17: Combining Tables in a Production Database 653
Chapter 18: If-Then-Else, Parameter Queries, and Subqueries 673
Chapter 19: The Multiuser Environment 721
Chapter 20: The Design of SQL 739
People also search:
SQL Fundamentals, 3/E
SQL Fundamentals, 3/E pdf
SQL Fundamentals
sql functions for beginners
what is sql fundamentals
|