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 October 30, 2023
Course 1 • 40 minutes
Welcome to the SQL Nanodegree program! Learn more about the pre-requisites, structure of the program, and getting started!
Course 2 • 4 weeks
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.
Course 3 • 4 weeks
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.
(Optional) Course 4 • 1 day
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.
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.
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.
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.
Average Rating: 4.6 Stars
(265 Reviews)
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
SQL
