SQL Trail Blazed

08 Jul 2021

Follow the SQL Trail

Introduction

• Relational Model
• Keys and Constraints
• DDL
• DML
• SQL Basics
• Advanced SQL
  • PL/SQL
  • Stored Procedures
  • Triggers
  • Indexes
  • Windows Functions

Database Design

• ER Model
• ER to Relational Model
• Functional Dependency
• Normalization

Transactions

• Concurrency control
• Locking Protocol
• Two-Phase Locking
• B+ Trees
• Hashing

Practice Excercise

• Boat Reservation System
• Oracle Emp table