- الفروع الأُخرى: الشارقة أبوظبي الفجيرة - الإمارات العربية المتحدة
- مدة الدورة التدريبية: 2 Months
تفاصيل الدورة
ORACLE DBAMINISTRY APPROVED INSTITUTE
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 تحديث بتاريخ 25 November, 2019
الموقع
Oracle أسئلة ذات صلة
- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at Laimoon1,449 درهممدة الدورة التدريبية: Upto 30 Hours
- Oracle PL/SQL 11g Course Gate47 درهم
555 درهممدة الدورة التدريبية: Upto 9 Hours - Oracle 12c OCP 120-061: SQL Fundamentals Study 365185 درهممدة الدورة التدريبية: Upto 16 Hours