A Guide to SQL
- Length: 320 pages
- Edition: 1
- Language: English
- Publisher: Cengage Learning
- Publication Date: 2020-08-04
- ISBN-10: 0357361687
- ISBN-13: 9780357361689
- Sales Rank: #400023 (See Top 100 Books)
Master today’s SQL programming principles and learn how to most effectively apply your SQL skills with Shellman/Afyouni/Pratt/Last’s A GUIDE TO SQL, Tenth Edition. This edition’s leading approach combines straightforward instruction and extensive hands-on exercises with a strong foundation and emphasis on today’s actual business applications. This edition introduces basic SQL commands in the context of an intriguing, ongoing case in which a business uses SQL to manage orders, items, customers and sales reps. This edition emphasizes how to apply fundamental principles and strengthen your programming practices, regardless of the database environment. You work with examples from the latest versions of MySQL, the world’s most popular open source, free database, as well as Oracle and Microsoft SQL Server. In addition, MindTap digital learning solution is available to help you strengthen your SQL skills.
A Guide to SQL Table of Contents Preface About the Authors Module 1: Introduction to KimTay Pet Supplies and StayWell Student Accommodation Databases Introduction What Is a Database? The KimTay Pet Supplies Database StayWell Student Accommodation Database Module Summary Key Term Case Exercises Module 2: Database Design Fundamentals Introduction Database Concepts Functional Dependence Primary Keys Database Design Normalization Diagrams for Database Design Module Summary Key Terms Review Questions Case Exercises Module 3: Creating Tables Introduction Creating and Running SQL Commands Creating a Database Creating a Table Using Data Types Using Nulls Adding Rows to a Table Viewing Table Data Correcting Errors in a Table Saving SQL Commands Creating the Remaining Database Tables Describing a Table Module Summary Key Terms Review Questions Case Exercises Module 4; Single-Table Queries Introduction Constructing Simple Queries Sorting Using Functions Nesting Queries Grouping Nulls Summary of SQL Clauses, Functions, and Operators Module Summary Key Terms Review Questions Case Exercises KimTay Pet Supplies StayWell Student Accommodation Module 5: Multiple-Table Queries Introduction Querying Multiple Tables Comparing Joins, IN, and EXISTS Set Operations ALL and ANY Special Operations Module Summary Key Terms Review Questions Case Exercises KimTay Pet Supplies StayWell Student Accommodation Module 6: Updating Data Introduction Creating a New Table from an Existing Table Changing Existing Data in a Table Adding New Rows to an Existing Table Autocommit, Commit, and Rollback Transactions Changing and Deleting Existing Rows Changing a Value in a Column to Null Changing a Table’s Structure Dropping a Table Module Summary Key Terms Review Questions Case Exercises KimTay Pet Supplies StayWell Student Accommodation Module 7: Database Administration Introduction Creating and using Views Using a View to Update Data Dropping a View Security Indexes System Catalog Integrity Constraints in SQL Module Summary Key Terms Review Questions Case Exercises Module 8: Functions, Procedures, and Triggers Introduction Using SQL in a Programming Environment Using Functions Concatenating Columns Stored Procedures Using MySQL Error Handling Using Update Procedures Selecting Multiple Rows with a Procedure Using PL/SQL in Oracle Using T-SQL in SQL Server Using a Trigger Module Summary Key Terms Review Questions Case Exercises KimTay Pet Supplies StayWell Student Accommodation Appendix A: SQL Reference Appendix B: How Do I Reference Appendix C: The 10 Commandments of Writing Queries Index
Donate to keep this site alive
1. Disable the AdBlock plugin. Otherwise, you may not get any links.
2. Solve the CAPTCHA.
3. Click download link.
4. Lead to download server to download.