Diploma In Database - Administration [RDBMS] |
| |
| ~ |
Oracle - SQL |
|
| ~ |
Advance Excel |
| ~ |
Microsoft SQL-Server 2003 |
| ~ |
MYSQL |
| |
| Our Programming Student's Review |
 |
 |
 |
| Programming Review |
| 1 |
2 |
3 |
|
| |
| ORACLE - SQL |
| |
| 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 control access to sensitive data by an assortment of privileges
Oracle provides sophisticated backup & recovery routines. Backup creates a second copy of Oracle Data, recovery restores a copy of data from back up.
Oracle provides flexible space management. It has special abilities that are capable of handling very large databases.
Oracle 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. |
| |
For Oracle Sql Topics Covered  |
| |
| ADVANCE Excel |
| |
| 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. |
| |
| 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. |
| |
For Advance Excel Topics Covered  |
| |
| 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 |
| |
| Application |
| |
~
~
~
~ |
Production Industry
Data warehousing companies
Educational / Training Industry
Any business or service industry that stores database |
| |
For Microsoft SQL Server 2005 Topics Covered  |
| |
| MySQL |
| |
| Salient Features |
| |
It’s easy to use:
MySQL software can be downloaded in less than 15 minutes.
It’s flexible: MySQL runs on more than 20 platforms, including Windows, Mac OS X, and Linux, and its open source code allows you to customize it to fit your unique requirements.
It’s highly scalable: Whether you're looking to post a few things a month to your Web site or looking to add content daily, MySQL is fit to handle Web sites large and small and will easily grow as your business does.
It’s free: A commercial license can be bought if you plan on redistributing it.
It’s secure: Security features ensure that only authorized users can access your databases.
It also provides 24/7 tech support and community support. |
| |
| Application |
| |
| Open source has brought a lot more than Unix to the computing world. It has also given us Linux, PHP and MySQL. PHP and MySQL are the world's best combination for creating database-driven sites. |
| |
For MySQL Topics Covered  |
| |
| Course Duration |
Fees (Indian RS.) |
Fees (US $) |
| 120 sessions of 1 hr. each |
23,000 |
660 |
|
| |