Learn SQL in a Month of Lunches (MEAP v8)

This document was uploaded by one of our users. The uploader already confirmed that they had the permission to publish it. If you are author/publisher or own the copyright of this documents, please report to us by using this DMCA report form.

Simply click on the Download Book button.

Yes, Book downloads on Ebookily are 100% Free.

Sometimes the book is free on Amazon As well, so go ahead and hit "Search on Amazon"

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.

Author(s): Jeff Iannucci
Publisher: Manning Publications
Year: 2023

Language: English
Pages: 192

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