Play all

Intro

What is SQL

A Closer Look at Databases

The Core SQL Syntax

Course Setup

The Example Project

Data Normalization

Planning Tables & Relationships

Creating a New Database

Choosing Identifier Names

Defining Columns

Exploring Key Value Types

Storing Files & Adding More Data Types

Introducing Constraints

Introducing Functions

Primary Keys & Unique IDs

Inserting Data

Querying Data

Updating & Deleting Data

Filtering & Ordering

Adding More Tables

Relations & Foreign Keys

ON DELETE & ON UPDATE

Adding More Tables & Relationships

Many-to-Many Relationships & Linking Tables

Inserting Related Data

Introducing Inner Join

Multiple Joins Combined

Introducing Left Join

Joins & Filtering

LIKE Text Filtering

Introducing Aggregate Functions

Grouping Aggregate Results

The HAVING Clause

Summary

Description:

Embark on a comprehensive SQL crash course designed for beginners, covering both MySQL and PostgreSQL with no prior knowledge required. Learn the fundamentals of databases, core SQL syntax, and data normalization before diving into practical skills like creating databases, defining columns, and implementing constraints. Master essential operations such as inserting, querying, updating, and deleting data, as well as advanced concepts including relationships, foreign keys, and various types of joins. Explore filtering techniques, aggregate functions, and grouping results to enhance your data manipulation capabilities. By the end of this 3-hour 26-minute tutorial, gain a solid foundation in SQL to kickstart your journey in database management and querying.

SQL Crash Course for Beginners - MySQL & PostgreSQL

Academind

Add to list

#Programming #Domain-Specific Languages (DSL) #SQL #Databases #Relational Databases #MySQL #PostgreSQL #Data Science #Data Manipulation