- +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
Instructor
You May Like
MCSE SharePoint Administration Training
IntroductionMCSE SharePoint Administration Training MCSE SharePoint Administration Training is offered at the SINA Institute of Networks and Aesthetics. In this MCSE Share Point Administration...
198
1
student
Free
Power Electronics Course
Introduction of Power Electronics Power Electronics Course, Power electronics is the application of solid-state electronics to the control and conversion of electric power....
127
0
student
Free
Arduino Course
Introduction of Arduino Course Arduino Course platform has become quite popular with people just starting out with electronics, SINA recognized among the top Arduino...
66
0
student
Free
Free
Course Features
- Lectures 70
- Quizzes 0
- Duration 10 weeks
- Skill level All levels
- Language English
- Students 0
- Assessments Yes
