دانلود کتاب SQL برای تحلیل داده‌ها

We’re giving you an exclusive preview of this book before it goes on sale. It can take many months to write a book, but our authors have cutting-edge information to share with you today. Early Access gives you an insight into the latest developments by making chapter drafts available. The chapters may be a little rough around the edges right now, but our authors will update them over time.You can dip in and out of this book or follow along from start to finish; Early Access is designed to be flexible. We hope you enjoy getting to know more about the process of writing a Packt book.
1. Chapter 1: Introduction to Data Management Systems
2. Chapter 2: Creating a Table with a Solid Structure
3. Chapter 3: Exchange Data Using COPY
4. Chapter 4: Manipulating Data with Python
5. Chapter 5: Presenting Data with SELECT
6. Chapter 6: Transforming and Updating Data
7. Chapter 7: Defining Datasets from Existing Datasets
8. Chapter 8: Aggregating Data with GROUP BY
9. Chapter 9: Inter-Row Operation with Window Functions
10. Chapter 10: Performant SQL
11. Chapter 11: Processing JSON and Arrays
12. Chapter 12: Advanced Data Types: Date, Text, and Geospatial
13. Chapter 13: Inferential Statistics Using SQL
14. Chapter 14: A Case Study for Analytics Using SQL