SQL

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

• 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!
• Introduction to SQL
• SQL is one of the most versatile tools available for extracting insights from stored data.
  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, and 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.
  
• Management of Relational and 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.
• 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.