4.2 Read 6 reviews
Overview
Through this SQL for Data Analysis course from Udacity you'll 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.
What you will learn:
- 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.
- You will learn how to combine data from multiple tables together
- You will learn how to aggregate data using SQL functions like SUM, AVG, and COUNT. Additionally, CASE, HAVING, and DATE functions provide you an incredible problem solving toolkit.
- You will be learning to answer much more complex business questions using nested querying methods - also known as subqueries.
Programme Structure
Courses include:
- Basic SQL
- SQL Joins
- SQL Aggregations
- SQL Subqueries & Temporary Tables
- SQL Data Cleaning
- [Advanced] SQL Window Functions
Key information
Duration
- Part-time
- 1 days
Start dates & application deadlines
You can apply for and start this programme anytime.
Language
English
Delivered
Online
Campus Location
- Mountain View, United States
Disciplines
Data Analytics View 179 other Short Courses in Data Analytics in United StatesWhat students do after studying
Join for free or log in to access our complete career info list.
Academic requirements
We are not aware of any specific GRE, GMAT or GPA grading score requirements for this programme.
English requirements
We are not aware of any English requirements for this programme.
Other requirements
General requirements
- No prior technical experience required.
- You will need to be able to communicate fluently and professionally in written and spoken English.
Tuition Fees
Tuition fees are shown in and the most likely applicable fee is shown based on your nationality.
-
International Applies to you
Applies to youNon-residentsFree - Out-of-StateFree
-
Domestic
Applies to youIn-StateFree
Additional Details
- Free Course
Funding
Improve page content