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.
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.
Program Objectives
This Advanced Excel training program will empower the participants to be able to do the following:
Performing complex calculations more efficiently, using various Excel functions. Organizing and analyzing large volumes of data. Creating MIS reports. Designing and using templates. Consolidating and managing data from multiple workbooks.
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
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).
Course Duration
Fees (Indian RS.)
Fees (US $)
70 sessions of 1 hr. each
11,500
330
Management has full right tochange courses, contents, tuition fees without prior notice.
Click here to Register for
COMPUFIELDoffers a unique style of learning -
One computer : One student : One Instructor
The timing can be fixed based on our mutual convenience,
between 9.00 a.m. to 7.00 p.m.
Maximum Instructor to Student Ratio 1:4
Course duration in working days = Total sessions divided by number of sessions (hours) per day.
Sessions : Each session will be of 1 hour
No extra charges/refund for more/less time taken to complete the course.
Fees is for one course and it includes instructions, practicals,practice, project, preparation for exam (if any)
Lodging, boarding and travelling not included in the fees.
Overseas / local Students take 5 to 10 hours per day to complete their courses earlier.
Performing complex calculations more efficiently, using various Excel functions.
