Course

SQL for Data Analysis

Graduate from spreadsheets to databases with this special course on SQL for business! By the end of this course, you’ll be able to use SQL to query multiple tables, join data together from multiple sources, and even extract key business insights from retail databases.
Enroll Now
  • DAYS
  • HRS
  • MIN
  • SEC
  • Estimated Time
    17 hours

  • Enroll by
    September 22, 2021

    Get access to classroom immediately on enrollment

  • Prerequisites
    Familiarity with data types and data visualization
In collaboration with
  • Mode

What You Will Learn

Syllabus

SQL for Data Analysis

When it comes to data analysis, Excel will only take you so far. To analyze larger sources of table-based data, you need the power & speed of SQL in your arsenal. In this course, you’ll learn how to manipulate and analyze multiple tables to answer complex business questions, as well as have the option to learn advanced SQL skills like writing subqueries and advanced joins. This course also includes a hands-on project where you’ll analyze a music store database and find ways for the store to optimize their operations.

In this course, you’ll learn how to manipulate and analyze multiple tables to answer complex business questions, as well as have the option to learn advanced SQL skills like writing subqueries and advanced joins. This course also includes a hands-on project where you’ll analyze a music store database and find ways for the store to optimize their operations.

Prerequisite Knowledge

Familiarity with data types and data visualization.

  • Basic SQL

    Become fluent in basic SQL commands including SELECT, FROM, WHERE and corresponding logical operators.

  • SQL Joins

    Combine data tables using SQL joins to to answer more complex business questions.

  • SQL Aggregations

    Aggregate data in SQL including COUNT, SUM, MIN and MAX, and write CASE and DATE functions, as well as work with NULL values.

  • Advanced SQL Lessons [Optional]

    Use subqueries, also called CTEs, in a number of different situations, use window functions including RANK, NTILE, LAG, LEAD new functions along with partitions to complete complex tasks, and clean data, optimize queries and write advanced JOINs.

  • Course Project: Query a Digital Music Store Database

    In this project, you will be provided a dataset reflecting data collected from an experiment. You’ll use statistical techniques to answer questions about the data and report your conclusions and recommendations in a report.

Icon - Dark upwards trend arrow

$85–$92k
The range of salaries for employees with data skills such as Excel, SQL, and Tableau.

woman-leading-group-meeting

Introducing new Udacity Single Courses

Our students asked and we listened. You can now get the in-demand tech skills you need faster and for less money by enrolling in one of our new, one-month Single Courses. You’ll get the specific job-ready skills you need in as little as four weeks and for a fraction of the cost.

Of course if you are looking for a more robust, in-depth education, you can still enroll in one of our 3-6 month Nanodegree programs.

Both programs are part-time and online, and they both offer 24/7 support, quality Udacity-produced content, courses created with the help of top tech companies, and more. You can always start with a Single Course and upgrade to a full Nanodegree program if you like.

All Our Courses Include

Real-world projects from industry experts

Real-world projects from industry experts

With real world projects and immersive content built in partnership with top tier companies, you’ll master the tech skills companies want.
Technical mentor support

Technical mentor support

Our knowledgeable mentors guide your learning and are focused on answering your questions, motivating you and keeping you on track.
Workspaces

Workspaces to see your code in action

Validate your understanding of concepts learned by checking the output and quality of your code in real-time.
Flexible learning program

Flexible learning program

Tailor a learning plan that fits your busy life. Learn at your own pace and reach your personal goals on the schedule that works best for you.
Course OfferingsFull list of offerings included:
Enrollment Includes:
Class Content
Real-world projects
icon-checkmarkCheckmark
Project reviews
icon-checkmarkCheckmark
Project feedback from experienced reviewers
icon-checkmarkCheckmark
Student Services
Technical mentor support
New
icon-checkmarkCheckmark
Student community
Improved
icon-checkmarkCheckmark
Succeed with Personalized Services
We provide services customized for your needs at every step of your learning journey to ensure your success!
Get timely feedback on your projects
Reviews By the numbers
1,400+ project reviewers
2.7M projects reviewed
88/100 reviewer rating
1.1 hours avg project review turnaround time
Reviewer Services
  • Personalized feedback
  • Unlimited submissions and feedback loops
  • Practical tips and industry best practices
  • Additional suggested resources to improve
Mentors available to answer your questions
Mentors by the numbers
1,400+ technical mentors
0.85 hours median response time
Mentorship Services
  • Support for all your technical questions
  • Questions answered quickly by our team of technical mentors

SQL for Data Analysis

Get Started Today

  • Monthly Access

    Pay as you go


    per

    /

    /

    Enroll Now
    • Maximum flexibility to learn at your own pace.
    • Cancel anytime.
  • Learn

    How to analyze relational databases and answer key business questions with SQL.
  • Average Time

    On average, successful students take 17 hours to complete this program.
  • Benefits include

    • Real-world projects from industry experts
    • Technical mentor support

Program Details

  • Do I need to apply? What are the admission criteria?
    No. This Course accepts all applicants regardless of experience and specific background.
  • What are the prerequisites for enrollment?
    Students should have a basic understanding of data types and the ability to create basic visuals from data in a spreadsheet.
  • How is this course structured?
    The SQL for Data Analysis course is comprised of content and curriculum to support one project. We estimate that students can complete the program in 17 hours.

    The project will be reviewed by the Udacity reviewer network and platform. Feedback will be provided and if you do not pass the project, you will be asked to resubmit the project until it passes.
  • How long is this course?
    Access to this course runs for the length of time specified in the payment card above. If you do not graduate within that time period, you will continue learning with month to month payments. See the Terms of Use and FAQs for other policies regarding the terms of access to our programs.
  • Can I switch my start date? Can I get a refund?
    Please see the Udacity Program Terms of Use and FAQs for policies on enrollment in our programs.
  • What software and versions will I need for this program?
    For this program, you will need a desktop or laptop computer running recent versions of Windows, Mac OS X, or Linux, and an unmetered broadband Internet connection. There are no additional hardware or software requirements for this program, other than those outlined on Udacity's general Technology Requirements page.

SQL for Data Analysis

Enroll Now