+91- 84000 84111
Summer Training Program 2017

Database Management System Training Course


About Course
    The course is basically designed for developers, learners to familiarize with Database Management System using SQL Server Management Studio. The training period allows the developer to understand different features of Database Management System with SQL Queries.


Prerequisites
    Before joining any Professional Programming Courses students should have very basic knowledge of any one programming language like "C", "C++", or any other programming language basics. It will be helpfull to understand the subject in easiest and in better way.

Syllabus Overview
    Concept and Overview of DBMS
  • Data Models
  • Database Languages
  • Database Administrator
  • Database User Three Schema Architecture of DBMS

  • Entity Relationship Model
  • Basic Concepts
  • Design Issues
  • Mapping Constraints
  • Keys
  • Entity Relationship Diagram
  • Weak Entity

  • Relational Model
  • Relational Database
  • Relational Algebra
  • Relational Calculus
  • Extended Relational Algebra Operation
  • Views
  • Modification of Database

  • SQL and Intigrity Constraints
  • Concept of DDL, DML, DCL
  • Basic Structure
  • Set Operations
  • Aggregate Functions
  • Null Values
  • Domain Constraints
  • Referential Integrity Constraints
  • Assertions
  • Views
  • Nested Sub queries
  • Stored Procedures and Triggers

  • Relational Database Design
  • Functional Dependency
  • Different Anomalies in designing a Database
  • Normalization using functional dependencies
  • Decomposition
  • BCNF (Boyce-Codd Normal Form)
  • 3NF
  • Normalization using Multivalued Dependency
  • 4NF
  • 5NF

  • Internals and RDBMS
  • Physical Data Structures
  • Query Optimization: Join Algorithm
  • Transaction Processing
  • Concurrency Control and Recovery Management

Close
Select Your Training Location

Type your e-mail address and we'll send you new password

Submit