Skip to content

Introduction to SQL

Course

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

04Days06Hrs56Min26Sec

  • Estimated time
    20 hours

  • Enroll by
    September 28, 2022

    Get access to classroom immediately on enrollment

  • Prerequisites
    Data types
In collaboration with
  • Mode

What You Will Learn

  1. Introduction to SQL

    20 hours 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

    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.

                  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.

                  • 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

                  • Monthly access

                    Pay as you go


                    per

                    /

                    /

                    Enroll now
                    • Maximum flexibility to learn at your own pace.
                    • Cancel anytime.
                  • 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 20 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?
                  • 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 in this course?

                  Introduction to SQL

                  Enroll Now