Notice : You are now accessing LOOP SIT SERVER. This is not meant for public access. For the actual LOOP Website please visit www.LOOP.sg instead


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

  • Certified Scrum Master (CSM)

    Certified Scrum Master (CSM)

    SGD $299.00

    Course Description

    A Certified Scrum Master helps project teams properly use Scrum, increasing the likelihood of the project's overall success. CSMs understand Scrum values, practices, and applications and provide a level of knowledge and expertise above and beyond that of typical project managers. CSMs act as "servant leaders," helping the rest of the Scrum team work together and learn the Scrum framework.  Discover the new way of project management with SCRUM! - Learn about the benefits of applying SCRUM into your projects - Benefit from its unique iteration process for better productivity  - Understand the differences SCRUM and Agile  - Be one of the succesful organization to apply SCRUM into your organization

    Read more...

  • 1st step to certification: Microsoft SharePoint 2010 (70-667)

    1st step to certification: Microsoft SharePoint 2010 (70-667)

    SGD $45.00

    Course Description

    Microsoft's SharePoint Server product has done what few products can do in recent years---attract millions of new users year after year. You will find SharePoint Server being used in some manner in most organizations. The newest release, SharePoint 2010, pushes the ante even higher. Achieving certification on the latest SharePoint platform could be a key component in expanding your career. In this course, Mark Long helps you prepare for the Microsoft Certification exam 70-667 that deals with SharePoint 2010 Configuration. Be fully prepared for your certifications exams!- Learn of the examination outline before sitting for your certification - Know and understand the topics that may be covered in your examinations- Learn and understand the chapters for each tailored certification - Go through past questions to have a feel of the examinationsThis course is SkillsFuture Credit Eligible.

    Read more...

  • Certification at Your Fingertips - Microsoft 70-413: Designing and Implementing a Server Infrastructure

    Certification at Your Fingertips - Microsoft 70-413: Designing and Implementing a Server Infrastructure

    SGD $299.00

    Course Description

    This course covers the following topics in order to prepare students for the Microsoft 70-413: Designing and Implementing a Server Infrastructure exam: how to plan and deploy a server infrastructure, design and implement network infrastructure services, design and implement network access services, design and implement an Active Directory infrastructure (logical), and design and implement an Active Directory infrastructure (physical). Be fully prepared for your certifications exams! - Learn of the examination outline before sitting for your certification  - Know and understand the topics that may be covered in your examinations - Learn and understand the chapters for each tailored certification  - Go through past questions to have a feel of the examinations

    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.