Temporary DBMS

• DBMS Basics
  • What is Data
  • What is Database
  • What is Database Management System
  • File Systems vs DBMS (Why we shifted to DBMS)
• Architecture and Models 
  • DBMS Architecture
    • 2 Level
    • 3 Level
  • Need For DBMS
  • Data Abstraction and Data Independence
  • DBMS Database Models
  • Data Models 
    • Hierarchical Model
    • Network Model
    • Entity-relationship Model
    • Relational Model
    • Object-Oriented Relation DBMS
• ER MODEL
  • ER Data Model Basics concepts. (Attributes, relationships, Entities)
  • Entity-Relationship Model Advanced
    • Key Attribute
    • Composite Attribute
    • Multivalued Attribute
    • Derived Attribute
  • Cardinality
    • One to One
    • One to Many
    • Many to One
    • Many to Many
  •  Relationships
    • Unary Relationship
    • Binary Relationship
    • n – ary Relationship
    • Recursive Relationship
    • Ternary Relationship
  • Participation Constraint
  • Weak Entity and Strong Entity
  • Generalization Specialization and Aggregation
    • Generalization
    • Specialization
    • Aggregation
• Relational Database Model
  • Codd’s Rule
  • RDBMS
  • Relational Data Model
  • Keys in the Relational Model
  • Keys in DBMS 
    • Primary Key in DBMS | Oracle | SQL
    • Foreign Key in DBMS | Oracle | SQL
    • Candidate Key in DBMS | Oracle | SQL
    • Super Key in DBMS | Oracle | SQL
    • Alternate Key in DBMS | Oracle | SQL
    • Composite Key in DBMS | Oracle | SQL
    • Non-Prime Attribute
  • SQL Constraints
    • Default in DBMS | Oracle | SQL
    • Not Null in DBMS | Oracle | SQL
    • Unique in DBMS | Oracle | SQL
    • Check-in DBMS | Oracle | SQL
    • Key Constraints in DBMS | Oracle | SQL
    • Domain constraints in DBMS | Oracle | SQL
    • Mapping constraints
  • ER to Relational Model Conversion
• Relational Algebra
  • Basic Operators
  • Extended Operators
• Relational Calculus
  • Tuple Relational Calculus (TRC)
  • Domain Relational Calculus (DRC)
• Functional Dependencies :
  • Functional Dependency and Attribute Closure
  • Equivalence of Functional Dependencies
  • Canonical Cover
• Normalization:
  • Introduction Normalisation
  • Normal Forms
    • 1NF Form
    • 2NF Form
    • 3NF Form
    • Boyce-Codd Normal Form
    • 4NF
    • 5NF
  • Joins in DBMS | SQL
    • Inner Joins in DBMS | SQL
    • Outer Join in DBMS | SQL
    • Left Join in DBMS | SQL
    • Right Join in DBMS | SQL
  • Dependency Preserving Decomposition
  • Lossless Join Decomposition
  • Lossless Join and Dependency Preserving Decomposition
• Introduction to Transactions and Concurrency Control :
  • Deadlock in DBMS
  • ACID Properties in DBMS | Oracle | SQL
  • Concurrency Control Protocols – Lock-Based Protocol
  • Conflict Serializability
  • View Serializability
  • Recoverability of Schedules
• Indexing, B and B+ trees :
  • Indexing and its Types
  • B-Tree Introduction
  • B-Tree Insert
  • B-Tree Delete
• DBMS -HASHING
• SQL
  • Predicate in DBMS | Oracle | Pl/SQL
  • SQL -Operators in DBMS | Oracle | Pl/SQL
  • SQL- Expressions in DBMS | Oracle | Pl/SQL
  • CREATE  Table  in DBMS | Oracle | Pl/SQL
  • ALTER-Table  in DBMS
  • DROP table in DBMS | Oracle | Pl/SQL
  • TRUNCATE table in DBMS | Oracle | Pl/SQL
  • RENAME  table in DBMS | Oracle | Pl/SQL
  • Row  in DBMS | Oracle | Pl/SQL
  • Tuple  in DBMS | Oracle | Pl/SQL
  • Record  in DBMS | Oracle | Pl/SQL

• Queries:-
  • SELECT in DBMS | Oracle | SQL
  • INSERT in DBMS | Oracle | SQL
  • WHERE in DBMS | Oracle | SQL
  • AND & OR in DBMS | Oracle | SQL
  • UPDATE in DBMS | Oracle | SQL
  • DELETE in DBMS | Oracle | SQL
  • LIKE in DBMS | Oracle | SQL
  • ORDER BY in DBMS | Oracle | SQL
  • SQL AGGREGATE FUNCTIONS in DBMS
  • GROUP BY in DBMS | Oracle | SQL
  • DISTINCT in DBMS | Oracle | SQL

• SQL SET OPERATIONS IN DBMS 

  • UNION-UNION ALL
  • INTERSECT 
  • MINUS
• ADVANCED SQL
  • NULL in DBMS | Oracle | SQL
  • USING VIEWS in DBMS | Oracle | SQL
  • INJECTION in DBMS | Oracle | SQL
  • HANDLING DUPLICATES in DBMS | Oracle | SQL

————————————————————