• 0Shopping Cart
World IT Center
  • Apply Jobs
  • Study Abroad
  • Services
    • Consulting Services
      • Data Warehousing
      • Web Development
      • Onsite-Offshore Dev Model
      • IT Project Management
      • Enterprise Resource Planning
      • Quality Assurance
      • Management Services
      • Training
      • Internet of Things (IoT)
      • Bio Metrics & Artificial Intelligence
      • Database Expertise
      • Web Expertise
      • Network & Systems Expertise
      • Management Consulting
    • Staffing
      • Staffing Overview
      • Our Search & Placement Process
      • IT Employees Search & Placement
      • Our Staffing Professionals
      • Placement Guaranteed by our Staff
      • Our Staffs Proven Results
    • Our Solutions
      • 24×7 IT Support Solution
      • Cloud Computing Solutions
      • ECommerce Solutions
      • BI & Reporting Solution
      • Data & Architectural solutions
      • IT Project Solutions
    • Cyber Security
      • Identity Access Management
      • Identity Governance and Administration
      • Data Loss prevention
      • Security Risk Management
      • Identity Administration
  • Online Training
    • Courses
      • Adobe
      • Microsoft
      • CompTIA
      • Project Management
      • Security
      • Cisco
      • Web Development
      • Project Management
      • Programming
      • Cloud Services & Virtualization
      • Databases
      • CyberSecurity
      • Accounting
      • Social Media and Marketing
    • Bundles Courses
    • All Course Access
  • Software
  • Consumer Electronics
  • Login
  • Search
  • Menu Menu

Oracle Database 11g Certified Associate (OCA) (Fundamentals 1Z0-051 and Admin 1z0-052)

$99.00

EAN: N/A SKU: 753569049910 Categories: Courses, Databases Tags: Delete Table, Insert Table, OCA, Oracle Database 11g Certified Associate, Oracle Database 11g Certified Associate (OCA) (Fundamentals 1Z0-051 and Admin 1z0-052), Update Table
  • Description

This course is in preparation for the The Oracle Database 11g Administrator (OCA 11g) certification exam. 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 how to 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!

 

Module 1: Database Admininstration

  1. Intro to Oracle
  2. Database Administration
  3. Installing Oracle – Part 1
  4. Installing Oracle – Part 2
  5. Post Setup Overview – Part 1
  6. Post Setup Overview – Part 2
  7. SQLplus – Part 1
  8. SQLplus – Part 2
  9. SQLplus Demo – Part 1
  10. SQLplus Demo – Part 2
  11. SQLplus Demo – Part 3
  12. Startup and Shutdown – Part 1
  13. Startup and Shutdown – Part 2

Module 2: Oracle Architecture

  1. Oracle Architecture
  2. Schema Objects
  3. Data Access
  4. Architecture

Module 3: Database Schema

  1. Database Schema
  2. Create Table & Tablespace – Part 1
  3. Create Table & Tablespace – Part 2
  4. Create View
  5. Create Index
  6. Create Sequence

Module 4: Recovery Manager

  1. Recovery Manager
  2. What is RMAN
  3. RMAN Demo
  4. Restore – Part 1
  5. Restore – Part 2

Module 5: Introduction to SQL

  1. SQL – Part 1
  2. SQL – Part 2
  3. Parts of SQL Statement
  4. Select Statement

Module 6: Filtering and Sorting Data

  1. Build ERD – Part 1
  2. Build ERD – Part 2
  3. Build ERD – Part 3

Module 7: Functions

  1. Functions
  2. More Functions
  3. Group Functions
  4. Custom Functions

Module 8: SET Operators and Subqueries

  1. SET Operations
  2. Subqueries

Module 9: Regular Expressions and SQL Loader

  1. Regular Expressions
  2. SQL Loader

WorldITCenter

WorldITCenter expertise to optimize performance in every aspect of your organization. To succeed in today’s environment, businesses need to lead through increased complexity and volatility.

Quick Links

  • Online Training/Courses
  • Buy Softwares
  • Get Consultation

Find Us

3 Timeberhill Terr
Lynnfield, MA 01940
USA

Terms And Conditions

  • Terms of Use
  • Privacy Policy
  • Refunding Policy
  • Rescheduling Policy
  • Free Demo Trail
  • Payment Provider

These are my Office Hours

Mo-Fr: 8:00-19:00
Sa: 8:00-14:00
So: closed

2015-20 © Copyright - World IT Center
  • Facebook
  • LinkedIn
  • Youtube
Certified cloud security professionals Microsoft 70-465: Designing Database Solution for Microsoft SQL server2012
Scroll to top
  • USD $
    USA dollar
  • EUR €
    European Euro