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.

Locus Academy has more than a decade experience in delivering the training/staffing on Oracle RDBMS  for corporates across the globe. The participants for the training/staffing on Oracle RDBMS  are extremely satisfied and are able to implement the learnings in their on going projects.