Rated 4.00 out of 5 based on 2 customer ratings
(2 customer reviews)

Welcome to Logo Design fundamentals of building a great brand Logo. Our course teacher Lauren, walks you through his process of logo design. Logo design fundamentals is a great course. Peter describes logo design from start to finish using all the elements of creating and building a great logo.

SKU: 001 Categories: , , ,

COURSE DESCRIPTION

Oracle Database Administration Course explains about the basic concepts of Relational Database Management Systems (RDBMS). It will help you to become an Oracle Database Administrator(Oracle DBA). Database Administrator is one of the highly sought after jobs in the IT industry. It is also one of the highly stable jobs as DATA is a vital part of every organization and they need that to be in the capable hands of a good DBA team. This course applicable for those who would want to learn Oracle Database 12c as well as Oracle Database 11g.

The course has been structured to start with videos explaining basic database concepts. They provide simplified real world examples. It then explains about various Oracle Internals such as Storage Structures, Memory Structures, Database Objects etc. Then it goes into operational aspects such as creating USERS, granting access, creating objects such as tables etc. After that it explains about Backup/Recovery concepts and Diagnostic Data.

 

Oracle Database 11g: Administration I -Syllabus

Getting Organized with Layers
Architectural Overview of Oracle Database 11g

  • Oracle Product Stack
  • Prerequisite Concepts
  • Single-Instance Architecture
  • Instance Memory Structures
  • Instance Process Structures
  • Database Storage StructuresInstalling and Creating a Database
  • Identify the Tools for Administering an Oracle Database
  • Plan an Oracle Database Installation
  • Install the Oracle Software by Using the Oracle Universal Installer (OUI)
  • Create a Database by Using the Database Configuration AssistantInstance Management
  • Set Database Initialization Parameters
  • Describe the Stages of Database Startup and Shutdown
  • Use the Alert Log and Trace Files
  • Use Data Dictionary and Dynamic Performance ViewsOracle Networking
  • Configure and Manage the Oracle Network
  • Use the Oracle Shared Server ArchitectureOracle Storage
  • Overview of Tablespaces and Datafiles
  • Create and Manage Tablespaces
  • Space Management in TablespacesOracle Security
  • Create and Manage Database User Accounts
  • Grant and Revoke Privileges
  • Create and Manage Roles
  • Create and Manage Profiles
  • Database Security and Principle of Least Privilege
  • Work with Standard Database AuditingDatabase 11g: Administration II 

    Configuring the Database for Backup and Recovery

  • Backup and Recovery Issues
  • Categories of Failures
  • Instance Recovery
  • Preparing the Database for Recoverability
  • The Flash Recovery AreaBack Up with RMAN
  • Backup Concepts and Terminology
  • Using the RMAN BACKUP Command to Create Backups
  • Configuring RMAN Defaults
  • Managing and Monitoring RMAN BackupsRestore and Recover with RMAN
  • The Data Recovery Advisor
  • Database Restore and RecoveryComplete Recovery from Data File Loss Using RMAN
  • Incomplete Recovery
  • Autobackup and Restore of the Controlfile
  • Using Image Copies for Recovery
  • Block RecoveryAdvanced RMAN Facilities
  • The Recovery Catalog
  • Stored Scripts
  • Using RMAN to Create Databases
  • Tablespace Point-in-Time Recovery (TSPITR)
  • RMAN Performance and MonitoringUser-Managed Backup, Restore, and Recovery
  • Backup and Recovery in One Page
  • User-Managed Database Backup
  • Backup of the Password and Parameter Files
  • Media Failure That Does Not Affect Datafiles
  • Recovery from Loss of Datafiles
  • User-Managed Incomplete RecoveryFlashback
  • The Different Flashback Technologies
  • Flashback Database
  • Flashback Drop
  • Flashback Query
  • The Flashback Data ArchiveAutomatic Storage Management
  • The Purpose of a Logical Volume Manager
  • The ASM Architecture
  • Creating Raw Devices
  • Creating, Starting, and Stopping an ASM Instance
  • Creating ASM Disk Groups
  • Creating and Using ASM Files
  • ASM and RMAN
  • The ASMCMD UtilityThe Resource Manager
  • The Need for Resource Management
  • The Resource Manager Architecture
  • Managing Users and Consumer Groups
  • Resource Manager Plans
  • Automatic Consumer Group Switching
  • Adaptive Consumer Group MappingThe Scheduler
  • The Scheduler Architecture
  • Scheduler Objects
  • Creating and Scheduling Jobs
  • Using Classes, Windows, and the Resource ManagerMoving and Reorganizing Data
  • SQL*Loader
  • External Tables
  • Data Pump
  • Using Data Pump Export and Import
  • Resumable Space Allocation
  • Segment ReorganizationThe AWR and the Alert System
  • The Automatic Workload Repository
  • The Database Advisory Framework
  • Using the Server-Generated Alert SystemPerformance Tuning
  • Managing Memory
  • The SQL Tuning Advisor
  • The SQL Access Advisor
  • Identifying and Fixing Invalid and Unusable Objects
  • Database ReplayGlobalization
  • Globalization Requirements and Capabilities
  • Using Globalization Support Features
  • Languages and Time Zones

Add a review