Название: Learn SQL in a Month of Lunches (MEAP v5)
Автор: Jeff Iannucci
Издательство: Manning Publications
Год: 2023
Страниц: 117
Язык: английский
Формат: pdf (true)
Размер: 36.7 MB

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!

This book is designed for all SQL beginners, including those who are not necessarily software developers. It emphasizes practical ways to use SQL, rather than theoretical, helping you quickly assimilate the basics needed to begin implementing what you’ve learned. If you know how to use Windows or MacOS and have experience using spreadsheet applications, then you absolutely are ready to start learning how to use SQL to read and manipulate data, create database objects, and more.

Each chapter of this book is short enough to complete within an hour, whether that be during lunchtime or some other part of your day. Month of Lunches books are also designed to help you be immediately effective, so by the second chapter you will already have written your first SQL statement and examined its core components. Subsequent chapters will focus on teaching skills that you can apply to real-life scenarios and will include plenty of exercises to help you reinforce what you have learned.

For many organizations, data needs more than a place to be stored. It needs to be secure, able to grow, and searchable by a multitude of users and applications. To meet all these requirements, much of this prized data is contained in a certain type of database: a relational database. But this data in relational databases is only worth something if it can be used. So how can we read and change data in relational databases? Presumably, this is the reason you are reading this book, because the most popular answer is Structured Query Language, or as it is more commonly known, SQL.

Even though much of the data of our modern lives is stored in relational databases from different brands, such as Oracle, Microsoft, and IBM, nearly all of them have something in common: their data is primarily accessed and changed using SQL.

SQL is decidedly different from most programming languages. You can’t create a web application in SQL. You can’t create a mobile app in SQL. You can do one thing with SQL, and that is read and manipulate data in a relational database. That may seem like a limitation, and yet SQL is far and away the most popular language to work with relational databases. This means even if you were a software developer using C# or Java or some other language to build an application, you would still use SQL for the parts of your application that need to read or change data in a relational database.

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.