Duration: Hours

An RDBMS is a relational database management system. An Oracle Database (aka Oracle RDBMS) is a collection of data organized by type with relationships being maintained between the different types. The primary purpose of a database is to store and retrieve related information.

Training Mode: Online

Enquiry

    Category:

    Description

     1. Introduction to Databases and Transactions :

    • What is database system, purpose of database system, view of data, relational databases, architecture, transaction management.

    2. Data Models :

    • The importance of data models, Basic building blocks, Business rules, The growth of data models, Degrees of data abstraction.

    3. Database Design ,ER-Diagram and Unified Modeling Language :

    • Database design and ER Model:overview, ER-Model, Constraints, ER-Diagrams, ERD Issues, weak entity sets, Codd’s rules, Relational Schemas, Introduction to UML.
    • RDBMS: Logical view of data, keys, honor rules.
    •  Database design and ER Model : Overview, ER-Model, Constraints, ER-Diagrams, ERD Issues, weak entity sets, Codd’s rules, Relational Schemas, Introduction to UML.
    • RDBM design: Features of good  design, atomic domain and Normalization (1NF, 2NF, 3NF, BCNF).

    4. Relational Algebra and Calculus :

    • Relational algebra: Introduction, Selection and calculation, set operations, Joins, Division, syntax, Operators, group and ungroup, relational comparison.
    • Calculus : Tuple relational calculus, Domain relational Calculus, calculus vs algebra, computational capabilities.

    5. Constraints, Views and SQL :

    • What is constraints, types of constrains, Integrity constraints.
    • Views: Introduction to views, data independence, security, updates on views, and compare between tables and views.
    • SQL : Data Definition, Aggregate function, Null Values, nested sub queries, Joined relations. Triggers.

    6. Transaction management and Concurrency control :

    • Transaction management: ACID property, serializability and concurrency control, Lock based concurrency control (2PL, Deadlocks),Time symbol methods, positive methods, database recovery management.

     

    For more inputs on Oracle RDBMS you can connect here.
    Contact the L&D Specialist at Locus IT.

    Reviews

    There are no reviews yet.

    Be the first to review “Oracle RDBMS”

    Your email address will not be published.