O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Sams Teach Yourself SQL in 24 Hours, Fifth Edition

Book Description

Master all the fundamentals of modern SQL -- hands-on, step-by-step!

¿

  • The up-to-the-minute SQL tutorial for everyone who wants to create applications, query data, or manage databases

  • Updated to cover the latest ANSI/ISO standards, plus powerful Oracle and SQL Server extensions

  • Covers everything from the basics through optimization, security, and enterprise techniques

  • Step-by-step instructions, examples, quizzes, exercises, and tips

In just 24 sessions of one hour or less, beginning-to-intermediate-level readers learn how to use SQL to build effective databases, efficiently retrieve data, and manage everything from performance to security! Using this book's straightforward, step-by-step approach, you learn hands-on, through practical examples based on the free, open source MySQL database. One step at a time, you discover how to define efficient database structures, objects, and tables edit data and tables manage transactions write effective queries categorize, summarize, sort, group, and restructure data use joins and subqueries manage databases, users, and security use views, synonyms, and system catalogs extend SQL to the enterprise and Internet even master important Oracle and Microsoft SQL Server extensions. Step-by-step instructions carefully walk through common questions, issues, and tasks... Q and As, Quizzes, and Exercises help you build and test your knowledge... Notes, Tips, and Cautions point out shortcuts, solutions, and problems to avoid. Each lesson builds on what you've already learned, delivering a strong real-world foundation for success with any relational database environment or application!

Table of Contents

  1. Title Page
  2. Copyright Page
  3. Dedication
  4. Contents at a Glance
  5. Table of Contents
  6. About the Author
  7. Acknowledgments
  8. We Want to Hear from You!
  9. Reader Services
  10. Part I: An SQL Concepts Overview
    1. Hour 1. Welcome to the World of SQL
  11. Part II: Building Your Database
    1. Hour 2. Defining Data Structures
    2. Hour 3. Managing Database Objects
    3. Hour 4. The Normalization Process
    4. Hour 5. Manipulating Data
    5. Hour 6. Managing Database Transactions
  12. Part III: Getting Effective Results from Queries
    1. Hour 7. Introduction to the Database Query
    2. Hour 8. Using Operators to Categorize Data
    3. Hour 9. Summarizing Data Results from a Query
    4. Hour 10. Sorting and Grouping Data
    5. Hour 11. Restructuring the Appearance of Data
    6. Hour 12. Understanding Dates and Times
  13. Part IV: Building Sophisticated Database Queries
    1. Hour 13. Joining Tables in Queries
    2. Hour 14. Using Subqueries to Define Unknown Data
    3. Hour 15. Combining Multiple Queries into One
  14. Part V: SQL Performance Tuning
    1. Hour 16. Using Indexes to Improve Performance
    2. Hour 17. Improving Database Performance
  15. Part VI: Using SQL to Manage Users and Security
    1. Hour 18. Managing Database Users
    2. Hour 19. Managing Database Security
  16. Part VII: Summarized Data Structures
    1. Hour 20. Creating and Using Views and Synonyms
    2. Hour 21. Working with the System Catalog
  17. Part VIII: Applying SQL Fundamentals in Today’s World
    1. Hour 22. Advanced SQL Topics
    2. Hour 23. Extending SQL to the Enterprise, the Internet, and the Intranet
    3. Hour 24. Extensions to Standard SQL
  18. Part IX: Appendixes
    1. A. Common SQL Commands
    2. B. Using the Databases for Exercises
    3. C. Answers to Quizzes and Exercises
    4. D. CREATE TABLE Statements for Book Examples
    5. E. INSERT Statements for Data in Book Examples
    6. Glossary
    7. G. Bonus Exercises
  19. Index