Overview
Overview
In this course, Oracle database administrators (DBAs), organize and store data using Oracle’s database software solutions. Businesses and corporations rely on Oracle database administrators to manage their data securely and efficiently.
Job Profile Outcome
Job Profile Outcome
- Identify the major structural components of the Oracle Database 12c
- Create reports of aggregated data
- Write SELECT statements that include queries
- Retrieve row and column data from tables
- Run data manipulation statements (DML) in Oracle Database 12c
- Create tables to store data
- Utilize views to display data
- Control database access to specific objects
- Manage schema objects
- Display data from multiple tables using the ANSI SQL 99 JOIN syntax
- Manage objects with data dictionary views
- Write multiple-column sub-queries
- Employ SQL functions to retrieve customized data
- Use scalar and correlated sub-queries
- Create reports of sorted and restricted data
Course Features
- Duration 136 hours
- Activities Develop Career
- Day of week To be discussed
Curriculum
Curriculum
Curriculum
- 5 Sections
- 68 Lessons
- 10 Weeks
Expand all sectionsCollapse all sections
- SQL24
- 1.1Table Descriptions
- 1.2Using SQL Developer
- 1.3Using SQL Plus
- 1.4Introduction
- 1.5Retrieving Data Using the SQL SELECT Statement
- 1.6Restricting and Sorting Data
- 1.7Using Single-Row Functions to Customize Output
- 1.8Using Conversion Functions and Conditional Expressions
- 1.9Reporting Aggregated Data Using the Group Functions
- 1.10Displaying Data from Multiple Tables Using Joins
- 1.11Using Subqueries to Solve Queries
- 1.12Using the Set Operators
- 1.13Managing Tables Using DML Statements
- 1.14Introduction to Data Definition Language
- 1.15Introduction
- 1.16Introduction to Data Dictionary Views
- 1.17Creating Sequences, Synonyms, and Indexes
- 1.18Creating Views
- 1.19Managing Schema Objects
- 1.20Retrieving Data by Using Sub queries
- 1.21Manipulating Data by Using Sub queries
- 1.22Controlling User Access
- 1.23Manipulating Data
- 1.24Managing Data in Different Time Zones
- Administration Workshop Ed 221
- 2.1Introduction
- 2.2Exploring the Oracle Database Architecture
- 2.3Oracle Database Management Tools
- 2.4Managing the Database Instance
- 2.5Configuring the Oracle Network Environment
- 2.6Administering User Security
- 2.7Managing Database Storage Structures
- 2.8Managing Space
- 2.9Managing Undo Data
- 2.10Managing Data Concurrency
- 2.11Implementing Oracle Database Auditing
- 2.12Backup and Recovery Concepts
- 2.13Backup and Recovery: Configuration
- 2.14Performing Database Backups
- 2.15Performing Database Recovery
- 2.16Moving Data
- 2.17Performing Database Maintenance
- 2.18Managing Performance
- 2.19Managing Performance: SQL Tuning
- 2.20Using Resource Manager
- 2.21Using Oracle Scheduler
- Install and Upgrade Workshop11
- 3.1Oracle Database 12c: Overview
- 3.2Oracle Software Installation Basics
- 3.3Oracle Grid Infrastructure for a Standalone Server
- 3.4Installing Oracle Database Software
- 3.5Creating an Oracle Database by Using DBCA
- 3.6Oracle Restart
- 3.7Introduction to Upgrading to Oracle Database 12c
- 3.8Preparing to Upgrade to Oracle Database 12c
- 3.9Upgrading to Oracle Database 12c
- 3.10Performing Post-Upgrade Tasks
- 3.11Migrating Data by Using Oracle Data Pump
- Backup & Recovery12
- 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
- Final Project0
Reviews
Reviews