Master SQL, the core language for Big Data analysis, and enable insight-driven decision-making and strategy for your business.
01Days07Hrs33Min18Sec
At 10 hours / week
Get access to the classroom immediately on enrollment
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.
Basic understanding of data types (e.g., string, integer, etc.)
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.
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.
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 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 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.
With real-world projects and immersive content built in partnership with top-tier companies, you’ll master the tech skills companies want.
Our knowledgeable mentors guide your learning and are focused on answering your questions, motivating you, and keeping you on track.
You’ll have access to Github portfolio review and LinkedIn profile optimization to help you advance your career and land a high-paying role.
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.
We provide services customized for your needs at every step of your learning journey to ensure your success.
project reviewers
projects reviewed
reviewer rating
avg project review turnaround time
Pay as you go
per
/
/
Pay upfront and save an extra 0%
for - access
Master SQL, the core language for Big Data analysis, and enable insight-driven decision-making and strategy for your business.
On average, successful students take 2 months to complete this program.
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!
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.
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).
There is no application. This Nanodegree program accepts everyone, regardless of experience and specific background.
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
Basic understanding of data types (e.g., string, integer)
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.
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.
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.
Please see the Udacity Program FAQs for policies on enrollment in our programs.
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.