Lynda – Advanced SQL for Data Scientists
English | Size: 171.34 MB
Category: CBTs
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
DOWNLOAD:
http://nitroflare.com/view/1EE2F1EA314C7FD/Lynda_-_Advanced_SQL_for_Data_Scientists.rar
If any links die or problem unrar, send request to http://goo.gl/aUHSZc
Leave a Reply