Skip to content

Introduction to SQL


Become an SQL power user! By the end of this hands-on course, you’ll be able to complete complex tasks in SQL, including cleaning data and tuning the performance of your queries so they run quickly, even over giant data sets.

Enroll Now
  • Estimated time
    1 month

  • Enroll by
    June 14, 2023

    Get access to classroom immediately on enrollment

  • Skills acquired
    SQL Subqueries, SQL JOINs, Data Cleaning
In collaboration with
  • Mode

What You Will Learn

  1. Introduction to SQL

    1 month to complete

    In the ever-growing fields of data science & software engineering, knowledge of SQL has become an absolute must. (In fact, these days many hiring interviews for data-scientist positions start with SQL questions!) This zero-fluff course will fast-track your proficiency in SQL, getting you started with basic queries and quickly incorporating advanced elements like subqueries, window functions, and advanced joins.

    Prerequisite knowledge

    Data types.

    1. Basic SQL

      Write common SQL commands including SELECT, FROM and WHERE and use logical operators such as LIKE, AND and OR.

      • SQL JOINs

        Write JOINs in SQL to combine data from multiple sources to answer more complex business questions, and understand different types of JOINs and when to use each type.

        • SQL Aggregations

          Write common aggregations in SQL including COUNT, SUM, MIN and MAX, and write CASE and DATE functions, as well as work with NULLs.

          • SQL Subqueries & Temporary Tables

            Write subqueries to run multiple queries together, learn the types of subquery placement and formatting, and use temp tables to access a table with more than one query.

            • SQL Data Cleaning

              Learn and apply the basics of data cleaning strategies in SQL to normalize or create a column from existing data, and perform the appropriate data cleaning methodology based on goals for further analysis.

              • SQL Window Functions

                Apply core window functions to tackle analysis tasks that require further targeting or segmentation, and use other window functions including RANK, NTILE, LAG, LEAD new functions along with partitions to complete complex tasks.

                • SQL Advanced JOINs AND Performance Tuning

                  Learn how and when to use advanced joins (e.g., self joins) to write queries that run quickly across giant datasets, and learn the high-level tradeoffs with queries, including performance and what you can do to optimize them.

                  • Course Project: Deforestation Exploration

                    SQL is most commonly used to manipulate and analyze data to inform decision making. In this project, you will act as a data analyst for an organization on a mission to reduce deforestation around the world and to raise awareness about this important environmental topic. First, you’ll clean any erroneous values in a table, join that table to another lookup table to bring in a new categorical and quantitative variable and return a new view of all categories greater than a reference value. Then, you will create and execute SQL queries to perform calculations using variables from those disparate data sets to answer questions for stakeholders. Your analysis will help you better understand which countries and regions around the world seem to have forests that have been shrinking in size, and also which countries and regions have the most significant forest area. Lastly, you will compile your answers and summarize your analysis into a report that can be shared to a leadership team.

                  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.

                  • Malavica Sridhar

                    Senior Product Manager at CircleUp

                    Malavica is a Senior Product Manager with over five years of experience. Her work includes building Helio, an ML platform used to identify breakout brands in early-stage consumer packaged goods companies.

                  • Ziad Saab

                    Software Developer and Co-Founder DecodeMTL

                    Ziad is a seasoned software developer who loves mentoring and teaching. Currently working as an independent contractor, he previously co-founded and taught full-stack web development at DecodeMTL, Montreal's first web development bootcamp.

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

                  Introduction to SQL

                  Get started today

                    • Learn

                      How to manipulate and analyze relational data efficiently with one of the most commonly required languages in data science: SQL.

                    • Average Time

                      On average, successful students take one 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?

                      In order to succeed in this program, we recommend that students have experience with data types.

                    • How is this course structured?

                      The Introduction to SQL 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 in this course?

                      You will need a desktop or laptop computer running recent versions of Windows, Mac OS X, or Linux and an unmetered broadband Internet connection. For an ideal learning experience, a computer with Mac or Linux OS is recommended. You will use SQL, NoSQL, Postgres, SQL DDL, and SQL DML in this Course.

                    Introduction to SQL

                    Enroll Now