- +92-51-4864925-26
- info@sina.edu.pk
- 693, Rehman Baba Road, Sector I-8/4, Islamabad.
Introduction to ORACLE-DBM Course
An Oracle database is a collection of data that is handled as a single entity. A database’s function is to store and retrieve relevant information. A database server is essential for resolving information management issues. In general, a server consistently handles a huge volume of data in a multiuser environment, allowing several users to access the same data at the same time. All of this is done while maintaining great performance. A database server also prevents unwanted access and provides effective failure recovery options.
Curriculum
- 4 Sections
- 70 Lessons
- 10 Weeks
Expand all sectionsCollapse all sections
- Oracle Database 12c: SQL Workshop I10
- 2.1Introduction
- 2.2Retrieving Data using the SQL SELECT Statement
- 2.3Restricting and Sorting Data Using Single-Row Functions to Customize Output
- 2.4Using Conversion Functions and Conditional Expressions
- 2.5Reporting Aggregated Data Using the Group Functions
- 2.6Displaying Data From Multiple Tables Using Joins
- 2.7Using Sub-queries to Solve Queries
- 2.8Using the SET Operators
- 2.9Managing Tables using DML statements in Oracle
- 2.10Introduction to Data Definition Language in Oracle
- Oracle Database 12c: Administration Workshop 120
- 3.1Introduction
- 3.2Exploring Oracle Database Architecture
- 3.3Managing Database Instances
- 3.4Creating PDBs
- 3.5Configuring the Oracle Network Environment
- 3.6Administering User Security
- 3.7Creating and Managing Tablespaces
- 3.8Managing Storage Space
- 3.9Managing UNDO Data
- 3.10Moving Data
- 3.11Backup and Recovery Concepts
- 3.12Monitoring and Tuning Database Performance
- 3.13SQL Tuning
- 3.14Oracle Database Resource Manager
- 3.15Enterprise Manager Cloud Control
- 3.16Introduction to Oracle Database Cloud Service
- 3.17Creating DBCS Database Deployments
- 3.18Managing DBCS Database Deployments
- 3.19Backing Up and Restoring DBCS Database Deployments
- 3.20Tablespace Encryption by Default
- Oracle Database 12c: Backup and Recovery Workshop Admin 221
- 4.1Introduction
- 4.2Getting Started
- 4.3Configuring for Recoverability
- 4.4Using the RMAN Recovery Catalog
- 4.5Backup Strategies and Terminology
- 4.6Performing Backups
- 4.7Improving Your Backups
- 4.8Using RMAN-Encrypted Backups
- 4.9Diagnosing Failures
- 4.10Restore and Recovery Concepts
- 4.11Performing Recovery, Part I
- 4.12Performing Recovery, Part II
- 4.13RMAN and Oracle Secure Backup
- 4.14Using Flashback Technologies
- 4.15Using Flashback Database
- 4.16Transporting Data
- 4.17Performing Point-in-Time Recovery
- 4.18Duplicating a Database
- 4.19RMAN Troubleshooting and Tuning
- 4.20Cloud Tooling for Backup and Recovery
- 4.21Backup and Recovery Workshop
- Oracle Database 12c:19
- 5.1Admin, Install and Upgrade
- 5.2Accelerated Administration
- 5.3Workshop Backup and Recovery
- 5.4Workshop Data Guard Administration
- 5.5RAC and Data Guard Integration Workshop
- 5.6High Availability
- 5.7New Features
- 5.8Install and Upgrade Workshop
- 5.9Managing Multitenant Architecture
- 5.10New Features for Administrators
- 5.11Performance Management and Tuning SQL
- 5.12Tuning for Developers
- 5.13Clusterware Administration RAC
- 5.14Administration Security
- 5.15Fundamentals for Oracle
- 5.16Administration Workshop
- 5.17Clusterware & RAC Admin Accelerated ASM
- 5.18Administration Exadata Database
- 5.19Machine Administration Workshop