YoVDO

SQL Fundamentals

Offered By: egghead.io

Tags

SQL Courses PostgreSQL Courses Relational Databases Courses Data Integrity Courses Data Manipulation Courses Database Management Courses Data Aggregation Courses

Course Description

Overview

Most applications rely on databases to store data. Understanding how to create a database and communicate with it unlocks a critical power in your web development career.
In this course, Tyler presents all the building blocks of creating and interacting with a PostgreSQL database. From creating a brand new table, up through organizing and aggregating data across multiple tables, you will learn the fundamental skills of SQL — and you’ll be prepared to apply them right away.
After completing this course, you’ll be ready to tackle more challenging SQL topics like proper data modeling, normalizing data, and exploring different database types.
Check out the Community Notes for this course.

Syllabus

  • Setup and Introduction to SQL Fundamentals
  • Create a Table with SQL Create
  • Add Data to a Table with SQL Insert
  • Query Data with the Select Command in SQL
  • Update Data in a Table with SQL Update
  • Removing Data with SQL Delete, Truncate, and Drop
  • Keep Data Integrity with Constraints
  • Organize Table Data with Indexes
  • Select Grouped and Aggregated Data with SQL
  • Conditionally Select out Filtered Data with SQL Where
  • Combining Tables Together with SQL Join Statements
  • Subquery Dynamic Datasets in SQL

Taught by

Tyler Clark

Related Courses

Introduction to Databases
Meta via Coursera
Web Development
Udacity
Introduction to Data Science
University of Washington via Coursera
Datenmanagement mit SQL
openHPI
Sabermetrics 101: Introduction to Baseball Analytics
Boston University via edX