Database Notes
Note to Readers
Reading guide
Course Outline
1
Introduction
Overview
1.1
Database System Applications
1.2
Purpose of Database System
1.3
View of Data
1.4
Database Languages
1.5
Database Design
1.6
Database Engine
1.7
Database & Application Architecture
1.8
Database Users and Administrators
2
Introduction to the Relational Model
2.1
Structure of the Relational Databases
2.2
Database Schema
2.3
EXCLUDED
2.4
Schema Diagrams
2.5
Relational Query Language
2.6
Relational Algebra
3
Introduction to SQL
3.1
Overview of the original version of SQL
3.2
SQL Data Defintion
3.3
Basic structure of SQL queries
3.4
Additional Basic Operations
3.5
Set Operations
3.6
Null Values
3.7
Aggregate Functions
3.8
Nested Subqueries
3.9
Modification of the Databases
4
Intermediate SQL
4.1
Example one
4.2
Example two
5
Advanced SQL
5.1
Accessing SQL from a Programming Language
5.2
Functions and Procedures
5.3
Triggers
5.4
Recursive Queries
6
Database Design using the E-R Model
7
Relational Database Design
7.1
Features of a Good Relational Design
7.2
Decomposition using Functional Dependencies
7.3
Normal Forms
8
Skipped Ch. 8
9
Application Development
9.1
Application Programs & User Interfaces
9.2
Web Fundamentals
9.3
Servlets
10
Skipped Ch. 10
11
indexing
12
Storage
12.1
Overview of Physical Storage Media
12.2
Storage Interfaces
12.3
Magnetic Disks
12.4
Performance measurement of disks
12.5
Flash Storage
12.6
Optimization of Disk-block Access
13
Skipped
14
Transactions
14.1
Transaction Concept
14.2
A Simple Transaction Model
14.3
Atomicity and Durability
14.4
Isolation
14.5
Serializability
14.6
Isolation and Atomicity
My Linkedin
Link to Project Repository
Database Notes
6
Database Design using the E-R Model