Diploma In Database - Administration
[RDBMS]
Diploma
In Database - Administration [RDBMS]
Oracle
is a Relational Database Management System (RDBMS).
Oracle is 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
user's to multi-terabyte data warehouses for decision support
and also World Wide Web-based applications.
SALIENT
FEATURES
- Oracle
has sophisticated security mechanisms 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 vendor's 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-tetrabyte 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
- MS-Access
is a Relational Database Management System (RDBMS) first
of its kind to be put under Windows.
- 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 database like MS-Access.
- MS-Access
is used in fields like for e.g. Business, Medical, Defense
and many more since all this field have large amount of
information to be stored.
- MS-Access
also allows you to develop commercial application like Financial,
Accounting and Inventory packages.
SQL SERVER
SQL
Server is the Database Management System (RDBMS) allows to store
huge Database and manage the same easily. Its enterprise database
management and analysis system.
SALIENT
FEATURES
- XML
Support: Simplify the integration of your back-end systems
and data transfer across firewalls using XML.
- High
Availability : Maximize the availability of your business
applications with log shipping, online backups, and failover
clusters.
- Automated
Tuning : Automatic tuning and maintenance features enable
administrators to focus on other critical tasks.
- Improved
Developer Productivity : User-defined functions, cascading
referential integrity, and the integrated Transact-SQL debugger
allow you to reuse code to simplify the development process.
- Security
: Ensure your applications are secure in any networked
environment, with role-based security and file and network
encryption.
- Data
Transformation Services : Automate routines that extract,
transform, and load data from heterogeneous sources.
APPLICATIONS
- Multinational
Companies with huge database to be maintained
- Banking
Industry
- Production
Industry
- Data
warehousing companies
- Educational
/ Training Industry
- Air-transportation
Service 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.
| Course Duration |
Fees (Indian
Rs.) |
Fees (US $) |
| 160 sessions
of 1 hr. each |
24,000 |
685 |
|
