Skip to main content
Playground
SQL Playground
DBMS [CS2001]
About the Course
Week-01
Introduction
View of Data
Database Design
Week-02
Relational Model & DDL
Data Manipulation (DML) & Basic Queries
Advanced SQL Filtering, Sets & Aggregation
Week-03
Nested Subqueries
Joins
Intermediate SQL
Advanced SQL
SQL Examples
Week-04
Relational Algebra and Calculus
Relational Algebra and Calculus: Examples
Entity-Relationship Model
University Schema: ER Example
Advanced ER Concepts
Week-05
Functional Dependencies
Armstrong Axioms
Extraneous attributes & Canonical cover
Lossless Join & Dependency preservation
Week-06
Introduction to Normalization
Normal Forms (1NF to 3NF)
BCNF and Multivalued Dependencies
Week-07
Application Programs and Architecture
SQL and Native Languages
RAD, Application Security, and Mobile Apps
Week-08
Algorithms & Data Structures
Physical Storage Systems
Disk Performance Math
File Organization & Buffering
Week-09
Indexing
Tree-Based Index Structures
Hashing and Bitmap Indices
Week-10
Transactions and ACID Properties
Schedules and Serializability
Concurrency and Locking
Deadlocks and Timestamps
(Optional) Real-World Concurrency
Week-11
Backup and Recovery
Log-Based Recovery
RAID: Redundant Array of Independent Disks
Week-12
Query Processing and Cost
Join Algorithms
Query Optimization and Equivalence
Architecture, Scaling, and Big Data
Playground
SQL Playground
Python-DB Playground
Playground
SQL Playground
SQL Playground
FLIS Database (Read-Only)
LIS Database (Read-Only)
eShop Database (Read-Only)
University Database (Read-Only)
My Workspace (Persistent)
Run Query
Reset
Chrome
Clouds
Crimson Editor
Dawn
Dreamweaver
Eclipse
GitHub
IPlastic
Solarized Light
TextMate
Tomorrow
XCode
Kuroir
KatzenMilch
SQL Server
CloudEditor
Ambiance
Chaos
CloudEditor Dark
Clouds Midnight
Cobalt
Dracula
GitHub Dark
Green on Black
Gruvbox
idle Fingers
krTheme
Merbivore
Merbivore Soft
Mono Industrial
Monokai
Nord Dark
One Dark
Pastel on dark
Solarized Dark
Terminal
Tomorrow Night
Tomorrow Night Blue
Tomorrow Night Bright
Tomorrow Night 80s
Twilight
Vibrant Ink
A-
16px
A+
Ctrl
+
/
comment
Ctrl
+
Enter
run
Running...
Schema
Architecture, Scaling, and Big Data
Python-DB Playground