Oracle database 11G OCA 1Z0-051 and 1Z0-052: Installation and Administration


Oracle database 11G OCA 1Z0-051 and 1Z0-052: Installation and Administration, Singapore elarning online course

Course Description

The Oracle Database 11g Administrator Certification (OCA 11g) ensures that database professionals have a strong foundation and expertise in the industry's most advanced database management system, Oracle 11g. Oracle 11g 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 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 databases are the one of the most popular database platforms in the world. Increase your skills and marketability today by achieving Oracle certification!

Ace your certification examination with this preparation course!

- Learn of the examination outline before sitting for your certification
- Know and understand the topics that may be covered in your examinations
- Understand the theory aspects of the examination


Course Objectives

  1. Database Admininstration
  2. Oracle Architecture
  3. Database Schema
  4. Recovery Manager
  5. Introduction to SQL
  6. Filtering and Sorting Data
  7. Functions
  8. SET Operators and Subqueries
  9. Regular Expressions and SQL Loader


Related Courses

  • Citrix CXA-206: XenApp 7.5 Design, Implement and Administer

    Citrix CXA-206: XenApp 7.5 Design, Implement and Administer

    SGD $299.00

    Course Description

    Citrix XenApp 6.5 Administration training course provides the foundation necessary for administrators to effectively centralize and manage applications in the datacenter and instantly deliver them as a service to users anywhere. Learners will receive training for installing and configuring Citrix XenApp 6.5, Citrix Receiver and plug-ins, as well as for using administrative consoles and tools to configure resources, policies, server and farm settings, printers, virtualized applications and more.  Ace your certification examination with this preparation course! - Learn of the examination outline before sitting for your certification  - Know and understand the topics that may be covered in your examinations - Understand theory aspects of the examination

    Read more...

  • Certification at Your Fingertips - Microsoft 70 -642 TS: Windows Server 2008 Network Infrastructure, Configuring

    Certification at Your Fingertips - Microsoft 70 -642 TS: Windows Server 2008 Network Infrastructure, Configuring

    SGD $589.00

    Course Description

    Practice Lab  This course comes with a Remote Practice Environment, a virtual remote environment; where you are able to practically apply the skills you have learned on the respective server, systems and networks. With this platform, get one step ahead in your preparation for your certification exams! Whether it’s Cisco, Microsoft or VMware, our Practice Lab unifies access to all of these vendors through a web browser interface. Pre-configured hardware layouts with accompanying lab guides for fast, convenient access to gain hands on experience. With step-by-step instructions covering thousands of practical tasks across Cisco, Microsoft, VMware and CompTIA exam titles, the Practice Lab makes studying for an exam or learning new technologies an engaging experience. What this course prepares you for: This course prepares students for the 70-642: Windows Server 2008 Network Infrastructure, Configuring exam. This course provides students with the knowledge and skills to configure and troubleshoot Windows Server 2008 and Windows Server 2008 R2 Sp1 Network Infrastructures. This course will cover networking technologies most commonly used with Windows Server 2008 and Windows Server 2008 R2 Sp1, such as DNS, DHCP, IPv4 and IPv6 network addressing, Network Policy server, Network Access Protection, and configuring secure network access. It also covers fault tolerant storage technologies, Network Storage, routing and remote access, monitoring and compliance updates, as well as other relevant technologies. Ace your certification examination with this preparation course! - Learn of the examination outline before sitting for your certification  - Know and understand the topics that may be covered in your examinations - Understand both practical and theory aspects of the examination - Apply the practical skills through the Remote Practice Environment

    Read more...

  • Certification at Your Fingertips - Microsoft 70-337: MCSE: Communication - Lync Server

    Certification at Your Fingertips - Microsoft 70-337: MCSE: Communication - Lync Server

    SGD $299.00

    Course Description

    Candidates for this exam are IT consultants and telecommunications consulting professionals who design, plan, deploy, and maintain solutions for unified communications (UC). Candidates should be able to translate business requirements into technical architecture and design for a UC solution. Candidates should have a minimum of two years of experience with Microsoft Lync technologies and be familiar with supported migration scenarios. Candidates should be proficient in deploying Lync Server 2013 solutions for end users, endpoint devices, telephony, audio/video and web conferences, security, and high availability. Candidates should also know how to monitor and troubleshoot Lync Server 2013 using Microsoft tools. In addition, candidates should be proficient with Active Directory Domain Services, data networks, and telecommunications standards and components that support the configuration of Lync Server 2013. Candidates should be familiar with the requirements for integrating Lync Server 2013 with Microsoft Exchange Server and Office 365. This course is a core requirement for the MCSE certification. Ace your certification examination with this preparation course! - Learn of the examination outline before sitting for your certification  - Know and understand the topics that may be covered in your examinations - Understand theory aspects of the examination

    Read more...


Content

Oracle database 11G OCA 1Z0-051 and 1Z0-052: Installation and Administration

+
Content
  • Module 1: Database Admininstration
    • 1.0 Intro to Oracle
    • 1.1 Database Administration
    • 1.2 Installing Oracle Part 1
    • 1.3 Installing Oracle Part 2
    • 1.4 Post Setup Overview Part 1
    • 1.5 Post Setup Overview Part 2
    • 1.6 SQLplus Part 1
    • 1.7 SQLplus Part 2
    • 1.8 SQLplus Demo part 1
    • 1.9 SQLplus Demo part 2
    • 1.10 SQLplus Demo part 3
    • 1.11 Startup and Shutdown part 1
    • 1.12 Startup and Shutdown part 2
  • Module 2: Oracle Architecture
    • 2.0 Oracle Architecture
    • 2.1 Schema Objects
    • 2.2 Data Access
    • 2.3 Architecture
  • Module 3: Database Schema
    • 3.0 Database Schema
    • 3.1 Create Table & Tablespace part 1
    • 3.2 Create Table & Tablespace part 2
    • 3.3 Create View
    • 3.4 Create Index
    • 3.5 Create Sequence
  • Module 4: Recovery Manager
    • 4.0 Recovery Manager
    • 4.1 What is RMAN
    • 4.2 RMAN Demo
    • 4.3 Restore Part 1
    • 4.4 Restore Part 2
  • Module 5: Introduction to SQL
    • 5.0 SQL part 1
    • 5.1 SQL part 2
    • 5.2 Parts of SQL Statement
    • 5.3 Select Statement
  • Module 6: Filtering and Sorting Data
    • 6.0 Build ERD part 1
    • 6.1 Build ERD part 2
    • 6.2 Build ERD part 3
  • Module 7: Functions
    • 7.0 Functions
    • 7.1 More Functions
    • 7.2 Group Functions
    • 7.3 Custom Functions
  • Module 8: SET Operators and Subqueries
    • 8.0 SET Operations
    • 8.1 Subqueries
  • Module 9: Regular Expressions and SQL Loader
    • 9.0 Regular Expressions
    • 9.1 SQL Loader
SGD $299.00
(Price excludes GST)
GET ACCESS NOW
Convince your boss email
This site is best viewed using the latest versions of Google Chrome, Apple Safari, Mozilla FireFox, Microsoft Internet Explorer 11 and Edge which supports HTML5/Webkit technologies.