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 :
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

Website : www.nict.net.in

Email Address : info@nict.net.in