SQL Nanodegree Udacity

Overview

The SQL Nanodegree programme is offered by Udacity  covers SQL fundamentals, advanced querying, and database management. Learn to work with multiple tables, perform data aggregation and cleaning, use window functions, and optimize queries for large datasets. Apply your skills to real-world projects, analyzing deforestation data and redesigning databases. 

Gain proficiency in SQL for data analysis, database design, and management, preparing for roles requiring strong data manipulation and insight generation. Ideal for aspiring data analysts, business intelligence professionals, and those seeking to enhance their data querying and management skills.

Nanodegree Skills

Introduction to SQL

• SQL subqueries

• SQL joins

• SQL aggregations

• SQL window functions

• SQL queries

• SQL query performance tuning

• Data cleaning

Management of Relational and Non-relational Databases

• Mongodb

• SQL CRUD commands

• Database normalization

• Redis

• Database indexing

• Data manipulation language

• Query plans

• SQL query performance tuning

• Rdbms performance and optimization

• Foreign keys

• Database fundamentals

• Business rule enforcement in databases

• Database schemas