Name Of The Training Institute : National Institute of Computer Technology (nict.net.in)
Location Of The Training Institute : Delhi
Training Offered : Database Management System Training
Website : nict.net.in/database-management-system.php
Database Management System Training :
Duration: 100 hrs
Fees : Rs. 10,000/-
RDBMS Concepts :
** Need for DBMS
** What are RDBMS and their Examples
** Entities, Attributes, and Tuples
** Relationships and Entity-Relationship Diagrams
** Codd Rules.
** Normalization and Denormalization.
MS Access :
** Creating a Database
** Creating a Table – Design View and Datasheet view
** Data Types, Wizards, Queries
** Inserting, Deleting and Updating Data
** Forms and Form Wizards
** Controls e.g. Label, Textbox, Option Button, etc.
** Reports and Report Wizards
** Creating a whole application
** Relationships, Macros, Security
MS SQL 7.0 :
** Retrieving Data using Select Statements, Mathematical operators, relational operators, where clause etc.
** Joins (Cross, Inner, Outer and Self)
** Sub Queries
** Creating Database and Tables
** Adding and dropping Constraints (Primary Key, Foreign key and check)
** Creating, binding, unbinding and dropping Rules and defaults
** Insert – Inserting row into a table by insert command,
** Insert Into – Inserting data into a table from another table
** Select into – Selecting Data form a table and saving in new Table
** Insert Update and Delete Statements
** Dropping and Deleting objects
** Creating Views (Operations using Views) and Stored
** Procedures (Variables, conditional Statement, loops)
** Creating Indexes (Clustered and Non Clustered),its benefits and working.
** Triggers (Insert, Update, and Delete) , Magic Tables etc.
Oracle 8i :
** Invoking SQL *Plus
** Creating Table, Inserting Data, Updating, Deleting Data
** Select Command and Constraints
** Oracle Functions
** Joins, Union, Intersect and minus clauses
** Sequence, PL / SQL
** Cursor (Opening, fetching rows and closing cursors)
** Stored Procedures and Stored Functions
** Triggers ( Row, Statement, Before, After, Combination triggers)
** Form Module ( Layout, Interface and Internal Events)
** Creating and displaying Menus
** Property Class
** Master Detail Form
** Cross Table Updation (Insert, Modify, Delete Module)
** Creating and using List Items
** Parameter Passing in Form
** ToolBars
** Reports (Default Tabular Report, Break Report, Master/Detail Report, Matrix Report)
** Oracle Graphics
Database Administration :
** Understanding SQL Server Logs
** Process Info
** Locks / Process Ids
Database Maintenance :
** Database Maintenance Plans
** Taking Backups
** Restoring Backups
** Importing/Exporting Data
Security features :
** Creating Users, Roles and Logins
** Give/Take and Manage permissions
Address Of The Training Institute :
National Institute of Computer Technology
O-92, Bank Street
Munirka
New Delhi-110067