Oracle Certification

OCA (Oracle 11g Certified Associate)

academy_wht

The Oracle Database 11g SQL Fundamentals course is designed to give learners practical experience in writing SQL statements and scripts using Oracle SQL. The basic SELECT statement, the use of SQL functions, SQL*Plus parameters and the basic table and view handling statements are introduced.

Oracle Database 11g SQL Fundamentals I candidates are expected to demonstrate proficiency in concepts of relational databases and the powerful SQL programming language. The certification is targeted at developers and database administrators who want to design, develop, and manage SQL based applications with the Oracle database.

Passing this the “Oracle 11g Certification exam #1Z0-051” plus the test entitled “Oracle 11g Administration I #1Z0-052” makes you an Oracle 11g Certifies Associate (OCA).

The course also provides practical experience in using Oracle’s PL/SQL programming language to implement conditional execution, loop control, cursor handling and exception handling.

Code IZO-051
Duration 6 Months
Comments Learners have 6 Months to complete this Professional course. Start at any time of the year. This course is mentor supported. Exam Fees are not included in course fees.

 

Principle Area of Study:
Oracle Database 11g SQL Fundamentals I candidates are expected to demonstrate proficiency in concepts of relational databases and the powerful SQL programming language. The certification is targeted at developers and database administrators who want to design, develop, and manage SQL based applications with the Oracle database.

Unit 1: Introducing SQL
Unit 2: Using Single-Row Functions
Unit 3: Using Group Functions
Unit 4: Using Joins and Subqueries
Unit 5: Manipulating Data
Unit 6: Creating Tables and Constraints
Unit 7: Creating Schema Objects

Assessment & Award:
The course includes practice test designed to test your knowledge under real exam conditions. Each course has number of test sets consisting of hundreds of items to ensure you are 100% prepared before taking your certification exam.

Award
1Z0-051: Oracle Database 11g: SQL Fundamentals

Career & Academic Progression:
The course will provide the skills needed to query and update data held in an Oracle Relational Database.  It will provide an introduction to Oracle PL/SQL as a preparation for other Oracle products such as Forms and Reports.

The Skills gained on this course

  • Retrieval of Data using SQL Select Statement
  • Restricting, Manipulating and Sorting Data
  • Use of Single-Row Functions to Customize Output
  • Conversion functions and Conditional Expressions
  • DDL Statements to create and manage tables
  • Creation of Schema Objects
  • Aggregated Data using Group Functions
  • Multiple Tables