SQL for Data Analysts By Scott Simpson

Overview
SQL is the language analysts use to talk to databases, and most enterprise data lives in relational databases like SQL Server. Knowing basic SQL gets you to the data. Knowing advanced SQL lets you do something meaningful with it before it ever leaves the database.
This course uses SQL Server and SSMS, both extremely common tools in the workplace, to move beyond simple retrieval and into valuable analysis. Analysts working with this skillset can rank and compare records, calculate running totals and moving averages, derive percentiles, identify gaps and patterns in sequential data, and build period-over-period comparisons, all directly in SQL, without exporting to a spreadsheet or statistical tool.
Skill Level
⚡ Intermediate
Learn How To
⚡ Build powerful queries to analyze data without relying on tools like Excel, Stata, or R
⚡ Describe common analytical patterns for working with real-world data
⚡ Calculate moving averages and perform group-level analysis
⚡ Identify gaps and natural groups in data
⚡ Measure and optimize query execution speed
Course Requirement
⚡ Learners should have an understanding of basic SQL.
Who Should Take This Course
⚡ Data Analysts
⚡ Business Analysts
⚡ Sales Managers
⚡ Researchers / Scientists
About Pearson Video Training
Pearson publishes expert-led video tutorials covering a wide selection of technology topics designed to teach you the skills you need to succeed. These professional and personal technology videos feature world-leading author instructors published by your trusted technology brands: Addison-Wesley, Cisco Press, Pearson IT Certification, Prentice Hall, Sams, and Que Topics include IT Certification, Network Security, Cisco Technology, Programming, Web Development, Mobile Development, and more. Learn more about Pearson Video training at

https://www.informit.com/video.

Video Lessons are available for download for offline viewing within the streaming format. Look for the green arrow in each lesson

Homepage

https://www.oreilly.com/videos/sql-for-data/9780136164555/

Rapidgator
SQL_for_Data_Analysts.html