SQL for Data Analysis

• Perform advanced statistical calculations using WINDOW function
• Use SQL queries and subqueries to prepare data for analysis
• Import and export data using a text file and psql
• Utilize special SQL clauses and functions to generate descriptive statistics
• Analyze special data types in SQL, including geospatial and time data
• Optimize queries to improve their performance to get results faster
• Debug queries that won’t run
• Use SQL to summarize and identify patterns in data

Understanding and finding patterns in data have become one of the most important ways of improving business decisions. If you are someone who knows the basics of SQL, but doesn’t know how to use SQL to create business insights from data, then this book is for you. This book covers everything you need to go from knowing basic SQL to start telling stories and identifying trends in data. You will be able to start exploring your data by identifying patterns and unlocking insights. You will also gain broad experience with different types of data in SQL, including time series, geospatial, and text data. Finally, you’ll learn to become productive with SQL through the use of profiling and automation to get insights faster. With all the new skills, you will able to look at data with the critical eye of an analytics professional. By the end of the book you will be you will be an expert thanks to your data and the magic of SQL.

• Explore various statistical techniques to analyze your data
• Integrate your SQL pipelines with other analytics technologies
• Perform advanced analytics, including geospatial and text analytics

Table of contents