کتاب "یادگیری SQL در یک ماه" یک راهنمای ساده و کاربردی برای یادگیری SQL در ۲۴ درس کوتاه و عملی است. این کتاب بدون نیاز به تجربه برنامه‌نویسی، شما را با پرس‌وجو (Query)، فیلتر کردن و مدیریت داده‌ها آشنا می‌کند.

نکات کلیدی:

✔ نوشتن پرس‌وجوهای SQL برای استخراج و تحلیل داده‌ها

✔ فیلتر، مرتب‌سازی و گروه‌بندی مجموعه‌های داده بزرگ

✔ اتصال چندین جدول و انجام عملیات تجمعی (Aggregation)

✔ ایجاد و ویرایش جداول برای ذخیره‌سازی بهینه داده‌ها

✔ بهینه‌سازی پرس‌وجوها و استفاده مجدد از آن‌ها در Viewها و Stored Procedureها

این کتاب برای تحلیل‌گران داده، توسعه‌دهندگان و کاربران تجاری طراحی شده و بر کاربردهای واقعی SQL تمرکز دارد. اگر از Excel، Power BI یا Tableau استفاده می‌کنید، یادگیری SQL مهارت شما را در کار با داده‌های ساختاریافته چندین برابر خواهد کرد.

با تمرین‌های عملی، در کمتر از یک ماه SQL را مانند یک حرفه‌ای بیاموزید!

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!

SQL has been designed to be as close to English as possible—anyone can learn it! Learn SQL in a Month of Lunches helps you add this lucrative and highly sought-after skill to your resume in just 24 fun and friendly lessons. The book emphasizes practical uses for the language in the real-world, so you’ll just learn the most useful skills for business data analysis.

Inside Learn SQL in a Month of Lunches you’ll discover how to:

• Set up your first database with MySQL

• Write your own SQL queries

• See only the data you need from large datasets

• Connect different sets of data

• Analyze data with functions and aggregations

• Master basic data manipulation techniques

• Save queries in stored procedures and views

• Create tables to store data efficiently

• Read and improve SQL written by others

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, Learn SQL in a Month of Lunches will get you writing your own queries, modifying existing SQL statements, and working with data like a pro. 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

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!

About the book

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 build 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

About the reader

For students, aspiring data analysts, software developers, and anyone else who wants to work with relational databases.

About the author

Jeff Iannucci is a Senior Consultant with Straight Path Solutions. For over 20 years, he has worked extensively with SQL in sectors such as healthcare, finance, retail sales, and government.

Table of Contents

1. Before You Begin

2. Your First SQL Query

3. Querying Data

4. Sorting Skipping Commenting Data

5. Filtering Specific Values

6. Filtering Multiple Values Ranges Exclusions

7. Filtering Wildcards Null Values

8. Querying Multiple Tables

9. Using Different Kinds Joins

10. Combining Queries Set Operators

11. Using Subqueries Logical Operators

12. Grouping Data

13. Using Variables

14. Querying Functions

15. Combining Calculating Values Functions

16. Inserting Data

17. Updating Deleting Data

18. Storing Data Tables

19. Creating Constraints Indexes

20. Reusing Queries Views Stored Procedures

21. Making Decisions Queries

22. Using Cursors

23. Using Someone Else’s Script

24. Never the End

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.