جمعه 15 آذر 1398

مشخصات دوره

  • عنوان دوره : Oracle Database 11g Administration Workshop I
  • مدت زمان دوره : 40 ساعت (5 جلسه 8 ساعته)
  • زبان دوره : فارسی و انگلیسی

(ourse Duration: 5 Days (40 hours

Prerequisite: Oracle Database 12c Program with PLSQL

?What will you learn

SQL course introduces students to the fundamentals of SQL using Oracle Database 11g database technology. In this course students learn the concepts of relational databases and the powerful SQL programming language beside many Oracle SQL features that you cannot find in any other Database.PL/SQL part of this course introduces students to PL/SQL and explains the benefits of this powerful programming language. Students learn to create PL/SQL blocks of application code that can be shared by multiple forms, reports, and data management applications. Students also learn to create anonymous PL/SQL blocks and are introduced to stored procedures and functions. Students learn about declaring identifiers and trapping exceptions. Students use Oracle SQL Developer to develop, execute and manage PL/SQL stored program units such as procedures, functions, packages, and database triggers. Students also learn to manage, PL/SQL subprograms and triggers. Students are introduced to the utilization of some of the Oracle-supplied packages. the fundamental concepts. Students use Oracle SQL Developer to develop these program units. SQL*Plus and JDeveloper are introduced as optional tools.

Course outline:

    • Exploring the Oracle Database Architecture
    • Preparing the Database Environment
    • Creating an Oracle Database
    • Managing the Oracle Instance
    • Configuring the Oracle Network Environment
    • Managing Database Storage Structures
    • Administering User Security
    • Managing Schema Objects
    • Managing Data and Concurrency
    • Managing Undo Data
    • Implementing Oracle Database Security
    • Database Maintenance
    • Performance Management
    • Backup and Recovery Concepts
    • Performing Database Backups
    • Performing Database Recovery
    • Moving Data
    • Enhancing Database Capabilities