Oracle (Database Administration Track)

by Aptech Computer Training

This course covers 3 modules: 1) Introduction to SQL and PL/SQL 2) Administration Workshop I 3) Administration Workshop II

AED 5000

Contact the Institutes

Fill this form
Aptech Computer Training Logo

img Duration

3 Months

Course Details

This program covers 3 modules:


1) Introduction to SQL and PL/SQL

2) Administration Workshop I

3) Administration Workshop II


1. Introduction to SQL and PL/SQL


- Introduction

- Retrieving Data Using the SQL SELECT Statement

- Restricting and Sorting Data

- Using Single Row Functions to Customize Reports

- Reporting Aggregated Data Using the Group Functions

- Displaying Data From Multiple Tables

- Using Sub queries to Solve Queries

- Using the SET Operators

- Manipulating Data

- Using DDL Statements to Create and Manage Tables

- Creating Other Schema Objects

- Managing Objects with Data Dictionary Views

- Controlling User Access

- Generating Reports by Grouping Related Data

- Managing Data in Different Time Zones

- Searching Data Using Advanced Sub queries

- Hierarchical Data Retrieval

- Introduction to PL/SQL Objects

- Procedural Language

- PL/SQL Blocks, Anonymous Blocks and Named Blocks

- Creating PL/SQL Procedures and Functions

- Understanding Triggers

- Packages


2. Administration Workshop I


- Introduction

- Installing Oracle Database 10g Software

- Create an Oracle Database

- Database interfaces

- Controlling the database

- Storage Structures

- Administering users

- Managing Schema Objects

- Managing Data

- PL/SQL

- Oracle Database Security

- Oracle Net Services

- Oracle Shared Server

- Performance Monitoring

- Proactive Maintenance: Objectives Undo Management

- Monitoring and Resolving Lock Conflicts

- Backup and Recovery Concepts

- Database Backups

- Database Recovery


3. Administration Workshop II


- Using Globalization Support

- Securing the Oracle Listener

- Configuring Recovery Manager

- Using Recovery Manager

- Diagnostic Sources

- Recovering from non-critical losses

- Database Recovery

- Flashback database

- Recovering from User Errors

- Dealing with Database Corruption

- Automatic Database Management

- Monitoring and Managing Storage

- Automatic Storage Management

- Monitoring and Managing Memory

- Managing Resources

- Automating Tasks with the Scheduler

Aptech Computer Training is among the leaders in career education in the Dubai & Sharjah. The company focuses on career development for students and working professionals. In addition, Aptech Computer Training also offers various training services to large companies to help develop the skills of their employees.

Newly emerging trends and technologies like Artificial Intelligence (AI) cloud computing, mobile applications, Multimedia courses, Social media and Data analytics are bringing about increasing job opportunities in the IT & ICT industry.

Aptech Computer Training, through its courses and curriculum, ensures that you are at par with global standards. We provide KHDA Attested Certificates.

  • Bur Dubai Branch

    Aptech Computer Education Institute, Mankhool Road, Al Tawhidi Bldg II, 7th Floor, Bur Dubai, Dubai
  • Al Majaz Branch

    Aptech Computer Training Institute, King Faisal Street, Al Majaz, Sharjah

2 Reviews

  • 0

    (Institute Review)

    55 years ago

    0
  • (Institute Review)

    55 years ago

Submit Your Course Review (For Enrolled Students Only)

This form is for submitting course reviews only. If you have questions about the course, please use the Ask Us? form.

Check out more Oracle courses in UAE

Syscoms Institute Logo

MY SQL With PHP

MY SQL With PHP Training Program Offered By Syscoms Institute.

by Syscoms Institute
  • Price
  • Start Date
  • Duration
Elite Stars Easy Learn Institute Logo

MySQL Training

This training will teach you to develop a database for enterprise after acquiring a comprehensive understanding of structured query language (SQL).

by Elite Stars Easy Learn Institute
  • Price
  • Start Date
  • Duration
Syscoms Institute Logo

SQL Server / Admin

SQL Server / Admin Training Program Offered By Syscoms Institute.

by Syscoms Institute
  • Price
  • Start Date
  • Duration
Macob IT Solution Logo

Virtualization Architect (IT Training Bundle)

This training bundle will give you understanding and knowledge of Virtualization technology that includes virtual representations of things like storage, servers, virtual application and networks.

by Macob IT Solution
  • Price
  • Start Date
  • Duration
Zabeel International Institute of Management and Technology Logo

Oracle 12c SQL (Level 1 + 2)

Oracle 12c SQL course is offered by Zabeel Institute covering all the essential knowledge and skills related to Oracle 12c SQL (Level 1 + 2) certification covering both Level 1 & 2.

by Zabeel International Institute of Management and TechnologyZabeel International Institute of Management and Technology verified
  • Price
  • Start Date
  • Duration

© 2025 www.coursetakers.ae All Rights Reserved. Terms and Conditions of use | Privacy Policy