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

✍ Scribed by Kimberley Fessel

• Publisher: O'Reilly Media, Inc.
• Year: 2024
• Tongue: English
• Leaves: 700
• Edition: 2
• Category: Library

✦ Synopsis

Do you have an abundance of data but don't know how to make sense of it? Do you want to gain useful insights from your data, but you're not sure where to begin? Mining data is a vital, well-paying skill, and SQL provides the most fundamental way to query and manage data. But learning SQL can be intimidating. This thoroughly revised book teaches you SQL fundamentals in a painless and enjoyable manner. With the Head First series' hands-on, conversational style, you'll quickly grasp SQL concepts, then move to intermediate topics, including stored procedures and cloud databases. You'll gain the knowledge, skills, and confidence necessary to get the most out of your data with SQL.

✦ Table of Contents

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