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

NANODEGREE PROGRAM

Learn SQL

Contact Us Below to Learn More about our Enterprise Solutions

ESTIMATED TIME

2 months

At 10 hrs/week


PREREQUISITES

Basic understanding of data types

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.

General Info

Project Examples

Deforestation Exploration

In this project, you will act as a data analyst for an organization on a mission to reduce deforestation around the world and to raise awareness about this important environmental topic. First, you’ll clean any erroneous values in a table, join that table to another lookup table to bring in a new categorical and quantitative variable, and return a new view of all categories greater than a reference value. Then, you will create and execute SQL queries to perform calculations using variables from those disparate data sets to answer questions for stakeholders.

Udiddit, A Social News Aggregator

In this project, you will build the supporting data structures for Udiddit, a social media news aggregator site. First, you’ll investigate the provided data model for potential errors such as lack of normalization, consistency rules, and proper indexing. Then, you will create a new, normalized database using DDL based on the denormalized one that is provided. Lastly, you will write DML queries to migrate the data from the denormalized schema to their normalized schema.

©2020 Udacity, Inc. All Rights Reserved