What's new

Welcome to Free download educational resource and Apps from TUTBB

Join us now to get access to all our features. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, and so, so much more. It's also quick and totally free, so what are you waiting for?

SQL for Data Analysts By Scott Simpson

TUTBB

Active member
Joined
Apr 9, 2022
Messages
196,424
Reaction score
20
Points
38

a277b7dfc1c60e67bacdf0aca875cc39.webp

SQL for Data Analysts
Published 11/2026
By Scott Simpson
MP4 | Video: h264, 1280x720 | 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
⚡ 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
Code:
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
Code:
https://www.oreilly.com/videos/sql-for-data/9780136164555/

 
Top Bottom