Overview

Oracle 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.

The Oracle Database Associate training leads to the following technology qualification career paths at ITC Technologies:

Prerequisites

•                    CompTIA IT Fundamentals training or similar working experience or

•                    CompTIA A+ training or similar working experience.

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    

Duration and Schedule

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.

Overview

Oracle 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.

The Oracle Database Associate training leads to the following technology qualification career paths at ITC Technologies:

Prerequisites

•                    CompTIA IT Fundamentals training or similar working experience or

•                    CompTIA A+ training or similar working experience.

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    

Duration and Schedule

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.