SQL For Dummies:A Complete Guide with A 7-Day Crash Course for SQL Server and Database Fundamentals
Publisher: Micheal Brown
SQL is the workhorse programming language that forms the backbone of modern data management and interpretation.
If you know the basics of SQL, but don't know how to use it to gain business insights from data, this book is for you.
Any database management professional will tell you that despite trendy data management languages that come and go, SQL remains the most widely used and most reliable to date, with no signs of stopping. In this comprehensive guide, experienced mentor and SQL expert Walter Shields draws on his considerable knowledge to make the topic of relational database management accessible, easy to understand, and highly actionable.
SQL for Data Analytics covers everything you need progress from simply knowing basic SQL to telling stories and identifying trends in data. You'll be able to start exploring your data by identifying patterns and unlocking deeper insights. You'll also gain experience working with different types of data in SQL, including time-series, geospatial, and text data. Finally, you'll understand how to become productive with SQL with the help of profiling and automation to gain insights faster.
What you will learnUse SQL to summarize and identify patterns in dataApply special SQL clauses and functions to generate descriptive statisticsUse SQL queries and subqueries to prepare data for analysisPerform advanced statistical calculations using the window functionAnalyze special data types in SQL, including geospatial data and time dataImport and export data using a text file and PostgreSQLDebug queries that won't runOptimize queries to improve their performance for faster results
That's where SQL comes in.