Oracle Database 11g: SQL Fundamentals I - OCA

Blended & eLearning

  • Overview
  • Entry Requirements
  • Principal Areas of Study
  • Assessment & Award
  • Career/Academic Progression
  • Resources & Supports

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. 

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.

An understanding of databases and exposure to information technology in general.
This course is for those who needs to use and understand Oracle SQL to query and update an Oracle database; and who also needs an introduction to the PL/SQL programming language

 

.

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

  • Overview
  • SQL Fundamentals
  • Writing Simple Queries
  • Accepting Values at Runtime
  • Summary
  • Exam Essentials
  • Review Questions

Unit 2: Using Single-Row Functions

  • Overview
  • Single-Row Function Fundamentals
  • Using Single-Row Character Functions
  • Using Single-Row Numeric Functions
  • Using Single-Row Date Functions
  • Using Single-Row Conversion Functions
  • Using Other Single-Row Functions
  • Summary
  • Exam Essentials
  • Review Questions

Unit 3: Using Group Functions

  • Overview
  • Group-Function Fundamentals
  • Utilizing Aggregate Functions
  • Summary
  • Exam Essentials
  • Review Questions

Unit 4: Using Joins and Subqueries

  • Overview
  • Writing Multiple-Table Queries
  • Using Set Operators
  • Subqueries
  • Summary
  • Exam Essentials
  • Review Questions

Unit 5: Manipulating Data

  • Overview
  • Using DML Statements
  • Understanding Transaction Control
  • Summary
  • Exam Essentials
  • Review Questions

Unit 6: Creating Tables and Constraints

  • Overview
  • Database Objects Overview
  • Built-in Datatypes
  • Creating Tables
  • Modifying Tables
  • Managing Constraints
  • Summary
  • Exam Essentials
  • Review Questions

Unit 7: Creating Schema Objects

  • Overview
  • Creating and Modifying Views
  • Creating and Managing Sequences
  • Creating and Managing Synonyms
  • Creating and Managing Indexes
  • Summary
  • Exam Essentials
  • Review Questions

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.

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

Expert Instructor-Led Training using only the IT industry’s finest instructors. This elearning course provides a personal learning experience that gives you all the benefit of hands-on training with the flexibility of doing it around your schedule 24/7.  Unlike a live class, you can study at your own pace.

Interactive Exercises
The courseware includes real world, interactive exercises that always focus on real world scenarios and skill-set development. 

The course is structured to enable learners to retain and recall the knowledge by teaching learners using interactive exercises.  Features such as actionable analytics and study planner help in keeping students focused.

Practice Test Sets 
Course include full length practice test sets designed to test your knowledge under real exam conditions. Each course has a number of test sets consisting of hundreds of items to ensure you are 100% prepared before taking your certification exam.

Exercises, Quizzes & Flashcards
Exercises, quizzes and flashcards prepare you for your exams differently and more effectively than the traditional exam preps on the market. You will have practice quizzes, flashcards and exercises after each module to ensure you are confident on the topic you have completed before proceeding. This will allow you to gauge your effectiveness before moving to the next module in your course.