Lesson 1
Intro to Using SQL for Data Analysis
This is a quick summary of what is covered in this course.
Course
SQL is one of the most versatile tools available when it comes to extracting insights from stored data. Learn how to execute core SQL commands to define, select, manipulate, control access, aggregate, and join data and data tables. Understand when and how to use subqueries, several window functions, and partitions to complete complex tasks. Clean data, optimize SQL queries and write select advanced JOINs to enhance analysis performance. Explain which cases you would want to use particular SQL commands and apply the results from queries to address business problems.
SQL is one of the most versatile tools available when it comes to extracting insights from stored data. Learn how to execute core SQL commands to define, select, manipulate, control access, aggregate, and join data and data tables. Understand when and how to use subqueries, several window functions, and partitions to complete complex tasks. Clean data, optimize SQL queries and write select advanced JOINs to enhance analysis performance. Explain which cases you would want to use particular SQL commands and apply the results from queries to address business problems.
Beginner
3 weeks
Real-world Projects
Completion Certificate
Last Updated October 27, 2023
No experience required
Lesson 1
This is a quick summary of what is covered in this course.
Lesson 2
In this section, you will gain knowledge about SQL basics for working with a single table. You will learn the key commands to filter a table in many different ways.
Lesson 3
In this lesson, you will learn how to combine data from multiple tables together.
Lesson 4
In this lesson, you will learn how to aggregate data using SQL functions
Lesson 5
In this lesson, you will learn about subqueries, a fundamental advanced SQL topic. This lesson will walk you through the appropriate applications of subqueries, the different types of subqueries, and review subquery syntax and examples.
Lesson 6
Window functions allow users to compare one row to another without doing any joins using one of the most powerful concepts in SQL data analysis.
Lesson 7
Cleaning data is an important part of the data analysis process. You will be learning how to perform data cleaning using SQL in this lesson.
Lesson 8 • Project
In this project, you will use a digital music store database to help the company see how they might optimize their business practices.
Staff Data Scientist
Josh has been sharing his passion for data for over a decade. He's used data science for work ranging from cancer research to process automation. He recently has found a passion for solving data science problems within marketplace companies.
CEO at Mode
Derek is the CEO of Mode Analytics. He developed an analytical foundation at Facebook and Yammer and is passionate about sharing it with future analysts. He authored SQL School and is a mentor at Insight Data Science.
Content Developer
Mat is a former physicist, research neuroscientist, and data scientist. He did his PhD and Postdoctoral Fellowship at the University of California, Berkeley.
Content Developer
Dana is an electrical engineer with a Masters in Computer Science from Georgia Tech. Her work experience includes software development for embedded systems in the Automotive Group at Motorola, where she was awarded a patent for an onboard operating system.
Product Lead
Sam is the Product Lead for Udacity's Data Analyst, Business Analyst, and Data Foundations programs. He's worked as an analytics consultant on projects in several industries, and is passionate about helping others improve their data skills.
Combine technology training for employees with industry experts, mentors, and projects, for critical thinking that pushes innovation. Our proven upskilling system goes after success—relentlessly.
Demonstrate proficiency with practical projects
Projects are based on real-world scenarios and challenges, allowing you to apply the skills you learn to practical situations, while giving you real hands-on experience.
Gain proven experience
Retain knowledge longer
Apply new skills immediately
Top-tier services to ensure learner success
Reviewers provide timely and constructive feedback on your project submissions, highlighting areas of improvement and offering practical tips to enhance your work.
Get help from subject matter experts
Learn industry best practices
Gain valuable insights and improve your skills
Using SQL for Data Analysis