EncartaLabs

RDBMS - Essentials

( Duration: 2 Days )

In RDBMS - Essentials Training Course, Participants get an overview of the important relational database concepts. At the end of this course, they will obtain:

  • 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

This RDBMS - Essentials workshop is designed for everybody who is interested in relational theory - application developers and analysts, data modelers, DBAs, system managers - and also for those who want a general overview of the characteristics of an RDBMS.

COURSE AGENDA

1

Introduction to Database Management Systems (DBMS)

  • Database Management System: overview
  • 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
2

Introduction to RDBMS

  • Definition: RDBMS
  • Features Of an RDBMS
  • Some Important Terms
  • Properties of Relations
  • Keys
  • Referential Integrity
  • Summary
3

Relational Algebra

  • Relational Query Languages
  • Example Instances
  • Relational Algebra
  • Projection
  • Selection
  • Union, Intersection, Set Difference
  • Cross Product
  • Joins
  • Equi-Joins
  • Division
4

Introduction to Query Optimization

  • Processing a high-level query
  • Techniques for Query Optimization
  • Motivating Examples
5

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
6

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
7

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

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 4,000 Modules on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting http://encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.

Top