SQL Nanodegree Program v1.0.0

Nanodegree key: nd072

Version: 1.0.0

Locale: en-us

Learn SQL.

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

Content

Part 01 : Welcome to the SQL Nanodegree Program

Welcome to the SQL Nanodegree program! Learn more about the pre-requisites, structure of the program, and getting started!

Module 01: SQL Nanodegree Program Orientation
- Lesson 01: SQL Nanodegree Program Introduction
  Welcome to the SQL Nanodegree program! In this lesson, you will learn more about the structure of the program and meet your instructors.
- Lesson 02: Knowledge, Community, and Careers
  You are starting a challenging but rewarding journey! Take 5 minutes to read how to get help with projects and content.

Part 02 : Introduction to SQL

When it comes to extracting insights from stored data, SQL is one of the most versatile tools available.
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.

Module 01: Introduction to SQL
- Lesson 01: Basic SQL
  In this section, you will gain knowledge about SQL basics for working with a single table. You will learn the key commands to filter a table in many different ways.
- Lesson 02: SQL Joins
  In this lesson, you will learn how to combine data from multiple tables together.
- Lesson 03: SQL Aggregations
  In this lesson, you will learn how to aggregate data using SQL functions
- Lesson 04: SQL Subqueries & Temporary Tables
  In this lesson, you will learn about subqueries, a fundamental advanced SQL topic. This lesson will walk you through the appropriate applications of subqueries, the different types of subqueries, and review subquery syntax and examples.
- Lesson 05: SQL Data Cleaning
  Cleaning data is an important part of the data analysis process. You will be learning how to perform data cleaning using SQL in this lesson.
- Lesson 06: SQL Window Functions
  Window functions allow users to compare one row to another without doing any joins using one of the most powerful concepts in SQL data analysis.
- Lesson 07: SQL Advanced JOINS & Performance Tuning
  Learn advanced joins and how to make queries that run quickly across giant datasets. Most of the examples in the lesson involve edge cases, some of which come up in interviews.
- Lesson 08: Deforestation Exploration
  In this project, students will be putting their SQL skills to the test to help determine where to concentrate efforts to combat deforestation.
  
  Project Description - Deforestation Exploration
  
  Project Rubric - Deforestation Exploration

Part 03 : 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.

Module 01: Management of Relational & Non-Relational Databases
- Lesson 01: Intro to DBMS: Relational and Non-Relational Databases
  Get introduced to database management systems, as well as learning the difference between relational and non-relational databases.
- Lesson 02: Normalizing Data
  Find out about the different forms of normalized data for optimizing database storage.
- Lesson 03: Data Definition Language (DDL)
  Learn about the data definition language, such as creating tables and different data types.
- Lesson 04: Data Manipulation Language (DML)
  Dive into the data manipulation language in order to alter existing tables and data.
- Lesson 05: Consistency with Constraints
  Find out how to keep consistency amongst your data by adding constraints.
- Lesson 06: Performance with Indexes
  Maximize your database performance by using indexes when and where appropriate.
- Lesson 07: Intro to Non-Relational Databases
  With your relational database skills in hand, you’re ready for a look into the other side of data, with non-relational databases.
- Lesson 08: Udiddit, A Social News Aggregator
  Investigate a poorly designed database for Udiddit, a social news aggregator. You’ll design a new, normalized and performant database and migrate over data from the previous database.
  
  Project Description - Udiddit, A Social News Aggregator
  
  Project Rubric - Udiddit, A Social News Aggregator
  - Concept 01: Project Introduction and Instructions
  - Concept 02: SQL Terminal Workspace

Part 04 : Career Services

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.

Module 01: Nanodegree Career Service
- Lesson 01: Take 30 Min to Improve your LinkedIn
  Find your next job or connect with industry peers on LinkedIn. Ensure your profile attracts relevant leads that will grow your professional network.
  
  Project Description - Improve Your LinkedIn Profile
  
  Project Rubric - Improve Your LinkedIn Profile