|
Diploma In Database - Administration [RDBMS]
Oracle is a Relational
Database Management System (RDBMS).Oracle's
latest technology, today's systems designers and Developers can build
21st century enabled application ranging from critical on-line transaction
processing systems supporting thousand of users to multi-terabyte data
warehouses for decision support and also World Wide Web-based applications.
SALIENT FEATURES
-
Oracle has sophisticated
security mechanisms to control access to sensitive Data by An assortment
of privileges.
-
It Provides sophisticated
backup & recovery routines. Backup creates a second copy of
Data, recovery restores a copy of data from Back up.
-
It provides flexible
space management. It has special abilities that are capable of handling
very large databases.
-
It provides open
connectivity to & from other vendors software.
-
Oracle server
supports a wide range of Development tools, end user Query tools,
off the shelf applications & office wide information tools.
APPLICATION
-
Critical on-line
transaction processing systems supporting thousands of users to
multi-terabyte data warehouses for decision support and also World
Wide Web based applications.
TOPICS COVERED
-
Introduction to
products.
-
SQL*plus features
and commands.
-
Data manipulation
commands, data control commands.
-
Altering tables,
data definition commands, joins, types of functions.
-
Process Transaction
commands, SQL*plus set theory.
-
Sub-queries and
CO-related queries.
-
Views, clusters,
indexes, synonyms, snapshots.
-
Formatting output
of queries, Report creation.
-
Introduction to
PL/ SQL.
-
Cursors, exceptions,
procedures, database functions and triggers.
MS-ACCESS
-
Learning it, will
help you in storing, managing, manipulating large numbers of records
in very less time.
-
MS-Access can be
used as a BackEnd with VisualBasic as a FrontEnd because it becomes
easy to connect an application program with a database
program like MS-Access.
-
MS-Access is used
in fields like Business, Medical, Defense and many more since
all these fields have large amount of information to be stored.
-
MS-Access also
allows you to develop commercial applications like Financial, Accounting
and Inventory packages.
Microsoft SQL SERVER 2003
SQL
Server, the Relational Database Management System(RDBMS) allows to
store huge Database and manage the same easily. It is an enterprise
database management and analysis system.
Salient
Features
-
Data
Transformation Services : Automate routines that extract, transform,
and load data from heterogeneous sources.
Applications:
- Production
Industry
- Data
warehousing companies
- Educational
/ Training Industry
- Any
business or service industry that stores database
Topics
- Basics
of RDBMS
- Introduction
to SQL ( Structured Query Language)
- Querying
data from SQL Server database
- Developing
various objects like tables, views
- Data
Integrity - Constraints, Rules, Defaults
- Programming
in SQL Server
- Security
in SQL Server - Creating users and ensuring authentication.
- Creating
stored programs
- Procedures
- Functions
- Triggers
- Working
with SQL Enterprise Management window.
- SQL
Server new features.
MYsql
MySQL develops and markets
a family of high performance, affordable database servers and tools.
MySQL AB is defining a new database standard.
This is based on its dedication to providing a less complicated
solution suitable for widespread application deployment at
a greatly reduced TCO. MySQL's robust database solutions embody an ingenious
software architecture while delivering dramatic cost savings.
With superior speed, reliability, and ease
MySQL has become the preferred choice
of corporate IT Managers because it eliminates the major problems associated
with downtime, maintenance, administration and support.
MySQL is a
key part of LAMP (Linux, Apache, MySQL, PHP / Perl / Python), a fast
growing open source enterprise software stack).
| Course Duration |
Fees (Indian RS.) |
Fees (US $) |
| 140 sessions of 1 hr. each |
23,000 |
670 |
|
