Sams Teach Yourself SQL in 10 Minutes a Day, 5th Edition

Sams Teach Yourself SQL in 10 Minutes a Day, 5th Edition

by Ben Forta
Released January 2020
Publisher(s): Sams
ISBN: 9780135182925

Read it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Book description

Sams Teach Yourself SQL in 10 Minutes offers straightforward, practical answers when you need fast results.

By working through the book’s 22 lessons of 10 minutes or less, you’ll learn what you need to know to take advantage of the SQL language.

Lessons cover IBM DB2, Microsoft SQL Server and SQL Server Express, MariaDB, MySQL, Oracle and Oracle express, PostgreSQL, and SQLite.

Full-color code examples help you understand how SQL statements are structured
Tips point out shortcuts and solutions
Cautions help you avoid common pitfalls
Notes explain additional concepts, and provide additional information

10 minutes is all you need to learn how to…

  • Use the major SQL statements
  • Construct complex SQL statements using multiple clauses and
  • operators
  • Retrieve, sort, and format database contents
  • Pinpoint the data you need using a variety of filtering techniques
  • Use aggregate functions to summarize data
  • Join two or more related tables
  • Insert, update, and delete data
  • Create and alter database tables
  • Work with views, stored procedures, and more

Table of contents

  1. Cover Page
  2. About This eBook
  3. Title Page
  4. Copyright Page
  5. Contents at a Glance
  6. Table of Contents
  7. About the Author
  8. Acknowledgments
  9. We Want to Hear from You!
  10. Reader Services
  11. Introduction
    1. Who Is the Teach Yourself SQL Book For?
    2. DBMSs Covered in This Book
    3. Conventions Used in This Book
  12. Lesson 1. Understanding SQL
    1. Database Basics
    2. What Is SQL?
    3. Try It Yourself
    4. Summary
  13. Lesson 2. Retrieving Data
    1. The SELECT Statement
    2. Retrieving Individual Columns
    3. Retrieving Multiple Columns
    4. Retrieving All Columns
    5. Retrieving Distinct Rows
    6. Limiting Results
    7. Using Comments
    8. Summary
    9. Challenges
  14. Lesson 3. Sorting Retrieved Data
    1. Sorting Data
    2. Sorting by Multiple Columns
    3. Sorting by Column Position
    4. Specifying Sort Direction
    5. Summary
    6. Challenges
  15. Lesson 4. Filtering Data
    1. Using the WHERE Clause
    2. The WHERE Clause Operators
    3. Summary
    4. Challenges
  16. Lesson 5. Advanced Data Filtering
    1. Combining WHERE Clauses
    2. Using the IN Operator
    3. Using the NOT Operator
    4. Summary
    5. Challenges
  17. Lesson 6. Using Wildcard Filtering
    1. Using the LIKE Operator
    2. Tips for Using Wildcards
    3. Summary
    4. Challenges
  18. Lesson 7. Creating Calculated Fields
    1. Understanding Calculated Fields
    2. Concatenating Fields
    3. Performing Mathematical Calculations
    4. Summary
    5. Challenges
  19. Lesson 8. Using Data Manipulation Functions
    1. Understanding Functions
    2. Using Functions
    3. Summary
    4. Challenges
  20. Lesson 9. Summarizing Data
    1. Using Aggregate Functions
    2. Aggregates on Distinct Values
    3. Combining Aggregate Functions
    4. Summary
    5. Challenges
  21. Lesson 10. Grouping Data
    1. Understanding Data Grouping
    2. Creating Groups
    3. Filtering Groups
    4. Grouping and Sorting
    5. SELECT Clause Ordering
    6. Summary
    7. Challenges
  22. Lesson 11. Working with Subqueries
    1. Understanding Subqueries
    2. Filtering by Subquery
    3. Using Subqueries as Calculated Fields
    4. Summary
    5. Challenges
  23. Lesson 12. Joining Tables
    1. Understanding Joins
    2. Creating a Join
    3. Summary
    4. Challenges
  24. Lesson 13. Creating Advanced Joins
    1. Using Table Aliases
    2. Using Different Join Types
    3. Using Joins with Aggregate Functions
    4. Using Joins and Join Conditions
    5. Summary
    6. Challenges
  25. Lesson 14. Combining Queries
    1. Understanding Combined Queries
    2. Creating Combined Queries
    3. Summary
    4. Challenges
  26. Lesson 15. Inserting Data
    1. Understanding Data Insertion
    2. Copying from One Table to Another
    3. Summary
    4. Challenges
  27. Lesson 16. Updating and Deleting Data
    1. Updating Data
    2. Deleting Data
    3. Guidelines for Updating and Deleting Data
    4. Summary
    5. Challenges
  28. Lesson 17. Creating and Manipulating Tables
    1. Creating Tables
    2. Updating Tables
    3. Deleting Tables
    4. Renaming Tables
    5. Summary
    6. Challenges
  29. Lesson 18. Using Views
    1. Understanding Views
    2. Creating Views
    3. Summary
    4. Challenges
  30. Lesson 19. Working with Stored Procedures
    1. Understanding Stored Procedures
    2. Understanding Why to Use Stored Procedures
    3. Executing Stored Procedures
    4. Creating Stored Procedures
    5. Summary
  31. Lesson 20. Managing Transaction Processing
    1. Understanding Transaction Processing
    2. Controlling Transactions
    3. Summary
  32. Lesson 21. Using Cursors
    1. Understanding Cursors
    2. Working with Cursors
    3. Summary
  33. Lesson 22. Understanding Advanced SQL Features
    1. Understanding Constraints
    2. Understanding Indexes
    3. Understanding Triggers
    4. Database Security
    5. Summary
  34. Appendix A. Sample Table Scripts
    1. Understanding the Sample Tables
    2. Obtaining the Sample Tables
  35. Appendix B. SQL Statement Syntax
    1. ALTER TABLE
    2. COMMIT
    3. CREATE INDEX
    4. CREATE PROCEDURE
    5. CREATE TABLE
    6. CREATE VIEW
    7. DELETE
    8. DROP
    9. INSERT
    10. INSERT SELECT
    11. ROLLBACK
    12. SELECT
    13. UPDATE
  36. Appendix C. Using SQL Datatypes
    1. String Datatypes
    2. Numeric Datatypes
    3. Date and Time Datatypes
    4. Binary Datatypes
  37. Appendix D. SQL Reserved Words
  38. Index
  39. Code Snippets

Product information

  • Title: Sams Teach Yourself SQL in 10 Minutes a Day, 5th Edition
  • Author(s): Ben Forta
  • Release date: January 2020
  • Publisher(s): Sams
  • ISBN: 9780135182925