Course

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
  • DAYS
  • HRS
  • MIN
  • SEC
  • Estimated Time
    20 hours

  • Enroll by
    September 22, 2021

    Get access to classroom immediately on enrollment

  • Prerequisites
    Data types
In collaboration with
  • Mode

What You Will Learn

Syllabus

Introduction to SQL

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.

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

Prerequisite Knowledge

Data types.

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

Icon - Dark upwards trend arrow
SQL skills are more in demand by employers than programming languages like Java, JavaScript, and Python!
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

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