Learn SQL in a Month of Lunches
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
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