Learn SQL in a Month of Lunches

by Jeff Iannucci

Programming

Book Details

Book Title

Learn SQL in a Month of Lunches

Author

Jeff Iannucci

Publisher

Manning

Publication Date

2025

ISBN

9781633438576

Number of Pages

306

Language

English

Format

PDF

File Size

3.23 MB

Subject

Databases

Table of Contents

  • Contents
  • Preface
  • Acknowledgments
  • About This Book
  • Who Should Read This Book
  • How This Book Is Organized: A Road Map
  • About the Code
  • liveBook Discussion Forum
  • About the Author
  • Chapter 1. Before You Begin
  • Why SQL Matters
  • Is This Book for You?
  • How to Use This Book
  • Setting Up Your Lab Environment
  • Online Resources
  • Being Immediately Effective with SQL
  • Chapter 2. Your First SQL Query
  • You Know Tables If You Already Know Spreadsheets
  • Learning SQL Is Like Taking an English Class
  • Writing Your First SQL Query
  • Key Terms and Keywords
  • Lab
  • Lab Answers
  • Chapter 3. Querying Data
  • Rules for the SELECT Statement
  • Retrieving Data from a Table
  • Lab
  • Lab Answers
  • Chapter 4. Sorting, Skipping, and Commenting Data
  • Sorting Data
  • Skipping Data
  • Commenting Data
  • Lab
  • Lab Answers
  • Chapter 5. Filtering on Specific Values
  • Filtering on a Single Condition
  • Filtering on Multiple Conditions
  • Lab
  • Lab Answers
  • Chapter 6. Filtering with Multiple Values, Ranges, and Exclusions
  • Filtering on Specific Values
  • Filtering on a Range of Values
  • Negating Filter Conditions
  • Combining Types of Filter Conditions
  • Reviewing Comparison Operators
  • Lab
  • Lab Answers
  • Chapter 7. Filtering with Wildcards and Null Values
  • Filtering with Wildcards
  • Filtering with Null Values
  • Lab
  • Lab Answers