• sales@4levels.co.za
  • +27 11 848 6229
  • 53/54, 14th Road, Noordwyk, Midrand, South Africa 1687

Oracle

Oracle

4levels-IT-Default-Header

4levels-Solutions-DB-Header

A Database Administrator (DBA) is an IT professional responsible for the installation, configuration, upgrading, administration, monitoring, maintenance, and security of databases in an organization.

A Database Administrator uses software to store and organize data. They ensure that data is available to users who have authorized access in order to find the information and that systems perform as they should. The purpose of this qualification is to equip learners with the skills to develop and create the database as well as administer security access to the system.

  • What is Oracle SQL?
  • The Select Statement
  • Select statement – Restricting and Sorting data
  • Oracle SQL Functions
  • PL/SQL Basics
  • Displaying data from multiples tables (JOIN)
  • Using subqueries
  • Creating indexes, Views, Synonyms and Sequences
  • Using DDL (Data Definition Language)
  • Using DML (Data Manipulation Language)
  • Basic Oracle user security
  • Oracle Data Dictionary
  • Oracle Database Architecture
  • Installing Oracle Database on Linux
  • Managing the Oracle Database instance
  • Oracle Database Network environment
  • Oracle Database Storage structures
  • Undo and Data concurrency
  • Oracle Database users , profiles and roles
  • Database Management and performance
  • Oracle Database Backup and recovery
  • Moving Data with Oracle data pump
  • Automatic Storage Management

For roadmaps, advice regarding course schedules and course fees, contact 4levels Solutions: Contact Us

Code Course Description Duration Action
User Dashboard Client Zone