Complete DBMS: Basics To Advanced
What is Data, Information, Database & DBMS?
Complete DBMS: Basics To Advanced
0%
Completed
Introduction
What is Data, Information, Database & DBMS?
Video - 00:12:51 mins
Types of Databases
Video - 00:12:20 mins
Download DBMS Lecture Notes
Reading
Data Abstraction, Schema & Independence
Data Abstraction
Video - 00:7:29 mins
DBMS Architecture & Its Types
Video - 00:10:57 mins
Schema and Instance
Video - 00:17:21 mins
Data Independence
Video - 00:4:14 mins
Views in DBMS
Video - 00:6:26 mins
DBMS Core Concepts (Tables, Keys & Constraints)
Tables, Constraints, Primary Key & Foreign Key
Video - 00:11:02 mins
Keys in DBMS
Video - 00:15:27 mins
ER Model (Conceptual Database Design)
ER Model
Video - 00:18:02 mins
Entity & Its Types
Video - 00:10:53 mins
Attributes in ER Model | Types of Attributes in DBMS
Video - 00:13:28 mins
Relationships & Degree in ER Model
Video - 00:11:20 mins
Types of Relationships
Video - 00:7:12 mins
One-to-Many (1:N) Relationship
Video - 00:7:16 mins
Many-to-One (N:1) Relationship
Video - 00:7:45 mins
Many-to-Many (M:N) Relationship
Video - 00:8:58 mins
Extended ER Features
Video - 00:7:06 mins
Specialization in ER Model
Video - 00:9:06 mins
Generalization in ER Model
Video - 00:8:00 mins
Aggregation in ER Model
Video - 00:9:22 mins
How to Draw ER Diagram
Video - 00:10:03 mins
Normalization & Functional Dependencies
What is RDBMS? DBMS vs RDBMS
Video - 00:8:35 mins
Normalization in DBMS
Video - 00:13:57 mins
First Normal Form (1NF)
Video - 00:10:22 mins
Second Normal Form (2NF)
Video - 00:10:32 mins
Third Normal Form (3NF)
Video - 00:8:03 mins
Boyce-Codd Normal Form (BCNF)
Video - 00:8:23 mins
How to Find Highest Normal Form
Video - 00:12:03 mins
How to Normalize a Table
Video - 00:9:57 mins
Database Security & Recovery
Database Security
Video - 00:11:45 mins
Database Backup and Recovery Strategy
Video - 00:10:58 mins
Transaction Management & Concurrency Control
Concurrency Control
Video - 00:13:00 mins
Transaction Management
Video - 00:11:38 mins
Indexing & Query Optimization
Indexing in DBMS
Video - 00:13:42 mins
Query Optimization
Video - 00:14:53 mins
SQL (Structured Query Language)
SQL Basics & CRUD Operations
Video - 00:15:47 mins
SQL Queries
Video - 00:14:51 mins
SQL Database Design & Table Creation
Video - 00:13:02 mins
Emerging Trends in Databases
Emerging Trends in DBMS
Video - 00:12:14 mins
Conclusion
Thank You
Reading
More
Announcements
Reviews
Course Info
Hide similarities
Highlight differences
Select the fields to be shown. Others will be hidden. Drag and drop to rearrange the order.
Image
SKU
Rating
Price
Stock
Availability
Add to cart
Description
Content
Weight
Dimensions
Additional information
Click outside to hide the comparison bar
Compare
