دانلود فیلم آموزش SQL پیشرفته برای علم اطلاعات

There is an increasing need for data scientists and analysts to understand relational data stores. Organizations have long used SQL databases to store transactional data as well as business intelligence related data. If you need to work with SQL databases, this course is designed to help you learn how to perform common data science tasks, including finding, exploration, and extraction within relational databases.

The course begins with a brief overview of SQL. Then the five major topics a data scientist should understand when working with relational databases: basic statistics in SQL, data preparation in SQL, advanced filtering and data aggregation, window functions, and preparing data for use with analytics tools.
Topics include:
Data manipulation
ANSI standards
SQL and variations
Statistical functions in SQL
String, numeric, and regular expression functions in SQL
Advanced filtering techniques
Advanced aggregation techniques
Windowing functions for working with ordered data sets
Courses :
Introduction
SQL as a Tool for Data Science
Basic Statistics With SQL
Data Munging With SQL
Filtering, Joins, and Aggregation
Window Functions and Ordered Data
Preparing Data for Analytics Tools