Lynda – Advanced SQL for Data Scientists

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

About WoW Team

I’m WoW Team , I love to share all the video tutorials. If you have a video tutorial, please send me, I’ll post on my website. Because knowledge is not limited to, irrespective of qualifications, people join hands to help me.