Learn SQL in a Month of Lunches (MEAP v8)

Description

Use SQL to get the data you need in no time at all! Learn to read and write basic queries, troubleshoot common problems, and control your own business data in just 24 short lessons–no programming experience required! In Learn SQL in a Month of Lunches you’ll master useful SQL skills like Write your own SQL queries See only the data you need in large datasets Easily filter, sort, and cluster data Master basic data manipulation techniques Safely create, update, and delete data Structured Query Language (SQL) is the standard way to get specific datasets out of large relational databases. If you use Excel, Tableau, or PowerBI to crunch business data, you’ve probably seen a lot of SQL already. And guess what? It’s easy to master the most useful parts of SQL! In just a few quick lessons, you can learn to write your own queries, modify existing SQL statements, and add a new superpower to your bag of tricks. Learn SQL in a Month of Lunches introduces you to the most useful parts of SQL for business data analysis. This practical book gives you instantly-useful techniques starting from the first short chapter. 25-year SQL veteran Jeff Iannucci makes SQL a snap through hands-on lab exercises, relevant code examples, and easy-to-understand language. about the technology For decades, Structured Query Language has been the standard way to talk to relational databases. Unlike many programming languages, SQL is easy to read and understand once you get the hang of it. You don’t need to be a data scientist—or even a tech professional—to master the most powerful features. For business data analysts, learning SQL empowers you to create better reports, uncover market insights, and freely explore large databases on your own. about the book In Learn SQL in a Month of Lunches you’ll learn how to use SQL to retrieve, filter, and analyze your data—and more. 24 short, friendly lessons introduce you to SQL using examples and exercises built around the tasks you’ll do on the job. You’ll start writing real SQL queries immediately. And don’t worry if you’ve never tried to use a programming language before. SQL reads a lot like English! You’ll soon be up to speed with one of the most sought-after skills in today’s marketplace. about the reader For data analysts using tools like Excel, Tableau, and PowerBI and software developers new to SQL and databases. about the author Jeff Iannucci is a Senior Consultant with Straight Path Solutions. For over 20 years, he has worked extensively with SQL and relational databases to solve critical business needs in sectors such as health care, finance, retail sales, and government. He loves sharing his knowledge and enthusiasm for SQL as a blogger, speaker, and video course author. Copyright_2023_Manning_Publications welcome 1_Before_you_begin 2_Your_first_SQL_query 3_Querying_data 4_Sorting,_skipping,_and_commenting_data 5_Filtering_on_specific_values 6_Filtering_with_multiple_values,_ranges,_and_exclusions 7_Filtering_with_wildcards_and_null_values 8_Querying_multiple_tables 9_Using_different_kinds_of_joins 10_Combining_queries_with_set_operators 11_Using_subqueries_and_logical_operators 12_Aggregating_data