Oracle Database 11g: SQL Fundamentals I - OCA

(1Z0-051) / ISBN: 9781616911881
This course includes
Mentoring (Add-on)
Lessons
TestPrep
Share
$139.99
Are you an instructor?
Request free evalution copy

Oracle Database 11g: SQL Fundamentals I - OCA

The Oracle 11g Administrator Certified Associate (OCA) certification is a streamlined, entry-level certification for the database-administration track and is required to advance toward the more senior certification tiers.
Here's what you will get

Certification is proof of your knowledge and shows that you have the skills required to support Oracle core products. The Oracle certification program can help a company identify proven performers who have demonstrated their skills and who can support the company's investment in Oracle technology. It demonstrates that you have a solid understanding of your job role and the Oracle products used in that role.

Lessons
  • 7+ Lessons
  • 554+ Exercises
  • 377+ Quizzes
  • 115+ Flashcards
  • 115+ Glossary of terms
Test Preps
  • 15+ Pre Assessment Questions
  • 51+ Post Assessment Questions
Here's what you will learn
Download Course Outline
  • Overview
  • SQL Fundamentals
  • Writing Simple Queries
  • Accepting Values at Runtime
  • Summary
  • Exam Essentials
  • Review Questions
  • 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
  • Overview
  • Group-Function Fundamentals
  • Utilizing Aggregate Functions
  • Summary
  • Exam Essentials
  • Review Questions
  • Overview
  • Writing Multiple-Table Queries
  • Using Set Operators
  • Subqueries
  • Summary
  • Exam Essentials
  • Review Questions
  • Overview
  • Using DML Statements
  • Understanding Transaction Control
  • Summary
  • Exam Essentials
  • Review Questions
  • Overview
  • Database Objects Overview
  • Built-in Datatypes
  • Creating Tables
  • Modifying Tables
  • Managing Constraints
  • Summary
  • Exam Essentials
  • Review Questions
  • Overview
  • Creating and Modifying Views
  • Creating and Managing Sequences
  • Creating and Managing Synonyms
  • Creating and Managing Indexes
  • Summary
  • Exam Essentials
  • Review Questions
Exam FAQs
How many questions are asked in the exam? The exam contains 64 questions.
What is the duration of the exam? 120 minutes
Which certification covers this exam?
What are the career opportunities after passing this exam?
  • Application Developer
  • PL/SQL Developer
  • Database Administrator
  • Data Warehouse Administrator
×