Oracle

CIS 424 Database administration I

(STY-CIS424.AE1)
Lessons
Lab
TestPrep
AI Tutor (Add-on)
Get A Free Trial

Skills You’ll Get

Download Course Outline

1

Introducing Oracle Database 12c Components and Architecture

  • Oracle Database Fundamentals
  • Oracle Database 12c Architecture
  • Oracle Data Integrator Repositories
  • Summary
2

Creating and Operating Oracle Database 12c

  • Oracle Database 12c Software Installation
  • Using DBCA to Create an Oracle 12c Database
  • Working with Oracle Database Metadata
  • Managing Users and Groups
  • Summary
3

Modifying and Managing Database Parameters

  • Modifying and Managing Initialization-Parameter Files
  • Starting Up and Shutting Down an Oracle Instance
  • Monitoring the Database Alert Log
  • Summary
4

Understanding Storage and Space Management

  • Understanding the Physical and Logical Storage
  • Managing Tablespaces
  • Managing Data Files
  • Managing Space
  • Summary
5

Managing Data Concurrency and Undo

  • Managing Data Changes Using DML
  • Managing Data Concurrency
  • Summary
6

Understanding Oracle Network Architecture

  • Introducing Network Configurations
  • An Overview of Oracle Net Features
  • Configuring Oracle Net on the Server
  • Configuring Oracle Net for the Client
  • Summary
7

Understanding Database Connections and Database Links

  • An Overview of Oracle Shared Server
  • Understanding Database Resident Connection Pooling
  • Communicating Between Databases
  • Summary
8

Implementing Security and Auditing

  • Creating and Managing User Accounts
  • Privileges and Working with Triggers
  • Summary
9

Creating and Dropping Database Objects

  • Creating and Dropping Database Objects
  • Summary
10

Creating a Profile

  • Controlling Resource Usage by Users
  • Auditing Database Activity
  • Summary

1

Introducing Oracle Database 12c Components and Architecture

  • Displaying the Connection Name
  • Displaying Information About the Active Services in the Database
  • Unlocking the Pluggable Database
  • Altering the Session of the Database Container and the Pluggable Database
  • Unlocking and Connecting to the User Account
  • Understanding SGA
  • Creating a Cluster
  • Creating a Cluster Index
  • Removing a Cluster
2

Creating and Operating Oracle Database 12c

  • Creating a New Pluggable Database
  • Viewing the User Details
  • Creating a New User Using SQL Plus
  • Creating a Group Using SQL Plus
  • Dropping a User Using SQL Plus
3

Modifying and Managing Database Parameters

  • Modifying the Current Database Parameters
  • Managing Initialization-Parameter Files
  • Monitoring the Database Alert Log
4

Understanding Storage and Space Management

  • Creating a Tablespace
  • Resizing Data Files
  • Creating a Table Using Compression
5

Managing Data Concurrency and Undo

  • Using UNDO TABLESPACE
  • Using UNDO_RETENTION
  • Updating a Table
6

Understanding Oracle Network Architecture

  • Creating a Local Connection using the SQL Developer
  • Creating a Listener
  • Configuring the Local Naming Method
7

Understanding Database Connections and Database Links

  • Using the V$SESSION View
  • Configuring DBMS_CONNECTION_POOL
  • Creating Database Links
8

Implementing Security and Auditing

  • Creating a Database User and Granting Privileges to a User
  • Creating and Granting Roles to a User
  • Revoking Privileges and Dropping a Role
  • Creating a Table using a Primary Key
  • Working with DML Triggers
  • Working with DDL Triggers
  • Working with System Event Triggers
  • Using the Instead-of Triggers
9

Creating and Dropping Database Objects

  • Using Constraints in the Table
  • Creating a View
  • Updating a View
  • Dropping a View
  • Creating a Procedure in SQL Plus
  • Dropping a Procedure in SQL Plus
  • Creating and Executing a Function in SQL Plus
  • Dropping a Function in SQL Plus
10

Creating a Profile

  • Creating a Profile
  • Enabling Privilege Auditing in SQL Plus

Related Courses

All Courses