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
