ORACLE (Database Administration Track) Jurassic Institute of Management and Technology
السعر: 4,000 درهم
5,969 درهم
تدريب إفتراضي أونلاين. المحاضرات قد تكون فردية أو ضمن مجموعة.
  • الفروع الأُخرى: المجاز - الشارقة
  • مدة الدورة التدريبية: 3 months
  • مواعيد الدورة: Flexible options

تفاصيل الدورة

Ministry Approved Certificate

Course Overview

(PL/SQL, Workshop I & Workshop II)
Oracle 10g- Introduction to SQL and PL/SQL
Course Contents:

  • 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


Oracle 10g-Administration Workshop I
Course Contents:

  • 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


Oracle 10g-Administration Workshop II
Course Contents:

  • 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
تحديث بتاريخ 07 June, 2023

نبذة عن معهد Jurassic Institute of Management and Technology

Jurassic Institute of Management and Technology is a Learning Solutions Company playing a key role in helping individuals, organizations and nations adapt to the changing requirements of a knowledge-driven world. Jurassic commenced its IT and NON IT Education & Training business in 1993 in UAE. Jurassic is the franchisees of the brand Aptech Computer Education, Arena Multimedia and English Express in UAE. Aptech Computer Education, a division of Aptech Limited has over 3,256 training centers in 56 countries. Arena Multimedia - Global Multimedia Education, leading the way in Multimedia Training has trained  over 4,00,000 students.

عرض الجميع دورات Jurassic Institute of Management and Technology
دورات يمكنك الالتحاق بها على الفور... خذ دورة عبر الإنترنت على IT, Computing and Technology ابتداءً من الآن. See all courses

هل هذه الدورة التدريبية الاختيار المناسب لك؟

قيِم هذه الصفحة

لم تجد ما كنت تبحث عنه؟

أو