| |
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
For Corporate Training in this course CLICK HERE
Course Title: Microsoft Excel, Level 2 (2003, XP, 2003/2007) |
Duration : 30 hrs |
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.
|
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 - 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.
- 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: - 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).
|
Performing complex calculations more efficiently, using various Excel functions.
