• 0Shopping Cart
World IT Center
  • Home
  • Services
    • IT Consulting Services
      • Data Warehousing
      • Web Development
      • Enterprise Resource Planning
      • Management Services
      • Onsite-Offshore Dev Model
      • IT Project Management
      • Management Consulting
      • Network & Systems Expertise
      • Web Expertise
      • Database Expertise
      • Bio Metrics & Artificial Intelligence
      • Quality Assurance
      • Internet of Things (IoT)
      • Training
    • Staffing
      • Staffing Overview
      • Our Search & Placement Process
      • IT Employees Search & Placement
      • Our Staffing Professionals
      • Placement Guaranteed by our Staff
      • Our Staffs Proven Results
      • H-1B Sponsorship
    • 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
    • Application Services
    • Business Strategy
    • Data Analytics
    • Infrastructure
    • Technology Innovation
    • Automation
    • Cloud Services
    • Application Development Services
    • Application Maintenance
    • Customer Software Development
    • System Integration
  • Study Abroad
  • Software
    • Bundles
      • Bundle #1 Power Suite
      • Bundle #2 DLX Suite
      • Bundle #3 Bonus Suite
      • Bundle #4 Performance Suite
      • Bundle #5 Privacy Suite
    • Microsoft
      • Microsoft Office
      • Microsoft Windows
    • Norton
      • Norton Europe
      • Norton Latin America
      • Norton USA
    • Acronis
    • AdAware
    • Avast
    • AVG
    • Bitdefender
    • Bull Guard
    • ESET
    • F-Secure Antivirus
    • F-Secure Internet
    • G Data
    • Heimdal
    • HitmanPro
    • IOLO
    • iS3
    • Kaspersky
    • MalwareBytes
    • McAfee
    • Nero Platinum
    • Panda
    • Trend Micro
    • Trustport
    • Vipre
    • Watchdog Development
    • Webroot
    • Zemana
    • Avast HMA
    • Boost
    • CCleaner
    • FAQ
      • Download Links
      • Activation Video
  • Online Training
    • Courses
      • Adobe
      • Microsoft
      • CompTIA
      • Project Management
      • Security
      • Cisco
      • Web Development
      • Programming
      • Cloud Services & Virtualization
      • Databases
      • CyberSecurity
      • Accounting
      • Social Media and Marketing
    • Bundles Courses
    • All Courses Page Details
  • Consumer Electronics
  • Apply Jobs
  • Login
  • Search
  • Menu Menu
331-8962ea.jpeg

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

$99.00

99 in stock

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 Administration

  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

67 S Bedford St,400 W
Burlington, MA 01803
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