Introduction

Pricing options

Payment is once only and you have unlimited access to the material.

Course curriculum

    1. About this course

    2. Introduction to Database

    3. What is a relational database

    4. Structured Query Language - SQL

    5. Windows - Getting started with SQL Server

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

    1. Introduction

    2. Create/Drop Database

    3. Data Types Part 1

    4. Data Types Part 2

    5. Create/Drop Table

    6. Primary Key

    7. Unique Constraint

    8. Check Constraint

    9. NOT NULL and DEFAULT

    10. Foriegn Key

    11. Alter Statement

    12. Truncate Statement

    13. DDL Assignment

    1. Introduction

    2. INSERT Statement

    3. INSERT INTO Statement

    4. UPDATE Statement

    5. DELETE Statement

    6. DML Exercise

    1. Introduction

    2. SELECT

    3. Where Clause

    4. AND & OR

    5. LIKE

    6. IS & NOT

    7. DISTINCT

    8. ORDER

    1. Introduction

    2. Left Join

    3. Left Outer Join

    4. Right Join

    5. Right Outer Join

    6. Full Outer Join

    7. Inner Join

    8. Union

    9. Cross Join

    10. SQL Joins Assignment

    1. Introduction

    2. Count

    3. Min

    4. Max

    5. Avg

    6. Sum

    7. Group By

    8. Having

    9. Common Table Expression - CTE

    10. AVERAGE - AVG

    11. Sum - SUM

About this course

  • £299.00
  • 82 lessons
  • 15 hours of video content

Discover your potential, starting today

Enroll today