Lynda - Advanced SQL for Data Scientists

Size: 172 MB | Duration: 1h 24m | Video: AVC (.mp4) 1280x720 15&30fps | Audio: AAC 48KHz 2ch

Genre: eLearning | Level: Advanced | Language: English

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. You can also learn how to prepare data for use in analytics tools such as SAS, R, and Python. 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

* Best practices for preparing data for analytics tools