Course Overview

During this RDBMS Concepts Training, participants get an overview of the most important relational database concepts. At the end of this course, participants will have obtained: a thorough knowledge of the relational database model the necessary background to start studying a specific relational system - DB2, Oracle, SQLServer, Sybase, PostgreSQL, MySQL, etc

Course Content

  • Introduction to Database Management Systems (DBMS)
  • Database Management System: Definitions
  • DBMS
  • Benefits of database approach
  • DBMS functions
  • Database System
  • Data Model
  • Database Architecture
  • An Example of the Three Levels
  • Schema
  • Data Independence
  • Types Of Database Models
  • Database Design Phasesfont>
  • Introduction to RDBMS
    • Definition: RDBMS
    • Features Of an RDBMS
    • Some Important Terms
    • Properties of Relations
    • Keys
    • Referential Integrity
    • Summary
  • Relational Algebra
    • Relational Query Languages
    • Example Instances
    • Relational Algebra
    • Projection
    • Selection
    • Union, Intersection, Set Difference
    • Cross Product
    • Joins
    • Equi-Joins
    • Division
  • Introduction to Query Optimization
    • Processing a high-level query
    • Techniques for Query Optimization
    • Motivating Examples
  • Conceptual Design Using The Entity-Relational Model
    • Overview Of Database Design
    • E-R Modeling
    • Graphical Representation
    • Types Of Relationships
    • E-R Diagram: Some Examples
    • Case Study
  • Schema Refinement and Normalization
    • Normalization and Normal Forms
    • Why Normal Forms
    • The Evils Of Redundancy
    • Refining an ER Diagram
    • First Normal Form
    • Functional Dependencies
    •  Example: Constraints On Entity Set
    • Second Normal Form
    • Transitive Dependency
    • Third Normal Form
    • Boyce Codd Normal Form (BCNF)
    • Decomposition of a Relation Scheme
    • Lossless Join Decompositions
    • Case Study
  • ER Modeling and Normalization
    • Case Study.
  • Transaction, Concurrency Control and Recovery
    • Transactions
    • The ACID Properties
    • Why Have Concurrent Processes?
    • Schedules
    • Serializable Schedules
    • Serializability Violations
    • Cascading Aborts
    • Recoverable Schedules
    • Locking: A Technique For Concurrency Control
    • Two-Phase Locking
    • Handling A Lock Request
    • Recovery
    • Logging
    • Handling the Buffer Pool
    • Write Alead Logging
    • Checkpoints in the System Log

Customer Reviews

Thanks to Xpertised and the tutor who walked me through all the topics with Practical exposure which is helping me in my current project.

Course was quite helpful in terms of understanding of concepts and practicality. Its really a very friendly environment to learn. The timing were mutually chosen, as we both are working professional. I am quite satisfied with the course.


For Batch Details
Call us at: +91 7259222234

Not sure? Consult Our Experts

Looking for a Training for


My Team/Organization

I agree to be contacted over mail or phone

Call us at: +91 7259222234