Skip to content Skip to sidebar Skip to footer

SQL For Data Analysts

SQL For Data Analysts

Published 11/2026
By Scott Simpson
MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + subtitle | Duration: 4h 32m | Size: 4.3 GB

SQL can do far more than just retrieve, filter, and aggregate data. Take your knowledge of SQL fundamentals to the next level by writing powerful queries that solve real-world data analysis problems!

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
hResearchers / 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.

ESKEUYRTGTDAYETGRGLEUYFTRFEGRS

you must be registered member to see linkes Register Now

Leave a comment