A world class curriculum developed by CMS in close partnership with technology leaders like Microsoft, Red Hat & Oracle. The programmes we offer are designed by our team of experts, based on the global industry requirements.



One of the best placement records in the industry, we help our students gain a foothold in IT industry. The top names in the IT sector recognizes CMS students for their technical prowess and 80% of our students work with top IT recruiters and market leaders.



We deliver On-Job training to students and help them develop industry-ready practical skills, which is extremely critical to get good jobs. Our training centres open doors to myriad opportunities in an ever growing IT industry.



At CMS our aim is to bring global expertise and world class knowledge to you in the most cost effective manner. With a strong nation wide network of training centers, we work hard to bring down the cost of training.


Toll Free:




:: ORACLE DBA WITH PL/SQL Training Course

The Oracle Corporation is an American global computer technology corporation, headquartered in Redwood City, California. The company primarily specializes in developing and marketing computer hardware systems and enterprise software products – particularly its own brands of database management systems. In 2011 Oracle was the second-largest software maker by revenue, after Microsoft.

An Oracle database is an ORDBMS, provides open comprehensive integrated approach to information management. The purpose of a database is to store and retrieve related information. A database server is the key to solving the problems of information management. In general, a server reliably manages a large amount of data in a multiuser environment so that many users can concurrently access the same data. All this is accomplished while delivering high performance. A database server also prevents unauthorized access and provides efficient solutions for failure recovery.

Oracle 11g offers the benefits of Grid Computing delivering higher quality of service, lower cost, and greater flexibility. Higher quality of service results from having no single point of failure, a robust security infrastructure, and centralized, policy-driven management.

This course is designed for Candidates OR Professionals who wish to upgrade their technical skills with Oracle 11g Data base administration or looking for appearing OCA/OCP global certification on Oracle 11g.

In this course the candidate will learn the basics of relational data bases and the powerful SQL Programming language.

Details of the course is given below.

ProgramsHoursTopics covered
Oracle Data Base 11g-Introduction to SQL 2.040Introduction
Retrieving Data Using the SQL SELECT Statement
Using Single-Row Functions to Customize Output
Using Conversion Functions and Conditional Expressions
Reporting Aggregated Data Using the Group Functions
Using Subqueries to Solve Queries
Using the Set Operators
Manipulating Data
Using DDL Statements to Create and Manage Tables
Creating Other Schema Objects
Controlling User Access
Managing Schema Objects
Managing Objects with Data Dictionary Views
Manipulating Large Data Sets
Retrieving Data by Using Subqueries
Regular Expression Support


  • Standard course curriculum as prescribed by Oracle.
  • Official Courseware from Oracle.
  • Certified, Skilled and Experienced Technical Trainers.
  • Prepares the candidate to pass the global certification OCA/OCP exams.
  • Job Assistance on course completion.

Placement numbers


Number of Training Centers


Expert Faculty


Courses covered


About us

CMSIT Talent Development Center (TDC) is the Information Technology training division founded in 1993 and associated with Trinity Academy for Corporate Training Limited (TACT Ltd.). With 25 years of track record, we are ranked among the best hardware, networking, and software training institute in the country.

Read More>

Contact us