UDACITY
UDACITY Logo

SQL for Data Analysis 

  • Offered byUDACITY

SQL for Data Analysis
 at 
UDACITY 
Overview

Upskilling is a better roadmap to success. Enroll in this course to learn critical principles of Data Science through real-life case studies & examples.

Duration

4 weeks

Total fee

Free

Mode of learning

Online

Schedule type

Self paced

Difficulty level

Beginner

Official Website

Explore Free Course External Link Icon

Credential

Certificate

SQL for Data Analysis
 at 
UDACITY 
Highlights

  • Earn a certificate upon completion
  • Learn from industry experts
Details Icon

SQL for Data Analysis
 at 
UDACITY 
Course details

Skills you will learn
Who should do this course?

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.

What are the course deliverables?
  • 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.
More about this course

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

Requirements for 12th gradeUp Arrow Icon
  • No specific cutoff mentioned
Conditional OfferUp Arrow Icon
  • Not mentioned

Other courses offered by UDACITY

– / –
– / –
– / –
– / –
– / –
– / –
69.7 K
Start Now
View Other 435 CoursesRight Arrow Icon

SQL for Data Analysis
 at 
UDACITY 
Students Ratings & Reviews

4/5
Verified Icon1 Rating
N
Norah Judith J R
SQL for Data Analysis
4
Learning Experience: SQL for data analysis issued by udacity was helpful in learning about windows function and advanced queries.It was explained in a way easy to be understood.Also all the topics from very basic was explained.
Faculty: The video lectures were good. They were quizzes in between each section and the solutions were provided in the next section with explanation.
Course Support: It was helpful topic for the domain i am trying to cahnge
Reviewed on 20 Jan 2023Read More
Thumbs Up IconThumbs Down Icon
View All 1 ReviewsRight Arrow Icon
qna

SQL for Data Analysis
 at 
UDACITY 

Student Forum

chatAnything you would want to ask experts?
Write here...