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