NEW!
Nanodegree Program

Learn SQL

Master SQL, the core language for Big Data analysis, and enable insight-driven decision-making and strategy for your business.
Enroll Now
  • Estimated Time
    2 months

    At 10 hours / week

  • Enroll by
     

    Get access to the classroom immediately on enrollment

  • Prerequisites
    Basic understanding of data types

    See prerequisites in detail

Learn SQL

SYLLABUS

Learn SQL

Perform analysis on data stored in relational and non-relational database systems to power strategic decision-making. Learn to determine, create, and execute SQL and NoSQL queries that manipulate and dissect large scale datasets. Begin by leveraging the power of SQL commands, functions, and data cleaning methodologies to join, aggregate, and clean tables, as well as complete performance tune analysis to provide strategic business recommendations. Finally, apply relational database management techniques to normalize data schemas in order to build the supporting data structures for a social news aggregator.

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

Hide details

2 months to complete

Prerequisite Knowledge

Basic understanding of data types (e.g., string, integer, etc.) See detailed requirements.

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

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

    Udiddit, A Social News Aggregator
Icon - Dark upwards trend arrow
SQL skills are more in demand by employers than programming languages like Java, JavaScript, and Python!

All Our Programs 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.
Personal career coach and career services

Personal career coach and career services

You’ll have access to career coaching sessions, interview prep advice, and resume and online professional profile reviews to help you grow in your career.
Flexible learning program

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
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
Career services
Personal career coaching
New
icon-checkmarkCheckmark
Interview preparations
icon-checkmarkCheckmark
Resume services
icon-checkmarkCheckmark
Github review
icon-checkmarkCheckmark
LinkedIn profile review
icon-checkmarkCheckmark
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
Personal Career Coach
Career Coaching
Get personalized 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

Top Student Reviews

 

(0)

 

        

 

        

 

        

 

        

 

        

 

        

Get started with

Learn SQL

Icon-Book-blue
Learn
Master SQL, the core language for Big Data analysis, and enable insight-driven decision-making and strategy for your business.
Icon - Clock -Blue
Average Time
On average, successful students take null months to complete this program.
Icon - Project - Blue
Benefits include
  • Real-world projects from industry experts
  • Technical mentor support
  • Personal career coach & career services
blue stacked bills
STAY SHARP WHILE STAYING IN
  • Financial support available worldwide to help in this challenging time
  • Spend your time at home learning new, higher-paying job skills
  • Commit to a brighter future by learning today
Get Financial Support

Impacted by COVID-19? We're offering deeper discounts. Apply and see how much.

Get your discount

15% OFF

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

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?
    Access to this Nanodegree program 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 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.