.jpg){kind=logo}
STY-CIS424.AE1
CIS 424 Database administration I
Intermediate Self-paced · 1 year access
47 Hands-On LiveLabs
Practice real IT tasks in guided environments.
- Real environments
- Auto-graded
- No installation
01 / Lessons & labs
See exactly what you will learn and practice
Lessons
10 Interactive Lessons · 38 topics01 Introducing Oracle Database 12c Components and Architecture 4 topics · 9 LiveLab +
- Oracle Database Fundamentals
- Oracle Database 12c Architecture
- Oracle Data Integrator Repositories
- Summary
9 LiveLab in this lesson — see the labs panel →
02 Creating and Operating Oracle Database 12c 5 topics · 5 LiveLab +
- Oracle Database 12c Software Installation
- Using DBCA to Create an Oracle 12c Database
- Working with Oracle Database Metadata
- Managing Users and Groups
- Summary
5 LiveLab in this lesson — see the labs panel →
03 Modifying and Managing Database Parameters 4 topics · 3 LiveLab +
- Modifying and Managing Initialization-Parameter Files
- Starting Up and Shutting Down an Oracle Instance
- Monitoring the Database Alert Log
- Summary
3 LiveLab in this lesson — see the labs panel →
04 Understanding Storage and Space Management 5 topics · 3 LiveLab +
- Understanding the Physical and Logical Storage
- Managing Tablespaces
- Managing Data Files
- Managing Space
- Summary
3 LiveLab in this lesson — see the labs panel →
05 Managing Data Concurrency and Undo 3 topics · 3 LiveLab +
- Managing Data Changes Using DML
- Managing Data Concurrency
- Summary
3 LiveLab in this lesson — see the labs panel →
06 Understanding Oracle Network Architecture 5 topics · 3 LiveLab +
- Introducing Network Configurations
- An Overview of Oracle Net Features
- Configuring Oracle Net on the Server
- Configuring Oracle Net for the Client
- Summary
3 LiveLab in this lesson — see the labs panel →
07 Understanding Database Connections and Database Links 4 topics · 3 LiveLab +
- An Overview of Oracle Shared Server
- Understanding Database Resident Connection Pooling
- Communicating Between Databases
- Summary
3 LiveLab in this lesson — see the labs panel →
08 Implementing Security and Auditing 3 topics · 8 LiveLab +
- Creating and Managing User Accounts
- Privileges and Working with Triggers
- Summary
8 LiveLab in this lesson — see the labs panel →
09 Creating and Dropping Database Objects 2 topics · 8 LiveLab +
- Creating and Dropping Database Objects
- Summary
8 LiveLab in this lesson — see the labs panel →
10 Creating a Profile 3 topics · 2 LiveLab +
- Controlling Resource Usage by Users
- Auditing Database Activity
- Summary
2 LiveLab in this lesson — see the labs panel →
Hands-On Labs Our edge
47 LiveLabs- 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
- 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
- Modifying the Current Database Parameters
- Managing Initialization-Parameter Files
- Monitoring the Database Alert Log
- Creating a Tablespace
- Resizing Data Files
- Creating a Table Using Compression
- Using UNDO TABLESPACE
- Using UNDO_RETENTION
- Updating a Table
- Creating a Local Connection using the SQL Developer
- Creating a Listener
- Configuring the Local Naming Method
- Using the V$SESSION View
- Configuring DBMS_CONNECTION_POOL
- Creating Database Links
- 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
- 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
- Creating a Profile
- Enabling Privilege Auditing in SQL Plus
Labs run in your browser — nothing to install.
02 / FAQs
Questions before you start
![1Z0-071.AO1: [ORACLE PRESS] Oracle Database SQL_Image](http://d3hu3i8dxloald.cloudfront.net/images/new/MHE-1Z0-071_pro.png?202608009V)
Prepare for CIS 424 Database administration I
One-time payment. Full access for 1 year. Start with a free trial if you want to look around first.
- 1 year of full access
- 47 LiveLab included
- Certificate of completion
No credit card required