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
Video Lessons are available for download for offline viewing within the streaming format. Look for the green arrow in each lesson
Homepage

---