The Data Analysis with SQL and Python training course is designed to demonstrate a deep exploration into how to use SQL for data analysis and its usefulness within the Python development environment.
The course begins with a foundation of regular expressions, volatile tables, and cross joins which make SQL a powerful platform for data analytics. Next, it describes CTEs and subqueries as well as windowing functions. Lastly, the course utilizes the common limitations of SQL and when they may need to use a more powerful language like Python for certain problems.
Purpose
|
Provide students with the advanced SQL skills needed for effective data analysis. |
Audience
|
Data Analysts, Data Engineers and Data Scientists with at least some exposure to basic SQL queries and use of databases |
Role
| Data Engineer - Data Scientist |
Skill Level
| Intermediate |
Style
| Workshops |
Duration
| 3 Days |
Related Technologies
| SQL | Python |
Productivity Objectives
- Write window functions, cross joins and regular expressions in SQL
- Build complex queries that are more readable with CTE's and subqueries
- Understand when to use Python over SQL for certain problems