www.udacity.com Open in urlscan Pro
2606:4700::6812:5ed  Public Scan

Submitted URL: https://bit.ly/3Gt8E5c
Effective URL: https://www.udacity.com/course/sql-for-data-analysis--ud198?irclickid=0qzWhkVeRxyNRLjVfK03gVh3UkAQRmS1kS4y3Y0&irgwc=1&ut...
Submission: On April 16 via manual from BR — Scanned from DE

Form analysis 1 forms found in the DOM

<form>
  <div class="css-1hz0fw6">
    <div role="group" class="chakra-form-control css-1kxonj9"><label id="field-:r7:-label" for="field-:r7:" class="chakra-form__label css-1erp747">Type message</label><textarea aria-label="Ask your question..." id="field-:r7:"
        class="chakra-textarea css-u4v0e3"></textarea></div>
  </div>
  <div class="chakra-stack css-1vff7md"><button type="submit" class="chakra-button css-1k79sv9">Send</button><button type="button" class="chakra-button css-1vf0m6l">Clear</button></div>
</form>

Text Content

Skip to content

Welcome! Claim your personalized offer and start learning job-ready skills
today. Learn more.


Why Udacity?Student Success
Schools
 * Artificial Intelligence
 * Autonomous Systems
 * Business
 * Cloud Computing
 * Cybersecurity
 * Data Science
 * Product Management
 * Programming & Development
 * Full Program Catalog



POPULAR PROGRAMS

 1. Data Engineering with AWS
 2. C++
 3. Introduction to Programming
 4. Data Analyst
 5. Business Analytics

Sign InGet Started


SQL FOR DATA ANALYSIS


FREE COURSE

Databases, SQL, and more.

Start Free Course


RELATED NANODEGREE PROGRAM


PROGRAMMING FOR DATA SCIENCE WITH PYTHON

Earn a Nanodegree program certificate to accelerate your career.

Learn more

 * ESTIMATED TIME
   
   Approx. 4 Weeks

 * SKILL LEVEL
   
   Beginner

 * PREREQUISITES
   
   See prerequisites in detail

IN COLLABORATION WITH

 * 


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.

Highly-curated content

Taught by industry experts

Self-paced progress


YOUR PATH TO CAREER SUCCESS STARTS HERE.


SQL FOR DATA ANALYSIS

FREE COURSE

Enhance your skill set and boost your hirability through innovative, independent
learning.


PROGRAMMING FOR DATA SCIENCE WITH PYTHON

NANODEGREE

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

Learn more


WHAT YOU WILL LEARN

 1. SQL BASICS
    
    * Learn to write common SQL commands including SELECT, FROM, and WHERE
    * Learn to use logical operators in SQL

 2. SQL JOINS
    
    * Learn to write INNER JOINs to combine data from multiple tables
    * Learn to write LEFT JOINs to combine data from multiple tables

 3. 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

 4. 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

 5. SQL DATA CLEANING
    
    * Learn how to perform data cleaning using SQL

 6. WINDOW FUNCTIONS
    
    * Learn to use window functions to tackle more analysis tasks


PREREQUISITES AND REQUIREMENTS

Learners should have general familiarity working with data in spreadsheets.

See the Technology Requirements for using Udacity.


WHY TAKE THIS COURSE?

SQL is the most commonly used data analysis tool for data analysts and data
scientists. The majority of the world’s data is stored in databases, and
learning SQL will enable you to access and analyze this data with ease. SQL is a
valuable tool for a wide array of roles across diverse industries—digital
marketers, engineers, product managers, etc. use SQL every day. The ability to
do important data work yourself with SQL enhances the value you'll bring to any
organization.


WHAT DO I GET?

Instructor videos

Experiential activities

Interactive quizzes


LEARN WITH THE BEST.

 * DEREK STEER
   
   Instructor




POPULAR FREE COURSES

 * Intro to TensorFlow for Deep Learning
 * Introduction to Python Programming
 * Advanced Android with Kotlin
 * Introduction to TensorFlow Lite
 * Intro to HTML and CSS
 * Intro to JavaScript


HAVE A QUESTION?

Ask our AI chatbot. It's in beta but ready to help!

Start Chatting




 * FEATURED PROGRAMS
   
    * Business Analytics
    * SQL
    * Data Engineering with AWS
    * Data Analyst
    * Intro to Programming
    * Digital Marketing
    * Self Driving Car Engineer


 * ONLY AT UDACITY
   
    * Artificial Intelligence
    * Deep Learning
    * Digital Marketing
    * Flying Car and Autonomous Flight Engineer
    * Intro to Self-Driving Cars
    * Machine Learning Engineer
    * Robotics Software Engineer
    *  
   
   
   UDACITY SCHOOLS
   
    * School of Artificial Intelligence
    * School of Autonomous Systems
    * School of Business
    * School of Cloud Computing
    * School of Cybersecurity
    * School of Data Science
    * School of Programming
    * School of Product Management


 * ENTERPRISE
   
    * Udacity for Enterprise
    * Digital Transformation with Udacity
    * Artificial Intelligence for Enterprise
    * Cybersecurity for Enterprise
    * Data Science for Enterprise
    * Udacity for Financial Services
    * Corporate Social Responsibility
    * Train-to-Hire
    * Enterprise Resource Center
   
   
   GOVERNMENT
   
    * Udacity for Government
   
   
   INDIVIDUALS
   
    * Udacity for Individuals


 * RESOURCES
   
    * Catalog
    * Career Services
    * Student Success
    * Udacity Talks
    * Scholarships
    * What is AI?
    *  
   
   
   COMPANY
   
    * About
    * Blog
    * In the News
    * Jobs at Udacity
    * Partners
    * Affiliates
    * Become an Instructor


 * SUPPORT
   
    * Contact Us
    * Help and FAQ
    * Service Status
    * Tech Requirements
    * * 
      * 
      * 
      * 

Udacity is the trusted market leader in talent transformation. We change lives,
businesses, and nations through digital upskilling, developing the edge you need
to conquer what’s next.

Udacity* Nanodegree programs represent collaborations with our industry partners
who help us develop our content and who hire many of our program graduates.

"Nanodegree" is a registered trademark of Udacity. © 2011–2023 Udacity, Inc.

*not an accredited university and doesn’t confer traditional degrees

 * © 2011–2023 Udacity, Inc.

 * Legal & Privacy
 * Site Map

Related Information
 * Intro to Relational Databases
 * Learn SQL, Excel and Tableau
 * Learn SQL








UDACITY GPT

Powered by OpenAI

How can I help?


Type message
SendClear