Includes index

Before you begin -- Your first SQL query -- Querying data -- Sorting, skipping, and commenting data -- Filtering on specific values -- Filtering with multiple values, ranges, and exclusions -- Filtering with wildcards and null values -- Querying multiple tables -- Using different kinds of joins -- Combining queries with set operators -- Using subqueries and logical operators -- Grouping data -- Using variables -- Querying with functions -- Combining or calculating values with functions -- Inserting data -- Updating and deleting data -- Storing data in tables -- Creating constraints and indexes -- Reusing queries with views and stored procedures -- Making decisions in queries -- Using cursors -- Using someone else's script -- Never the end

"SQL, Structured Query Language, is the standard way to query, create, and manage relational databases like SQL Server, PostgreSQL, and Oracle. It's also a superpower for data analysts who need to go beyond spreadsheets and BI dashboarding tools. SQL is easy to read and understand, and with this book (and a little practice) you'll be pulling data, tweaking tables, and cranking out amazing reports and presentations in no time at all! Learn SQL in a Month of Lunches introduces SQL to data analysts and other aspiring data pros with no prior experience using relational databases. In it, you'll complete 24 short lessons, each of which teaches an essential SQL skill for retrieving, filtering, and analyzing data. You'll practice each new technique with a friendly hands-on lab designed to take about 15 minutes, as you learn to write queries that deliver the exact data you need. Along the way, you'll buld a valuable intuition for how databases operate in real business scenarios. What's inside: Get the data you need from any relational database ; Filter, sort, and group data ; Combine data from multiple tables ; Create, update, and delete data. For students, aspiring data analysts, software developers, and anyone else who wants to work with relational databases."--Back cover