Professional Development
Oracle ClassesOracle Database technology is used by the world’s leading companies to manage critical business functions, systems and processes.
- Oracle Database is the number one database in the world.
- Over 305,000 top companies trust their critical systems to Oracle Database.
- Oracle Database is the number one embedded database technology.
In fact, 97% of Global Fortune 500 companies use Oracle software. Well-trained, highly-skilled database professionals who can manage critical systems are in high demand.
The process of becoming Oracle Database certified broadens your knowledge and skills by exposing you to a wide array of important database features, functions and tasks. Oracle Database certification teaches you how to perform complex, hands-on activities through labs, study and practice.
Additionally, Oracle certification exams validate your capabilities using real-world, scenario-based questions that assess and challenge your ability to think and perform.
With the 12c release, Oracle Database is re-engineered for Cloud computing. Multitenant architecture brings enterprises unprecedented hardware and software efficiencies, performance and manageability benefits, and fast and efficient Cloud provisioning. Oracle Database 12c certifications emphasize the full set of skills that DBAs need in today’s competitive marketplace.
Oracle Database Associate Certification Class
The Oracle Database Associate training leads to the following technology qualification career paths at ITC Technologies:
Duration:
Day time: 3 weeks
Evenings: 4 weeks.
Weekends: 6 weeks
Schedule:
Day-time Mornings: Mondays to Thursdays, 8am to 12 noon
Day-time Afternoons: Mondays to Thursdays, 1pm to 5pm
Evenings: Mons /Weds / Fridays, 6pm to 10pm
Saturdays: 9am to 5pm.
Topics Covered
- Using Structured Query Language (SQL)
- Using Data Definition Language (DDL)
- Defining SELECT Statements
- Using Single-Row Functions to Customize Output
- Using Conversion Functions and Conditional Expressions
- Displaying Data from Multiple Tables
- Using Subqueries to Solve Queries
- Using the Set Operators
- Manipulating Data
- Using DDL Statements to Create and Manage Tables
- Managing Objects with Data Dictionary Views
- Controlling User Access
- Manipulating Large Data Sets
Prerequisites
- CompTIA IT Fundamentals training or similar working experience or
- CompTIA A+ training or similar working experience.
| Price Per Student: $ 2,000 | |
| Included in Fees |
· Tuition · Certified Instructor · Official Textbook · Practice tests and simulation software · Two exams valued $450 |
| Exam and certification requirements | |
| Required Exams |
You need to pass two exams · Oracle Database 12c SQL 1Z0-071 and 1ZO-072 |
| Exam Format |
· 73 multiple choice Questions · 12 simulation questions · 100 minutes |
| Passing Score | · 63% |
Oracle Database Professional Certification Class
The Oracle Database Professional training leads to the following technology qualification career paths at ITC Technologies:
Duration:
Day time: 3 weeks
Evenings: 4 weeks.
Weekends: 6 weeks
Schedule:
Day-time Mornings: Mondays to Thursdays, 8am to 12 noon
Day-time Afternoons: Mondays to Thursdays, 1pm to 5pm
Evenings: Mons /Weds / Fridays, 6pm to 10pm
Saturdays: 9am to 5pm.
Topics Covered
-
Managing Multitenant Architecture
- CDB basics
- CDB and Regular PDBs
- Application PDBs and Application Installation
- PDB Creation
- CDB and PDB Management
- Data Storage
- Data Security
- Backup, Recovery, and Flashback
- Performance Monitoring
- Resources Allocation
- Data Movement
- PDBs in Cloud
-
Backup and Recovery Workshop
- Using the RMAN Recovery Catalog
- Backup Strategies and Terminology
- Performing Backups
- Improving Your Backups
- Using RMAN-Encrypted Backups
- Diagnosing Failures
- Restore and Recovery Concepts
- Performing Recovery, Part 1
- Performing Recovery, Part 2
- RMAN and Oracle Secure Backup
- Using Flashback Technologies
- Using Flashback Database
- Transporting Data
- Performing Point-in-Time Recovery
- Duplicating a Database
- RMAN Troubleshooting and Tuning
- Cloud Tooling for Backup and Recovery
-
Install and Upgrade Workshop
- Oracle Software Installation Basics
- Installing Oracle Grid Infrastructure for a Standalone Server
- Patching Oracle Software
- Installing Oracle Database Software
- Oracle Restart
- Preparing to Upgrade to Oracle Database 12c
- Performing Post-Upgrade Tasks
- Migrating Data by Using Oracle Data Pump.
Prerequisites
- CompTIA IT Fundamentals training or similar working experience or
- CompTIA A+ training or similar working experience.
- Oracle Database Associate Training and Certification.
| Price Per Student: $ 2,000 | |
| Included in Fees |
· Tuition · Certified Instructor · Official Textbook · Practice tests and simulation software · Two exams valued $250 |
| Exam and certification requirements | |
| Required Exams |
You need to pass two exams · Oracle Database 12c 1Z0-073 |
| Exam Format |
· 73 multiple choice Questions · 12 simulation questions · 100 minutes |
| Passing Score | · 63% |
Oracle Certified Java Associate (OCA – Developer)
Topics Covered
- Create command-line Java applications
- Understand and apply Object-Oriented concepts such as Encapsulation, Inheritance and Polymorphism
- Use java types
- Create conditional statements and loops
- Manipulate Arrays and Collections
- Handle Exceptions
- Take advantage of new Java SE 8 features, such as Lambda expressions and Date/Time API
| Price Per Student: $ 1,500 | |
| Included in Fees | · Tuition · Certified Instructor · Official Textbook · Practice tests and simulation software · Two exams valued $245 |
| Exam and certification requirements | |
| Required Exams | You need to pass two exams · Java SE 8 Programmer I 1Z0-808 |
| Exam Format | · 70 multiple choice questions · 150 minutes |
| Passing Score | · 65% |
