BSCS2001 · Knowledge Base
Dbms Notes
28
Concepts
0
Facts
0
Procedures
concept
1m
635 - 01 - Database Management Systems- Introduction
concept
1m
636 - 04 - SQL DDL- Creating Database Schemas
concept
1m
637 - 02 - DBMS Architecture
concept
1m
638 - 03 - The Relational Model
concept
1m
639 - 05 - SQL Queries- SELECT, WHERE, ORDER BY
concept
1m
640 - 06 - SQL Aggregation & Grouping
concept
1m
641 - 07 - Advanced SQL- Subqueries, Set Operations & Views
concept
1m
642 - 08 - SQL Joins
concept
1m
643 - 09 - SQL Functions, Procedures, Triggers & Security
concept
1m
644 - 10 - Relational Algebra
concept
1m
645 - 11 - Relational Calculus
concept
1m
646 - 12 - Entity-Relationship (ER) Model
concept
1m
647 - 13 - ER-to-Relational Mapping
concept
1m
648 - 14 - Functional Dependencies
concept
1m
649 - 15 - Canonical Cover & Extraneous Attributes
concept
1m
650 - 16 - Normalization- 1NF, 2NF, 3NF
concept
1m
651 - 17 - BCNF & Higher Normal Forms
concept
1m
652 - 18 - Decomposition (Lossless & Dependency-Preserving)
concept
1m
653 - 19 - Application Design & Development
concept
1m
654 - 20 - Storage Systems & Disk Management
concept
1m
655 - 21 - RAID Systems
concept
1m
656 - 22 - File Organization
concept
1m
657 - 23 - Indexing
concept
1m
658 - 24 - B+ Tree Index
concept
1m
659 - 25 - Hashing
concept
1m
660 - 26 - Transactions & ACID
concept
1m
661 - 27 - Serializability
concept
1m