YoVDO

SQL Fluency

Offered By: Udacity

Tags

SQL Courses Data Analysis Courses Relational Databases Courses Database Design Courses Data Aggregation Courses

Course Description

Overview

SQL is one of the most versatile tools available for extracting insights from stored data. In this course, you will learn how databases work. You will also learn some basic SQL queries for that can be used to select, manipulate and aggregate data in databases.

Syllabus

  • Introduction to Relational Databases
    • Learn the principles behind relational data organization: tables, queries, aggregations, keys, and joins.
  • Getting Started in 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.
  • Creating a Database Using Tables
    • Create your own database tables using normalized table design, using keys to declare relationships between tables; then apply these relationships to draw conclusions from data.
  • SQL Joins
    • In this lesson, you will learn how to combine data from multiple tables together.
  • SQL Aggregations
    • In this lesson, you will learn how to aggregate data using SQL functions which allow you to count, sum, find the minimum value, the maximum value, or an average of the data values.

Related Courses

MongoDB for .NET Developers
MongoDB University
Implementing ETL with SQL Server Integration Services
Microsoft via edX
Практики оперативной аналитики в MS Excel
Saint Petersburg State University via Coursera
Analyzing Big Data with SQL
Cloudera via Coursera
Data Analysis Using Python
University of Pennsylvania via Coursera