Nanodegree Program
Learn SQL
- DAYS
- HRS
- MIN
- SEC
NEW!
Estimated Time
2 months
At 10 hours / week
Enroll by
January 27, 2021
Get access to the classroom immediately on enrollment
Prerequisites
Basic understanding of data types
Learn SQL
SYLLABUS
Learn SQL
Prerequisite Knowledge
Basic understanding of data types (e.g., string, integer, etc.)
Introduction to SQL
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, as well as 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.
Management of Relational & 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.
Learn with the best
Malavica Sridhar
Product Manager at Waymo
Mal Sridhar is currently a Product Manager at Waymo. Prior to her current role, she was a Senior Product Manager at CircleUp. Mal started her career as a management consultant at McKinsey & Company and is passionate about leveraging data to transform industries.
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
Co-founder and CEO at Mode
Derek will introduce you to the SQL language and how to use SQL queries to analyze data in relational databases. Derek is the Co-Founder and CEO of Mode Analytics. He has worked as a data analyst in various companies, including Microsoft, Yammer, and Facebook.
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.
Career services
You’ll have access to resume support, Github portfolio review and LinkedIn profile optimization to help you advance your career and land a high-paying role.
Flexible learning program
Get a custom learning plan tailored to fit your busy life. Learn at your own pace and reach your personal goals on the schedule that works best for you.
Program OfferingsFull list of offerings included:
Enrollment includes:
Class Content
Real-world projects
Project reviews
Project feedback from experienced reviewers
Student Services
Technical mentor support
New
Student community
Improved
Career services
Resume support
Github review
Linkedin profile optimization
Succeed with Personalized Services
We provide services customized for your needs at every step of your learning journey to ensure your success!
Experienced Project Reviewers
Project Reviewers
Technical Mentor Support
Technical Mentor Support
Get timely feedback on your projects
Reviews By the numbers
2000+ project reviewers
1.8M projects reviewed
4.85/5 reviewer ratings
3 hour 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
Get started with
Learn SQL
Learn
Master SQL, the core language for Big Data analysis, and enable insight-driven decision-making and strategy for your business.
Average Time
On average, successful students take undefined months to complete this program.
Benefits include
- Real-world projects from industry experts
- Technical mentor support
- Career services
15% OFF
undefined months access
per month
Start learning today! Switch to the monthly price afterwards if more time is needed.
Pay as you go
per month
Start learning today! Get maximum flexibility to learn at your own pace.
Related Programs
PROGRAM OVERVIEW - WHY SHOULD I TAKE THIS PROGRAM?
Why should I enroll?
Employers are looking for professionals with SQL skills. Currently, SQL is the most in-demand skill, higher than even programming languages like Python, Java, and JavaScript. In fact, there are currently over 440,000 jobs that mention SQL on LinkedIn worldwide, which encompasses the broad range of roles that require knowledge of SQL, including titles like product analyst, data analyst, data scientist, business analyst, product manager, software engineer, and more!
With the SQL Nanodegree program, you will be equipped to know when to utilize SQL to provide data-backed insights into complex business strategies. With Udacity, you will get an in-depth instruction on how to leverage the power of SQL to pull insights from relational databases, and learn the situational differences of using relational databases versus non-relational databases like MongoDB and Redis. In this Nanodegree program, you won’t just learn how to use SQL, you will get hands-on experience with projects, including building a clone of the popular social news aggregation and discussion web site, Reddit!What jobs will this program prepare me for?
This program will help you apply your data analysis skills in roles such as Data Analyst, Product Analyst, Business Analyst, Product Manager, Data Modeler, Data Scientist, and more that necessitate knowledge of SQL.How do I know if this program is right for me?
If you are interested in a career in Data Science or simply want to hone your data analysis skills, then this program is right for you.
The SQL Nanodegree program teaches the basic data-working skills needed to find and use insights gleaned from large repositories of data that have outgrown their current abilities with spreadsheets. In addition, it teaches students how to harness the full power of relational databases, as well as be aware of other types of databases that exist, and know when to choose which type. The ideal student has aspirations to develop into a data professional, either in database management (IT) or in analytics (business).
ENROLLMENT AND ADMISSION
Do I need to apply? What are the admission criteria?
There is no application. This Nanodegree program accepts everyone, regardless of experience and specific background.What are the prerequisites for enrollment?
We strongly believe that anyone who has basic computer skills can understand and write SQL and NoSQL languages. Therefore, the prerequisites for this Nanodegree program are the following:
Basic computer skills- Familiarity with Operating systems (Windows and MacOS)
- Familiarity and comfort using word processing programs (Microsoft Word, Google Docs, PDF)
- Comfortable using presentation software (PowerPoint, Keynote, Google Slides)
- Comfortable using Spreadsheet programs (Microsoft Excel, Google Spreadsheets)
Basic understanding of data types (e.g., string, integer)- Comfortable identifying the type of data held in a data table.
I've graduated from the SQL Nanodegree program. Which program should I take next?
If you would like to pursue a career in Data Science, and are a beginner when it comes to programming, the Programming for Data Science with Python is a good fit. If you already have experience with programming with Python, you can try the Data Analyst or the Intro to Machine Learning with PyTorch Nanodegree programs.
If you would like to pursue a career in business, try one of the Business Analytics, Marketing Analytics, or Product Manager Nanodegree programs.
TUITION AND TERM OF PROGRAM
How is this Nanodegree program structured?
The SQL Nanodegree program is comprised of content and curriculum to support two projects. Once you subscribe to a Nanodegree program, you will have access to the content and services for the length of time specified by your subscription. We estimate that students can complete the program in two months, working 10 hours per week.
Each project will be reviewed by the Udacity reviewer network. 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 Nanodegree program?
You will have access to this Nanodegree program for as long as your subscription remains active. The estimated time to complete this program can be found on the webpage and in the syllabus, and is based on the average amount of time we project that it takes a student to complete the projects and coursework. See the Terms of Use and FAQs for other policies regarding the terms of access to our Nanodegree 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.
SOFTWARE AND HARDWARE - WHAT DO I NEED FOR THIS PROGRAM?
What software and versions will I need in this program?
For this Nanodegree program, 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 Nanodegree program.