SQL for Data Analysis
-
COURSE DATES AND LOCATIONS
DATE
Duration
LOCATION
FEES
Book Now
-
INTRODUCTION
SQL for data analysis refers to the database querying language’s ability to interact with multiple databases at once, also its use of relational databases. SQL is one of the most used and flexible languages, as it combines a unique accessible learning curve with a complex depth that lets users create advanced tools and dashboards for data analytics.
During this course, you’ll learn to use (SQL) to extract and analyze data stored in databases. You’ll first learn to extract data, join tables together, and perform aggregations. Then you’ll learn to do more complex analysis and manipulations using subqueries, temp tables, and window functions. By the end of the course, you’ll be able to write efficient SQL queries to successfully handle a variety of data analysis tasks.
-
COURSE OBJECTIVES
- Become an expert in SQL
- Write complex SQL queries with ease
- Learn Advanced SQL rules
- Answer data questions using SQL and Data Analysis
- Apply Data Analytics to make data-informed decisions
- Replicate real-world situations and find actionable business insights
-
COURSE AUDIENCE
This course is made for :
- Data engineers
- Data science developers
- Advanced SQL developers
- Data analysis specialist
-
COURSE OUTLINE
Day One
Getting started with SQL
- What is SQL
- Retrieving data with SQL
- Creating tables
Day Two
Sorting data with SQL
- Basic of filtering with SQL
- Math operation
- Aggregate function
- Grouping data with SQL
Day Three
Subqueries in SQL
- Using subqueries
- Aliases and Self Joins
- Inner Joins
Day Four
Modifying data with SQL
- Working with Text Strings
- Working with Date and Time Strings
- Date and Time Strings Examples
Day Five
SQL data cleaning
- How to perform data cleaning with SQL
- Data Governance and Profiling
- Using SQL for Data Science
- Case Statement