Natu Academy

About this course

Introduction to Database

What is a relational database

Structured Query Language - SQL

Windows - Getting started with SQL Server

MacOS - Getting started with SQL Server using Docker and VS Code

Introduction

Create/Drop Database

Data Types Part 1

Data Types Part 2

Create/Drop Table

Primary Key

Unique Constraint

Check Constraint

NOT NULL and DEFAULT

Foriegn Key

Alter Statement

DDL Assignment

Introduction

INSERT Statement

INSERT INTO Statement

UPDATE Statement

DELETE Statement

DML Exercise

Introduction

SELECT

Where Clause

AND & OR

LIKE

IS & NOT

DISTINCT

ORDER

Introduction

Left Join

Left Outer Join

Right Join

Right Outer Join

Full Outer Join

Inner Join

Union

Cross Join

SQL Joins Assignment

Introduction

Count

Min

Max

Avg

Sum

Group By

Having

Common Table Expression - CTE

AVERAGE - AVG

Sum - SUM