Learn DBMS in 24 Hours

Table Of Content

Chapter 1: What is DBMS (Database Management System)? Application, Types & Example

• What is a Database?
• What is DBMS?
• Example of a DBMS
• History of DBMS
• Characteristics of Database Management System
• DBMS vs. Flat File
• Users in a DBMS environment
• Popular DBMS Software
• Application of DBMS
• Types of DBMS
• Advantages of DBMS
• Disadvantage of DBMS
• When not to use a DBMS system?

Chapter 2: Database Architecture in DBMS: 1-Tier, 2-Tier and 3-Tier

• What is Database Architecture?
• Types of DBMS Architecture
• 1-Tier Architecture
• 2-Tier Architecture
• 3-Tier Architecture

Chapter 3: DBMS Schemas: Internal, Conceptual, External

• Internal Level/Schema
• Conceptual Schema/Level
• External Schema/Level
• Goal of 3 level/schema of Database
• Advantages Database Schema
• Disadvantages Database Schema

Chapter 4: Relational Data Model in DBMS: Concepts, Constraints, Example

• What is Relational Model?
• Relational Model Concepts
• Relational Integrity Constraints
• Operations in Relational Model
• Best Practices for creating a Relational Model
• Advantages of using Relational Model
• Disadvantages of using Relational Model

Chapter 5: ER Diagram: Entity Relationship Diagram Model | DBMS Example

• What is ER Diagram?
• What is ER Model?
• History of ER models
• Why use ER Diagrams?
• Facts about ER Diagram Model
• ER Diagrams Symbols & Notations
• Components of the ER Diagram
• WHAT IS ENTITY?
• Relationship
• Weak Entities
• Attributes
• Cardinality
• How to Create an Entity Relationship Diagram (ERD)
• Best Practices for Developing Effective ER Diagrams

Chapter 6: Relational Algebra in DBMS: Operations with Examples

• Relational Algebra
• Basic SQL Relational Algebra Operations
• SELECT (s)
• Projection()
• Rename ()
• Union operation ()
• Set Difference (-)
• Intersection
• Cartesian product(X)
• Join Operations
• Inner Join:
• Theta Join:
• EQUI join:
• NATURAL JOIN ()
• OUTER JOIN
• Left Outer Join(A B)
• Right Outer Join: ( AB )
• Full Outer Join: ( AB)

Chapter 7: DBMS Transaction Management: What are ACID Properties?

• What is a Database Transaction?
• Facts about Database Transactions
• Why do you need concurrency in Transactions?
• States of Transactions
• What are ACID Properties?
• Types of Transactions
• What is a Schedule?

Chapter 8: DBMS Concurrency Control: Timestamp & Lock-Based Protocols

• What is Concurrency Control?
• Potential problems of Concurrency
• Why use Concurrency method?
• Concurrency Control Protocols
• Lock-based Protocols
• Two Phase Locking Protocol
• Timestamp-based Protocols
• Validation Based Protocol
• Characteristics of Good Concurrency Protocol

Chapter 9: DBMS Keys: Candidate, Super, Primary, Foreign Key Types with Example

• What are Keys in DBMS?
• Why we need a Key?
• Types of Keys in DBMS (Database Management System)
• What is the Super key?
• What is a Primary Key?
• What is the Alternate key?
• What is a Candidate Key?
• What is the Foreign key?
• What is the Compound key?
• What is the Composite key?
• What is a Surro

Dettagli