Curriculum

  • 1

    Database and SQL

    • SQL Intro

    • What is Relational Database?

    • Install DBeaver

    • DBeaver Overview

    • Simple Selects

    • SQL operators

    • Assignment1

    • Assignment1 Solution

    • Order By command

    • Distinct Command

    • SQL Calculations

    • Group By Command

    • Assignment 2

    • Assignment 2 Solution

    • CRUD - update/delete DB records

    • Joins

    • Alias

    • Why to use alias - additional examples

    • Different Types of Joins

    • Join of 3 tables

    • Assignment 3

    • Assignment 3 Solution

    • How to test Database?

    • ETL and Data Validation

    • Presentation

    • SQL basics quiz

    • Self-Learning - SQL Injection

    • Project: Documentation and Diagram

    • Project: Connect to remote Postgres server

    • Project: work with Job-Cafe database example

    • M10 - DataBase Testing Project