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

Any questions?
Check out the FAQs

Still have unanswered questions and need to get in touch?

Contact Us Now

Related Courses

All Courses
We use cookies for improving site experience and analytics. Learn More