SQL for Data Analysis
- Offered byUDACITY
SQL for Data Analysis at UDACITY Overview
Duration | 4 weeks |
Total fee | Free |
Mode of learning | Online |
Schedule type | Self paced |
Difficulty level | Beginner |
Official Website | Explore Free Course |
Credential | Certificate |
SQL for Data Analysis at UDACITY Highlights
- Earn a certificate upon completion
- Learn from industry experts
SQL for Data Analysis at UDACITY Course details
Professionals who work with large datasets and need to extract, transform, and analyze data using SQL.
Analysts who need to retrieve and analyze data from databases to support business decision-making.
Engineers and developers who work with databases and need to write SQL queries to interact with data.
- Understand the fundamental structure and syntax of SQL queries.
- Learn to write basic SQL queries to retrieve data from single and multiple tables.
- Gain proficiency in using SQL to retrieve specific data subsets using SELECT statements.
- Learn to apply filtering conditions (WHERE clause) to extract relevant data based on specified criteria.
- Master the use of aggregate functions (e.g., SUM, COUNT, AVG) to perform calculations on data sets.
- Understand how to use GROUP BY clause to group data and calculate summary statistics.
In this course, you'll learn to use Structured Query Language (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
SQL for Data Analysis at UDACITY Curriculum
SQL Basics
Learn to write common SQL commands including SELECT, FROM, and WHERE
Learn to use logical operators in SQL
SQL Joins
Learn to write INNER JOINs to combine data from multiple tables
Learn to write LEFT JOINs to combine data from multiple tables
SQL Aggregations
Learn to write common aggregations in SQL including COUNT, SUM, MIN, and MAX
Learn to write CASE and DATE functions, as well as work with NULL values
Subqueries and Temp Tables
Learn to write subqueries to run multiple queries together
Learn to use temp tables to access a table with more than one query
SQL Data Cleaning
Learn how to perform data cleaning using SQL
Window Functions
Learn to use window functions to tackle more analysis tasks
SQL for Data Analysis at UDACITY Entry Requirements
Other courses offered by UDACITY
SQL for Data Analysis at UDACITY Students Ratings & Reviews
- 3-41