Oracle 11g OCA and Oracle Database SQL Expert Online Training CourseCareerVision Training
£ 150 - (178 €)
Cosa impari in questo corso?
• Instructor Led Video Training -12 Month Online Subscription
• Demos and Lab Learning
• Multimedia Presentations and Self-Paced Navigation
• Practice Exam and Test Simulator
COURSE DESCRIPTION The Oracle Database 11g Administrator Certification (OCA 11g) Course ensures that database professionals have a strong foundation and expertise in the industry’s most advanced database management system, Oracle 11g.
Our 11g OCA training package covers includes the following exam courses needed for certification:
* 1Z0-047: Oracle Database SQL Expert
* 1Z0-052: Oracle Database 11g: Administration I
This training course will teach students how to install and maintain an Oracle database, how to create an operational database and properly manage the various structures in an effective and efficient manner including performance monitoring, database security, user management, and backup/recovery techniques. Students will also learn skills required for working with SQL, including how to use the advanced features of SQL in order to query and manipulate data within the database, control privileges at the object and system level, and use advanced querying and reporting techniques. After completing the Oracle OCA 11g course, students will gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another.
Oracle DBA's manage the industry's most advanced information systems and command some of the highest salaries. By earning your Oracle Certification, you will be one step closer to gaining access to better career opportunities. We are so certain this OCA 11g training course meets and exceeds the exam objectives, we guarantee you will pass your exam!
COURSE OUTLINE Oracle OCA Exam 1Z0-052
Architectural Components of the Oracle Database
Server Processes and Background Processes
Logical and Physical Storage Structures
Installing the Oracle Software
Creating an Oracle Database
The Oracle Instance
Oracle Network Environment
Database Storage Structures
Data and Concurrency
Backup and Recovery
Oracle Database/ SQL Expert: Exam 1Z0-047
Introduction to Oracle SQL
Where and Order By Clauses
Single Row Functions