SQL for Data Analysis - Beginner

Engineering and Technology

Short Description

Learn to use Structured Query Language (SQL) to extract and analyze data stored in databases.

Long Description

In the course SQL for Data Analysis on Udacity, you will learn the basics of SQL, including how to write common commands such as SELECT, FROM, and WHERE, as well as how to use logical operators. You will also learn about SQL joins, including INNER JOINs and LEFT JOINs, to combine data from multiple tables. The course covers SQL aggregations, teaching you how to write common aggregations like COUNT, SUM, MIN, and MAX, as well as how to work with NULL values and use CASE and DATE functions. Additionally, you will learn about subqueries and temp tables, which allow you to run multiple queries together and access a table with more than one query. The course also covers SQL data cleaning techniques and introduces window functions, which can be used to tackle more complex analysis tasks.

Related Courses

SQL for Data Analysis - Beginner

by Udacity

Learn to use Structured Query Language (SQL) to extract and analyze data stored in databases.

SQL

by Udacity

Master SQL, the core language for big data analysis, to enable insight-driven decision-making and st...

SQL for Data Analysis - Intermediate

by Udacity

By the end of this course, you’ll be able to use SQL to query multiple tables, join data together fr...

Data Science Interview Prep

by Udacity

Prepare for data science interviews by practicing data analysis, machine learning, and data structur...

Data Analyst

by Udacity

Use Python, SQL, and statistics to uncover insights, communicate critical findings, and create data-...

Advanced Data Wrangling

by Udacity

Learn the most efficient methods for gathering raw “dirty” data and cleaning it up for analysis usin...

Introduction to SQL

by Udacity

Become an SQL power user with the ability complete complex tasks in SQL, including cleaning data and...

Data Architect

by Udacity

Learn how to plan, design and implement enterprise data infrastructure solutions and create the blue...

Programming for Data Science with Python

by Udacity

Learn the fundamental programming tools for data professionals: Python, SQL, terminal, and Git.

Programming for Data Science with R

by Udacity

Prepare for a data science career by learning the fundamental data programming tools: R, SQL, comman...

Course Details

Duration: 4 weeks
Difficulty: Beginner
Format: Short Course
Price: Free
Course Link

Udacity

Udacity is an online learning platform that offers a wide range of courses and programs in various fields such as technology, business, data science, and artificial intelligence. It was founded in 2012 by Sebastian Thrun, David Stavens, and Mike Sokolsky with the aim of providing accessible and affordable education to individuals worldwide. Udacity's courses are designed in collaboration with industry experts and leading companies, ensuring that the content is relevant and up-to-date. The platform offers both self-paced courses and guided programs, allowing learners to choose the learning style that suits them best. Udacity also provides career services and support, including resume reviews, interview preparation, and job placement assistance, to help learners transition into their desired careers.

Learn more