Skip to content

SQL for Data Analysis

Course

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

06Days04Hrs31Min33Sec

  • Estimated time
    17 hours

  • Enroll by
    October 12, 2022

    Get access to classroom immediately on enrollment

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

What You Will Learn

  1. SQL for Data Analysis

    17 hours

    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.

    Prerequisite knowledge

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

            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 programs include:

            • 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

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

            • Workspaces

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

            • 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 offerings

            • Class content

              • Real-world projects
              • Project reviews
              • Project feedback from experienced reviewers
            • Student services

              • Technical mentor support
              • Student community

            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.

            • Personalized feedback
            • Unlimited submissions and feedback loops
            • Practical tips and industry best practices
            • Additional suggested resources to improve
            • 1,400+

              project reviewers

            • 2.7M

              projects reviewed

            • 88/100

              reviewer rating

            • 1.1 hours

              avg project review turnaround time

            Mentors available to answer your questions.

            • Support for all your technical questions
            • Questions answered quickly by our team of technical mentors
            • 1,400+

              technical mentors

            • 0.85 hours

              median response time

            Learn with the best.

            Learn with the best.

            • Josh Bernhard

              Data Scientist at Nerd Wallet

              Josh has been sharing his passion for data for nearly a decade at all levels of university, and as Lead Data Science Instructor at Galvanize. He's used data science for work ranging from cancer research to process automation.

            • Dana Sheahan

              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.

            • Mat Leonard

              Instructor

              Mat is a former physicist, research neuroscientist, and data scientist. He did his PhD and Postdoctoral Fellowship at the University of California, Berkeley.

            • Derek Steer

              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.

            • Sam Nelson

              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.

            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

            • Average Time

            • Benefits include

            Program Details

            • Do I need to apply? What are the admission criteria?
            • What are the prerequisites for enrollment?
            • How is this course structured?
            • How long is this course?
            • Can I switch my start date? Can I get a refund?
            • What software and versions will I need for this program?

            SQL for Data Analysis

            Enroll Now