SQL Fundamentals
Home > Business and Economics > Business and Management > Management and management techniques > Knowledge management > SQL Fundamentals
SQL Fundamentals

SQL Fundamentals


     0     
5
4
3
2
1



Out of Stock


Notify me when this book is in stock
X
About the Book

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 Build simple statements to retrieve, store, or modify data Craft complex queries that draw information from multiple tables Sort and summarize your data just the way you want it Create and edit your own tables Protect the integrity of your 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 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.

Table of Contents:
Preface xxv   Chapter 1: Storing Information in Tables 1 Introduction 3 The Parts of a Table 9 Examples of Tables 19 Key Points 30   Chapter 2: Getting Information from a Table 31 The Select Statement 33 The Select Clause 37 The Where Clause 50 The Order By Clause 71 Key Points 80   Chapter 3: Compound Conditions in the Where Clause 83 Compound Conditions in the Where Clause 85 Constant Values 95 Punctuation Matters 102 Case Sensitivity 113 Three-Valued Logic 120 Error Messages 122 Some Exercises Solved for You 124 Key Points 131   Chapter 4: Saving Your Results 133 Saving Your Results in a New Table or View 135 Modifying the Data in a Table with SQL 151 Modifying the Data in a Table with the GUI 161 Restrictions on Modifying the Data in a Table 167 Key Points 170   Chapter 5: The Data Dictionary and Other Oracle Topics 171 Commit, Rollback, and Transactions 173 Modifying Data through a View 179 The SQL Commands Page in Oracle 192 Using the Oracle Data Dictionary – Part 1 195 Key Points 207   Chapter 6: Creating Your Own Tables 209 Creating Tables 211 Changing Tables 226 Tables with Duplicate Rows 236 Key Points 243   Chapter 7: Formats, Sequences, and Indexes 245 Formats 247 Sequences 257 Indexes 262 Using the Oracle Data Dictionary – Part 2 266 An Exercise Solved for You 278 Key Points 280   Chapter 8: Data Integrity 281 Constraints on One Table 283 Referential Integrity 289 The Delete Options and Update Options of RI 303 Variations of Referential Integrity 311 How to Code Constraints in a Create Table Statement 316 Key Points 319   Chapter 9: Row Functions 321 Introduction to Row Functions 323 Numeric Functions 334 Text Functions 340 Date Functions 350 Key Points 359   Chapter 10: Using Row Functions 361 Specialized Row Functions 363 Using the Documentation of Row Functions 372 Creating Patterns of Numbers and Dates 376 Key Points 397   Chapter 11: Summarizing Data 399 Introduction to the Column Functions 401 Maximum and Minimum 404 Count 411 Sum and Average 420 Other Topics 428 Key Points 434   Chapter 12: Controlling the Level of Summarization 435 Dividing a Table into Groups of Rows 437 Eliminating Some of the Summarized Data 459 Key Points 471   Chapter 13: Inner Joins 473 Introduction to Joins 475 Inner Joins of Two Tables 479 Variations of the Join Condition 495 Applications of Joins 504 Key Points 515   Chapter 14: Outer Joins 517 Introduction to Outer Joins 519 Applications of Outer Joins 534 Key Points 553   Chapter 15: Union and Union All 555 Union Basics 557 Unconventional Unions 573 Applications of a Union 577 Set Intersection and Set Difference in Oracle 590 Key Points 595   Chapter 16: Cross Joins, Self Joins, and CrossTab Queries 597 Cross Joins 599 Self Joins 613 CrossTab Queries in Access 624 CrossTab Queries in Oracle 645 Key Points 650   Chapter 17: Combining Tables in a Production Database 653 Methods of Joining Three or More Tables 655 Losing Information 660 Caring about the Efficiency of Your Computer 663 Standardizing the Way That Tables Are Joined 666 Key Points 671   Chapter 18: If-Then-Else, Parameter Queries, and Subqueries 673 If-Then-Else Logic 675 Parameter Queries 689 Subqueries 700 Applications of Subqueries 710 Older Features of Subqueries 714 Key Points 719   Chapter 19: The Multiuser Environment 721 Database Configurations 723 Operating in a Multiuser Environment 727 Security and Privileges 732 The Oracle Data Dictionary and the Multiuser Environment 736 Key Points 738   Chapter 20: The Design of SQL 739 Original SQL Design Objectives 741 Newer Interfaces 743 Typical Applications 748 Key Points 749   Appendix A: Oracle Is Free: How to Get Your Copy 751 Getting Current Information 752 Which Version of Oracle Should You Get? 752 System Requirements 753 Downloading Oracle from the Internet 753 Installing Oracle 754 Setup to Run the Examples in This Book 754 How to Stop Running Oracle 763 What to Do if Oracle Slows Down Your Computer 763   Appendix B: Quick Start with Oracle 765 Log in to Your Computer 766 Go to the Database Home Page 766 Log in to the Oracle Database 768 Go to the SQL Commands Page 768 Enter and Run an SQL Query 769 Optional: Print Your Query and the Results 770   Appendix C: Quick Start with Access 771 You May Use Access 2007, 2003, 2002, or 2000 772 How to Start Access 772 Entering an SQL Query 774 Dealing with Errors in Access 776 Printing from Access 777 Using the Access Trust Center 778   Appendix D: Diagram of the Lunches Database 783 Join Conditions 784 Data Validation Rules 785   Index 787

About the Author :
John J. Patrick is a computer consultant and software developer specializing in relational database technology. He teaches SQL Fundamentals and other database courses at the University of California, Berkeley Extension, and has more than twenty years of experience in software development at Bank of America, Chevron, Kaiser Permanente, and other leading firms.


Best Sellers


Product Details
  • ISBN-13: 9780137156139
  • Publisher: Pearson Education (US)
  • Publisher Imprint: Pearson
  • Language: English
  • Weight: 1 gr
  • ISBN-10: 0137156138
  • Publisher Date: 26 Aug 2008
  • Binding: Digital download
  • No of Pages: 832


Similar Products

Add Photo
Add Photo

Customer Reviews

REVIEWS      0     
Click Here To Be The First to Review this Product
SQL Fundamentals
Pearson Education (US) -
SQL Fundamentals
Writing guidlines
We want to publish your review, so please:
  • keep your review on the product. Review's that defame author's character will be rejected.
  • Keep your review focused on the product.
  • Avoid writing about customer service. contact us instead if you have issue requiring immediate attention.
  • Refrain from mentioning competitors or the specific price you paid for the product.
  • Do not include any personally identifiable information, such as full names.

SQL Fundamentals

Required fields are marked with *

Review Title*
Review
    Add Photo Add up to 6 photos
    Would you recommend this product to a friend?
    Tag this Book Read more
    Does your review contain spoilers?
    What type of reader best describes you?
    I agree to the terms & conditions
    You may receive emails regarding this submission. Any emails will include the ability to opt-out of future communications.

    CUSTOMER RATINGS AND REVIEWS AND QUESTIONS AND ANSWERS TERMS OF USE

    These Terms of Use govern your conduct associated with the Customer Ratings and Reviews and/or Questions and Answers service offered by Bookswagon (the "CRR Service").


    By submitting any content to Bookswagon, you guarantee that:
    • You are the sole author and owner of the intellectual property rights in the content;
    • All "moral rights" that you may have in such content have been voluntarily waived by you;
    • All content that you post is accurate;
    • You are at least 13 years old;
    • Use of the content you supply does not violate these Terms of Use and will not cause injury to any person or entity.
    You further agree that you may not submit any content:
    • That is known by you to be false, inaccurate or misleading;
    • That infringes any third party's copyright, patent, trademark, trade secret or other proprietary rights or rights of publicity or privacy;
    • That violates any law, statute, ordinance or regulation (including, but not limited to, those governing, consumer protection, unfair competition, anti-discrimination or false advertising);
    • That is, or may reasonably be considered to be, defamatory, libelous, hateful, racially or religiously biased or offensive, unlawfully threatening or unlawfully harassing to any individual, partnership or corporation;
    • For which you were compensated or granted any consideration by any unapproved third party;
    • That includes any information that references other websites, addresses, email addresses, contact information or phone numbers;
    • That contains any computer viruses, worms or other potentially damaging computer programs or files.
    You agree to indemnify and hold Bookswagon (and its officers, directors, agents, subsidiaries, joint ventures, employees and third-party service providers, including but not limited to Bazaarvoice, Inc.), harmless from all claims, demands, and damages (actual and consequential) of every kind and nature, known and unknown including reasonable attorneys' fees, arising out of a breach of your representations and warranties set forth above, or your violation of any law or the rights of a third party.


    For any content that you submit, you grant Bookswagon a perpetual, irrevocable, royalty-free, transferable right and license to use, copy, modify, delete in its entirety, adapt, publish, translate, create derivative works from and/or sell, transfer, and/or distribute such content and/or incorporate such content into any form, medium or technology throughout the world without compensation to you. Additionally,  Bookswagon may transfer or share any personal information that you submit with its third-party service providers, including but not limited to Bazaarvoice, Inc. in accordance with  Privacy Policy


    All content that you submit may be used at Bookswagon's sole discretion. Bookswagon reserves the right to change, condense, withhold publication, remove or delete any content on Bookswagon's website that Bookswagon deems, in its sole discretion, to violate the content guidelines or any other provision of these Terms of Use.  Bookswagon does not guarantee that you will have any recourse through Bookswagon to edit or delete any content you have submitted. Ratings and written comments are generally posted within two to four business days. However, Bookswagon reserves the right to remove or to refuse to post any submission to the extent authorized by law. You acknowledge that you, not Bookswagon, are responsible for the contents of your submission. None of the content that you submit shall be subject to any obligation of confidence on the part of Bookswagon, its agents, subsidiaries, affiliates, partners or third party service providers (including but not limited to Bazaarvoice, Inc.)and their respective directors, officers and employees.

    Accept

    New Arrivals


    Inspired by your browsing history


    Your review has been submitted!

    You've already reviewed this product!