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
  • Estimated time
    1 month

  • Enroll by
    June 14, 2023

    Get access to classroom immediately on enrollment

  • Skills acquired
    SQL JOINs, SQL Aggregations, SQL Queries
In collaboration with
  • Mode

What You Will Learn

  1. SQL for Data Analysis

    1 month

    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

    Familiarity with data types and data visualization.

    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.

            All Our Courses 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.

            • Real-time support

              On demand help. Receive instant help with your learning directly in the classroom. Stay on track and get unstuck.

            • 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

              • Student community
              • Real-time support

            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

            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

              • Learn

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

              • Average Time

                On average, successful students take 1 month to complete this program.

              • Benefits include

                • Real-world projects from industry experts
                • Real-time 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 1 month.

                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