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.
SQL Fundamentals,Third Edition, teaches you how to
About the Web Site
The accompanying Web site, https://www.box.com/shared/ylbckg2fn0 , contains all the SQL code and tables from the book, including the full databases for several versions of Access and code for building the corresponding Oracle databases. It also provides solutions to many of the book’s problems and an open area for discussions with the author and other readers.
"synopsis" may belong to another edition of this title.
SQL Fundamentals deserves praise because it documents the implementation of Structured Query Language (SQL) in Oracle databases and Access databases simultaneously. Readers find out how to do simple single-table queries, more complicated multitable queries, table creation, joins, unions, and calculations in both environments in a variety of circumstances. For those who've never worked with SQL before and plan to use one of the two covered platforms, this book will make a fine starting point, since it explains elementary SQL concepts too.
Here's the approach: Author John J. Patrick sets out a task--for example, writing a statement that yields a left outer join of two databases. Then he proceeds to accomplish the task in both Access and Oracle, presenting the platforms' respective SQL statements side by side. The differences between the two implementations of SQL are obvious, making it easy for someone familiar with one of the two environments to adapt to the other. The reader will also find the numbered and highlighted key passages, which include details on the facing page, very helpful.
Patrick, who based this book on a university course he teaches, knows the value of practical experience--he's loaded SQL Fundamentals with exercises in addition to the tasks he completes himself. He leaves most of these to the reader but provides solutions to some of the more interesting ones. Databases for the illustrations and exercises are included on the companion CD-ROM. --David WallFrom the Back Cover:
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 for IT pros 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. SQL Fundamentals covers all this and more:
* Simple queries that retrieve information from a single table
* Creating tables and views to divide a complex process into a series of single steps
* Summarizing your data
* Inner joins, outer joins, unions, self joins, cross joins, and subqueries
* Writing SQL queries that are easily understood, verified, modified, and extended
Want better access to business data? Want to make your data more accessible to others? SQL Fundamentals delivers the practical techniques and examples you need - on the database platforms you already use! If you want to fully use the information in your database, then read this book!
The accompanying CD-ROM contains a library of Access databases and the code for building Oracle databases. All the tables used in the book are furnished in both Oracle and Access format. A website provides additional technical support to assure that all the code is completely correct and works with the latest versions of both Oracle and Access.
"About this title" may belong to another edition of this title.
Book Description Prentice Hall PTR. Book Condition: New. New 3rd Edition Ships same or next day. Expedited shipping takes 2-3 business days; standard shipping takes 4-14 business days. Bookseller Inventory # RIC-120-355
Book Description Prentice Hall. PAPERBACK. Book Condition: New. 0137126026 NEW BOOK. Bookseller Inventory # 815-1A3-55
Book Description Prentice Hall, 2008. Paperback. Book Condition: New. 3. Bookseller Inventory # DADAX0137126026
Book Description Prentice Hall, 2008. Book Condition: New. Brand New, Unread Copy in Perfect Condition. A+ Customer Service! Summary: Preface xxvChapter 1: Storing Information in Tables 1Introduction 3The Parts of a Table 9Examples of Tables 19Key Points 30Chapter 2: Getting Information from a Table 31The Select Statement 33The Select Clause 37The Where Clause 50The Order By Clause 71Key Points 80Chapter 3: Compound Conditions in the Where Clause 83Compound Conditions in the Where Clause 85Constant Values 95Punctuation Matters 102Case Sensitivity 113Three-Valued Logic 120Error Messages 122Some Exercises Solved for You 124Key Points 131Chapter 4: Saving Your Results 133Saving Your Results in a New Table or View 135Modifying the Data in a Table with SQL 151Modifying the Data in a Table with the GUI 161Restrictions on Modifying the Data in a Table 167Key Points 170Chapter 5: The Data Dictionary and Other Oracle Topics 171Commit, Rollback, and Transactions 173Modifying Data through a View 179The SQL Commands Page in Oracle 192Using the Oracle Data Dictionary - Part 1 195Key Points 207Chapter 6: Creating Your Own Tables 209Creating Tables 211Changing Tables 226Tables with Duplicate Rows 236Key Points 243Chapter 7: Formats, Sequences, and Indexes 245Formats 247Sequences 257Indexes 262Using the Oracle Data Dictionary - Part 2 266An Exercise Solved for You 278Key Points 280Chapter 8: Data Integrity 281Constraints on One Table 283Referential Integrity 289The Delete Options and Update Options of RI 303Variations of Referential Integrity 311How to Code Constraints in a Create Table Statement 316Key Points 319Chapter 9: Row Functions 321Introduction to Row Functions 323Numeric Functions 334Text Functions 340Date Functions 350Key Points 359Chapter 10: Using Row Functions 361Specialized Row Functions 363Using the Documentation of Row Functions 372Creating Patterns of Numbers and Dates 376Key Points 397Chapter 11: Summarizing Data 399Introduction to the Column Functions 401Maximum and Minimum 404Count 411Sum and Average 420Other Topics 428Key Points 434Chapter 12: Controlling the Level of Summarization 435Dividing a Table into Groups of Rows 437Eliminating Some of the Summarized Data 459Key Points 471Chapter 13: Inner Joins 473Introduction to Joins 475Inner Joins of Two Tables 479Variations of the Join Condition 495Applications of Joins 504Key Points 515Chapter 14: Outer Joins 517Introduction to Outer Joins 519Applications of Outer Joins 534Key Points 553Chapter 15: Union and Union All 555Union Basics 557Unconventional Unions 573Applications of a Union 577Set Intersection and Set Difference in Oracle 590Key Points 595Chapter 16: Cross Joins, Self Joins, and CrossTab Queries 597Cross Joins 599Self Joins 613CrossTab Queries in Access 624CrossTab Queries in Oracle 645Key Points 650Chapter 17: Combining Tables in a Production Database 653Methods of Joining Three or More Tables 655Losing Information 660Caring about the Efficiency of Your Computer 663Standardizing the Way That Tables Are Joined 666Key Points 671Chapter 18: If-Then-Else, Parameter Queries, and Subqueries 673If-Then-Else Logic 675</. Bookseller Inventory # ABE_book_new_0137126026
Book Description Prentice Hall. PAPERBACK. Book Condition: New. 0137126026 FOR QUICK DELIVERY PLEASE CHOOSE EXPEDITED SHIPPING! Great opportunity to save on this book. WE SHIP DAILY!. Bookseller Inventory # SKU1088896
Book Description Pearson P T R, 2008. PAP. Book Condition: New. New Book. Shipped from US within 10 to 14 business days. Established seller since 2000. Bookseller Inventory # KB-9780137126026
Book Description Book Condition: Brand New. Book Condition: Brand New. Bookseller Inventory # 97801371260261.0
Book Description Prentice Hall. Book Condition: New. Brand New. Bookseller Inventory # 0137126026
Book Description Prentice Hall. PAPERBACK. Book Condition: New. 0137126026 Brand New in Mint condition. Guaranteed delivery in 2-4 days when you order with Expedited Shipping! No Expedited shipping to PO Boxes. Bookseller Inventory # 0137126026
Book Description Prentice Hall. PAPERBACK. Book Condition: New. 0137126026 Brand New Book. Ships from the United States. 30 Day Satisfaction Guarantee!. Bookseller Inventory # 4712651