Description
Intermediate SQL for Data Scientists. This course teaches the essential skills for analyzing and extracting data from relational databases. As organizations increasingly move toward digital transformation and generate massive amounts of data, the need for professionals who can work with this data is greater than ever. Instructor Dan Sullivan explains common data science tasks such as searching, exploring, and extracting information. During this course, participants will learn the concepts and applications of aggregate functions, statistical functions, window operations, regular expressions, and subqueries. They will also learn how to work with semi-structured data such as JSON and execute more complex queries using JOIN operations. The course is seamlessly integrated with GitHub Codespaces, providing a ready-made cloud development environment and eliminating the need for on-premises setup and configuration. This environment allows learners to have hands-on, real-world experience from any device, at any time, and introduces them to tools they will encounter in professional work environments. To get started with this environment, a section on how to use GitHub Codespaces is included in the course.
What you will learn
- Advanced query writing principles:
- How to use aggregate functions to summarize data.
- Using statistical functions to analyze and draw conclusions from data.
- Perform window operations to perform calculations within a defined window of rows.
- Use Regular Expressions to search for and match complex patterns in text.
- Create and use subqueries for multi-step queries.
- Working with complex data and Joins:
- How to use the JSON data type, which is a semi-structured data type.
- Perform Join operations to combine data from multiple tables and enable more complex queries.
- Performing data science tasks with SQL:
- Learn how to search, explore, and extract data in relational databases.
- Explain how to perform common data science tasks using SQL capabilities.
- Development and practical training environment:
- Familiarity and work in the GitHub Codespaces environment, which allows for hands-on practice without the need for local settings.
This course is suitable for people who:
- Analysts looking to upgrade their SQL skills to manage and analyze increasing volumes of data.
- Data scientists who deal with SQL databases on a daily basis and need more advanced queries.
- Data professionals who want to enhance their abilities in data mining and exploration in relational databases.
- People who want to learn how to work with semi-structured data types like JSON in SQL.
- Those looking for hands-on experience using industry tools like GitHub Codespaces in a cloud environment.
Intermediate SQL for Data Scientists course details
- Publisher: LinkedIn
- Instructor: Dan Sullivan
- Education level: Intermediate
- Training duration: 3 hours and 50 minutes
Course headings
Course images
Sample course video
Installation Guide
After Extract, view with your favorite player.
Subtitles: English
Quality: 720p
Download link
Downloadly
Rapidgator link
File(s) password: www.downloadly.ir
File size
432 MB
