Ask Question / Post resume

Post a reply to the thread: National Institute of Computer Technology Delhi www.nict.net.in : Database Management System Training

Your Message

Your Username:

Click here to log in

Notes:-
1) You can copy and paste your full resume in the box below.
2) Or you can ask your question. We try to answer, as far as possible.

Title:

[QUOTE=mariammal;162392][B]Name Of The Training Institute  [/B]: National Institute of Computer Technology ( nict.net.in )

[B]Location Of The Training Institute  [/B]: Delhi

[B]Training Offered  [/B]:
[B]Database Management System Training  [/B]:
[B]RDBMS Concepts  [/B]:
    Need for DBMS
    What are RDBMS and their Examples
    Entities, Attributes, and Tuples
    Relationships and Entity-Relationship Diagrams
    Codd Rules.
    Normalization and Denormalization.

[B]MS Access  [/B]:
    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

[B]MS SQL 7.0  [/B]:
    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.

[B]Oracle 8i  [/B]:
    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

[B]Database Administration  [/B]:
    Understanding SQL Server Logs
    Process Info
    Locks / Process Ids

[B]Database Maintenance  [/B]:
    Database Maintenance Plans
    Taking Backups
    Restoring Backups
    Importing/Exporting Data

[B]Security features  [/B]:
    Creating Users, Roles and Logins
    Give/Take and Manage permissions

[B]Address Of The Training Institute  [/B]:
National Institute of Computer Technology
O-92, Bank Street
Munirka
New Delhi-110067

[B]Website  [/B]: [URL="http://www.nict.net.in"]www.nict.net.in[/URL]

[B]Email Address  [/B]: [EMAIL="info@nict.net.in"]info@nict.net.in[/EMAIL][/QUOTE]

All times are GMT +5.5. The time now is 01:33 AM.