Introduction to Database Systems

Subjects

Introduction to databases

• Databases
• Types of data
• Database Design Process
• Relational Model Overview
• Database Relationships and Keys

SQL Basics

• SQL Data Definition Language (DDL)
• SQL Data Manipulation Language (DML)
• SQL Select Statements
• Joins in SQL

Complex SQL

• Subqueries
• Views in SQL
• SQL Division

Functions, Trigger and Transactions

• Functions in SQL
• Triggers in SQL
• Transactions in SQL
• SQL in Python

ER Modeling

• Entity-Relationship Modeling (ER Modeling)

Normalization

• Functional Dependencies
• Normalization

Storage Hierarchy & Indexing

• Storage Hierarchy & Physical Database Design
• Indexing

B-trees

• B+ trees

Query Selection

• Query Selections
• Query Selections With Joins

Storage Models & DBMS Architecture

• Database Workloads
• Storage Models
• DBMS Architecture

Transaction Management

• Transaction Management

Scaling Out, NoSQL & CAP Theorem

• Scale Out and Scale Up
• NoSQL
• CAP Theorem

Week 12 - Big Data Analytics

• Big Data