Untitled

Style:

• irreverent but factual and to the point
• assuming little about knowledge and understanding
• exercises to ensure ideas are established

Start in a different way Build on it's way up Build out a database Add data Start doing useful things with the data

Things to cover

• group by

  • having

• windows

  • Partition by

• correlated subqueries

• Introduction To The Journey

• How This Book Works | Meta

  • How this book is intended to work
  • Spiral of Depth

• What is SQL? | Meta

  • Purpose
  • Quick Example
  • It's always a list
  • Real Life Examples
  • By Comparison - Spreadsheets
  • What is a Server/Client
  • What we are using

• Creating Your Database | Meta

  • Creating Tables

• Modifying Your Data

  • ROUND (numeric)
  • LENGTH (text)
  • LEFT (text)

• Filtering Your Data

  • Where is it?
    • =
    • IN
    • BETWEEN
    • LIKE
    • Multiple Filters
      • AND
      • OR
      • XOR (<>)

• Data | Meta

  • Tables and Tables
  • Operations | Meta
    • Creating a table
    • Adding data
    • Querying data
  • Expressions
  • Different Kinds of Data | Meta
    • Numbers
    • Text
    • Relating Data - RDBMS
    • Dates | Meta
    • Numbers (Advanced) | Meta
      • Integers
    • Relationships | Meta
    • Text (Advanced) | Meta
    • The Truth | Meta

• Database Design

  • Normalization

• Getting a Deeper Understanding | Meta

  • Processing Order
  • CAP
  • Joining Data | Meta
    • Other kinds of JOINS
  • Linearization
  • No CAP
  • Order of Operation

• Getting Meta | Meta

  • Seeing your database

• Developing With SQL | Meta

  • Leaving the Book
  • Getting Data in and Out | Meta
    • CSVs
  • Using SQL in Code
  • Security | Meta
    • SQL Injection
    • Protecting Data
  • ORMs
  • Backups

• Glossary | Meta

  • table

• Appendix | Meta

• References | Meta

  • Resources

Examples

• Task Tracking
  • Can build out a list, then relationships to other people