Do you feel overwhelmed by the amount of data that can be used for further analysis? This book, “Head First SQL, 2nd Edition,” comes in handy here. Data mining is an important skill, and SQL is the most commonly used language for querying and manipulating data. Comprehending SQL skills may appear difficult; nonetheless, this book makes it easy and entertaining. Like other books in the Head First series, it’s easy to read, has lots of hands-on activities and a conversational approach, and covers basic concepts of SQL to advanced topics such as stored procedures and cloud databases. At the end of the course, you can leverage your data with the help of SQL.
Unlike other books that put the reader to sleep with heaps of writing and information, this book employs a normative strategy that helps the reader get ahead with reading and recall what he/she learns. It is intended to complement your mind, and that is why the method of conveying SQL here is simplified and easily graspable.
Head First SQL, 2nd Edition Table of Contents:
- 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
Who is this course for?
- Data Analysts: People of great numbers interest or data science enthusiasts.
- Beginners in SQL: Beginners in the database field that require knowledge of SQL fundamentals at first.
- Intermediate SQL Users: Those who wish to enhance their knowledge in areas such as stored procedures and cloud bases.
Click on the links below to Download Head First SQL, 2nd Edition!
You are replying to :