|
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.
| Advance Excel
(Financial Aplication) |
Course
Title: Microsoft Excel, Level 2 (2003, XP, 2003/2007) |
This program is designed
for executives who are already familiar with the basics of Microsoft
Excel, and who would like to work with more advanced features of
Microsoft Excel that help in improving their efficiency of working
with worksheets, analyzing data, creating MIS reports, and automating
various tasks. |
Audience |
Executives and managers
who have already been using Microsoft Excel, but now feel the need
for learning more powerful features and options of Excel, to manage
their worksheet-related tasks more efficiently. |
| Prerequisites |
Participants attending
this training should be familiar with the basic operations in
Microsoft Excel, such as simple calculations, formatting and printing.
|
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 $) |
| 160 sessions of 1 hr. each |
24,000 |
685 |
|
Performing complex calculations more efficiently, using various
Excel functions.
+91-22-236762182