Udacity Accenture logo
Log InJoin for Free

SQL

Nanodegree Program

Learn SQL. Master SQL, the core language for data analysis and enable insight-driven decision-making and strategy for your business.

Learn SQL. Master SQL, the core language for data analysis and enable insight-driven decision-making and strategy for your business.

Beginner

2 months

Real-world Projects

Completion Certificate

Last Updated March 13, 2024

Skills you'll learn:
SQL subqueries • SQL joins • Mongodb • SQL CRUD commands
Prerequisites:
Basic SQL

Courses In This Program

Course 1 40 minutes

Welcome to the SQL Nanodegree Program

Welcome to the SQL Nanodegree program! Learn more about the pre-requisites, structure of the program, and getting started!

Lesson 1

SQL Nanodegree Program Introduction

Welcome to the SQL Nanodegree program! In this lesson, you will learn more about the structure of the program and meet your instructors.

Lesson 2

Getting Help

You are starting a challenging but rewarding journey! Take 5 minutes to read how to get help with projects and content.

Course 2 4 weeks

Introduction to SQL

SQL is one of the most versatile tools available for extracting insights from stored data. Learn how to execute core SQL commands to define, select, manipulate, control access, aggregate, and join data and data tables. Understand when and how to use subqueries, several window functions, and partitions to complete complex tasks. Clean data, optimize SQL queries and write select advanced JOINs to enhance analysis performance, explain which cases you would want to use particular SQL commands, and apply the results from queries to address business problems.

Lesson 1

Course Overview

Lesson 2

Basic SQL

In this section, you will gain knowledge about SQL basics for working with a single table. You will learn the key commands to filter a table in many different ways.

Lesson 3

SQL Joins

In this lesson, you will learn how to combine data from multiple tables together.

Lesson 4

SQL Aggregations

In this lesson, you will learn how to aggregate data using SQL functions

Lesson 5

SQL Subqueries & Temporary Tables

In this lesson, you will learn about subqueries, a fundamental advanced SQL topic. This lesson will walk you through the appropriate applications of subqueries, the different types of subqueries, and review subquery syntax and examples.

Lesson 6

SQL Data Cleaning

Cleaning data is an important part of the data analysis process. You will be learning how to perform data cleaning using SQL in this lesson.

Lesson 7

SQL Window Functions

Window functions allow users to compare one row to another without doing any joins using one of the most powerful concepts in SQL data analysis.

Lesson 8

SQL Advanced JOINS & Performance Tuning

Learn advanced joins and how to make queries that run quickly across giant datasets. Most of the examples in the lesson involve edge cases, some of which come up in interviews.

Lesson 9

Congratulations

Lesson 10 • Project

Deforestation Exploration

In this project, students will be putting their SQL skills to the test to help determine where to concentrate efforts to combat deforestation.

Course 3 4 weeks

Management of Relational and Non-relational Databases

Databases need to be structured properly to enable efficient and effective querying and analysis of data. Build normalized, consistent, and performant relational data models. Use SQL Database Definition Language (DDL) to create the data schemas designed in Postgres and apply SQL Database Manipulation Language (DML) to migrate data from a denormalized schema to a normalized one. Understand the tradeoffs between relational databases and their non-relational counterparts, and justify which one is best for different scenarios. With a radical shift of paradigms, learn about MongoDB and Redis to get an understanding of the differences in behaviors and requirements for non-relational databases.

Lesson 1

Intro to DBMS: Relational and Non-Relational Databases

Get introduced to database management systems, as well as learning the difference between relational and non-relational databases.

Lesson 2

Normalizing Data

Find out about the different forms of normalized data for optimizing database storage.

Lesson 3

Data Definition Language (DDL)

Learn about the data definition language, such as creating tables and different data types.

Lesson 4

Data Manipulation Language (DML)

Dive into the data manipulation language in order to alter existing tables and data.

Lesson 5

Consistency with Constraints

Find out how to keep consistency amongst your data by adding constraints.

Lesson 6

Performance with Indexes

Maximize your database performance by using indexes when and where appropriate.

Lesson 7

Intro to Non-Relational Databases

With your relational database skills in hand, you’re ready for a look into the other side of data, with non-relational databases.

Lesson 8 • Project

Udiddit, A Social News Aggregator

Investigate a poorly designed database for Udiddit, a social news aggregator. You’ll design a new, normalized and performant database and migrate over data from the previous database.

(Optional) Course 4 1 day

Career Services

The Careers team at Udacity is here to help you move forward in your career - whether it's finding a new job, exploring a new career path, or applying new skills to your current job.

Lesson 1 • Project

Take 30 Min to Improve your LinkedIn

Find your next job or connect with industry peers on LinkedIn. Ensure your profile attracts relevant leads that will grow your professional network.

Taught By The Best

Photo of Ziad Saab

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.

Photo of Derek Steer

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.

Photo of Malavica Sridhar

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.

Ratings & Reviews

Average Rating: 4.6 Stars

265 Reviews

Page 1 of 53

The Udacity Difference

Combine technology training for employees with industry experts, mentors, and projects, for critical thinking that pushes innovation. Our proven upskilling system goes after success—relentlessly.

Demonstrate proficiency with practical projects

Projects are based on real-world scenarios and challenges, allowing you to apply the skills you learn to practical situations, while giving you real hands-on experience.

  • Gain proven experience

  • Retain knowledge longer

  • Apply new skills immediately

Top-tier services to ensure learner success

Reviewers provide timely and constructive feedback on your project submissions, highlighting areas of improvement and offering practical tips to enhance your work.

  • Get help from subject matter experts

  • Learn industry best practices

  • Gain valuable insights and improve your skills

Unlock access to SQL and the rest of our best-in-class catalog

  • Unlimited access to our top-rated courses

  • Real-world projects

  • Personalized project reviews

  • Program certificates

  • Proven career outcomes

Full Catalog Access

One subscription opens up this course and our entire catalog of projects and skills.

Month-To-Month

4 Months

Average time to complete a Nanodegree program

*Discount applies to the first 4 months of membership, after which plans are converted to month-to-month.

Your subscription also includes:

Get Started Today

SQL

Month-To-Month


  • Unlimited access to our top-rated courses
  • Real-world projects
  • Personalized project reviews
  • Program certificates
  • Proven career outcomes

4 Months

Average time to complete a Nanodegree program

  • All the same great benefits in our month-to-month plan
  • Most cost-effective way to acquire a new set of skills
Discount applies to the first 4 months of membership, after which plans are converted to month-to-month.

Related Programs

Udacity Accenture logo
Company
  • Facebook
  • Twitter
  • LinkedIn
  • Instagram

© 2011-2024 Udacity, Inc. "Nanodegree" is a registered trademark of Udacity. © 2011-2024 Udacity, Inc.
We use cookies and other data collection technologies to provide the best experience for our customers.