DEV Community

Ha3k
Ha3k

Posted on

DBMS

#dbms #database #sql #programming

Unit 1: Database System Architecture

Data Abstraction
Enter fullscreen mode Exit fullscreen mode 
Data Independence
Enter fullscreen mode Exit fullscreen mode 
Data Definition Language (DDL)
Enter fullscreen mode Exit fullscreen mode 
Data Manipulation Language (DML)
Enter fullscreen mode Exit fullscreen mode 
Entity-Relationship Model
Enter fullscreen mode Exit fullscreen mode 
Network Model
Enter fullscreen mode Exit fullscreen mode 
Relational Data Model
Enter fullscreen mode Exit fullscreen mode 
Object-Oriented Data Models
Enter fullscreen mode Exit fullscreen mode 
Integrity Constraints
Enter fullscreen mode Exit fullscreen mode 
Data Manipulation Operations
Enter fullscreen mode Exit fullscreen mode

Unit 2: Relational Query Languages & Design

Relational Algebra
Enter fullscreen mode Exit fullscreen mode 
Tuple Relational Calculus
Enter fullscreen mode Exit fullscreen mode 
Domain Relational Calculus
Enter fullscreen mode Exit fullscreen mode 
SQL3
Enter fullscreen mode Exit fullscreen mode 
DDL Constructs
Enter fullscreen mode Exit fullscreen mode 
DML Constructs
Enter fullscreen mode Exit fullscreen mode 
Open Source DBMS (MySQL, PostgreSQL)
Enter fullscreen mode Exit fullscreen mode 
Commercial DBMS (Oracle, DB2, SQL Server)
Enter fullscreen mode Exit fullscreen mode 
Domain Dependency
Enter fullscreen mode Exit fullscreen mode 
Data Dependency
Enter fullscreen mode Exit fullscreen mode 
Armstrong’s Axioms
Enter fullscreen mode Exit fullscreen mode 
Normal Forms (1NF, 2NF, 3NF, BCNF)
Enter fullscreen mode Exit fullscreen mode 
Dependency Preservation
Enter fullscreen mode Exit fullscreen mode 
Lossless Design
Enter fullscreen mode Exit fullscreen mode 
Evaluation of Relational Algebra Expressions
Enter fullscreen mode Exit fullscreen mode 
Query Equivalence
Enter fullscreen mode Exit fullscreen mode 
Join Strategies
Enter fullscreen mode Exit fullscreen mode 
Query Optimization Algorithms
Enter fullscreen mode Exit fullscreen mode

Unit 3: Storage Strategies

Indices
Enter fullscreen mode Exit fullscreen mode 
B-Trees
Enter fullscreen mode Exit fullscreen mode 
Hashing
Enter fullscreen mode Exit fullscreen mode

Unit 4: Transaction Processing

Concurrency Control
Enter fullscreen mode Exit fullscreen mode 
ACID Properties
Enter fullscreen mode Exit fullscreen mode 
Serializability of Scheduling
Enter fullscreen mode Exit fullscreen mode 
Locking-Based Schedulers
Enter fullscreen mode Exit fullscreen mode 
Timestamp-Based Schedulers
Enter fullscreen mode Exit fullscreen mode 
Multi-Version Concurrency Control
Enter fullscreen mode Exit fullscreen mode 
Optimistic Concurrency Control
Enter fullscreen mode Exit fullscreen mode 
Database Recovery
Enter fullscreen mode Exit fullscreen mode

Unit 5: Database Security

Authentication
Enter fullscreen mode Exit fullscreen mode 
Authorization
Enter fullscreen mode Exit fullscreen mode 
Access Control
Enter fullscreen mode Exit fullscreen mode 
DAC (Discretionary Access Control)
Enter fullscreen mode Exit fullscreen mode 
MAC (Mandatory Access Control)
Enter fullscreen mode Exit fullscreen mode 
RBAC (Role-Based Access Control)
Enter fullscreen mode Exit fullscreen mode 
Intrusion Detection
Enter fullscreen mode Exit fullscreen mode 
SQL Injection
Enter fullscreen mode Exit fullscreen mode

Unit 6: Advanced Topics

Object-Oriented Databases
Enter fullscreen mode Exit fullscreen mode 
Object-Relational Databases
Enter fullscreen mode Exit fullscreen mode 
Logical Databases
Enter fullscreen mode Exit fullscreen mode 
Web Databases
Enter fullscreen mode Exit fullscreen mode 
Distributed Databases
Enter fullscreen mode Exit fullscreen mode 
Data Warehousing
Enter fullscreen mode Exit fullscreen mode 
Data Mining
Enter fullscreen mode Exit fullscreen mode

Top comments (0)