Head First SQL: A Learner's Guide to Querying and Managing Data, 2nd Edition (Third Early Release)

Brief Table of Contents (Not Yet Final)
1. Databases and Tables: Organizing Your Information
	Defining your data
	Think about your data in categories
	Build a table of information
	What is SQL?
	The anatomy of a table
	A table of travel data
	BE the table
	BE the table Solution
	What’s a database?
	Databases contain related information
	Take command!
	Your first SQL commands
	Creating a SQL table
	Steps for creating a general SQL table
	Your table is ready
	A selection of common data types
		Data types for text
		Data types for numbers
		Data types for dates and times
		A data type for other things
	Who am I?
	Your table, DESCribed
	Changing table properties
	Code Magnets
	Code Magnets Solution
	Dropping and recreating tables
	Adding a new column
	Hitting your cruising altitude
	SQLcross
	Your SQL toolbox
	Who am I? Solution
	SQLcross Solution
2. Inserting Data: Adding Table Rows
	Setting up a database with tables
	Checking back in with Abby
	Inserting data into tables
	Creating your INSERT statement
	See your table with SELECT
	A new recommendation
	Records with missing values
	Revisiting your table
	Controlling NULLs...
	... and Setting DEFAULTs
	Variations on INSERT #1
	Variations on INSERT #2
	Variations on INSERT #3
	A punctuation problem
	Unmatched single quotes
	INSERT data with single quotes in it
	It’s only up from here!
	SQLcross
	Your SQL toolbox
	SQLcross Solution
3. The Select Statement: Finding Your Information
	Searching for a destination
	SELECT specific columns
	Specify columns... and their order
		SELECT specific columns for faster results
	An even better SELECT
	WHERE to next?
	WHERE filters out rows
	WHERE results
	Finding numeric values
	Expanding a numeric search
	Short travel times using less than
	Comparison Operators
	Finding numeric data with comparison operators
	Comparison operators for text
	Who am I?
	Who am I? Solution
	SQLcross
	Your SQL Toolbox
	SQLcross Solution
4. Better Where Clauses Filtering Rows
	Misplaced identification
	Multiple row requirements
	Combining your queries
	Use AND to satisfy two conditions
	To be OR not to be
	Code Magnets
	Code Magnets Solution
	Fireside Chats
	The difference between AND and OR
	BE the Conditional
	Be the Conditional Solution
	Use IS NULL to find NULLs
	IS NULL in your console
	Selecting ranges using AND and comparison operators
	Just BETWEEN us... there’s a better way
	Meanwhile, Abby dreams of sunshine...
	Save time with LIKE
	I’d LIKE to buy a wildcard, please
	You’re either IN...
	... or you are NOT IN
	And that’s NOT all
	WHERE for the win
	SQLcross
	Your SQL toolbox
	SQLcross Solution
About the Author