Login     Signup
   info@zetlantechnologies.com        +91-8680961847

  /   Oracle Technical Certification   /   ODA - I


Exam 1Z0-082: Oracle Database Administration I


Exam Code Delivery format Duration No of Questions Passing Score
1Z0-082 Proctored Online Multiple Choice 120 Minutes 72 60%

Exam Overview

An Oracle Database Administration 2019 Certified Professional has proven theoretical understanding of and the practical skills required to configure and manage Oracle Databases up to and including Oracle 19c. Passing this first exam in the two exam path proves your skills in SQL programming skills, database and network administration.


Course Details

1. Understanding Oracle Database Architecture

  • Understanding Oracle Database Instance Configurations
  • Understanding Oracle Database Memory and Process Structures
  • Understanding Logical and Physical Database Structures
  • Understanding Oracle Database Server Architecture

  • Starting Up Oracle Database Instances
  • Using Data Dictionary Views
  • Shutting Down Oracle Database Instances
  • Using Dynamic Performance Views
  • Using the Automatic Diagnostic Repository (ADR)
  • Using the Alert Log and Trace Files
  • Managing Initialization Parameter Files

  • Assigning Quotas to Users
  • Applying the Principal of Least Privilege
  • Creating and Assigning Profiles
  • Administering User Authentication Methods
  • Managing Oracle Database Users, Privileges, and Roles

  • Managing Resumable Space Allocation
  • Shrinking Segments
  • Deferring Segment Creation
  • Using Space-Saving Features
  • Deploying Oracle Database Space Management Features
  • Managing Different Types of Segments
  • Using Table and Row Compression
  • Understanding Block Space Management

  • Using External Tables
  • Using Oracle Data Pump
  • Using SQL*Loader

  • Using the Database Configuration Assistant (DBCA)
  • Using Oracle Enterprise Manager Cloud Control
  • Using racle enterprise Manager Database Express
  • Using SQL Developer
  • Using SQL Plus

  • Using Oracle Net Services Administration Tools
  • Configuring Communication Between Database Instances
  • Configuring the Oracle Net Listener
  • Connecting to an Oracle Database Instance
  • Comparing Dedicated and Shared Server Configurations
  • Administering Naming Methods

  • Viewing Tablespace Information
  • Creating, Altering and Dropping Tablespaces
  • Managing Table Data Storage
  • Implementing Oracle Managed Files
  • Moving and Renaming Online Data Files

  • Understanding Transactions and Undo Data
  • Storing Undo Information
  • Configuring Undo Rentention
  • Comparing Undo Data and Redo Data
  • Understanding Temporary Undo

  • Applying Rules of precedence for operators in an expression
  • Limiting Rows Returned in a SQL Statement
  • Using Substitution Variables
  • Using the DEFINE and VERIFY commands

  • Applying the NVL, NULLIF, and COALESCE functions to data
  • Understanding implicit and explicit data type conversion
  • Using the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions
  • Nesting multiple functions

  • Using Self-joins
  • Using Various Types of Joins
  • Using Non equijoins
  • Using OUTER joins

  • Matching the SELECT statements
  • Using the ORDER BY clause in set operations
  • Using The INTERSECT operator
  • Using The MINUS operator
  • Using The UNION and UNION ALL operators

  • Using Data Definition Language
  • Managing Views
  • Working with CURRENT_DATE, CURRENT_TIMESTAMP,and LOCALTIMESTAMP
  • Working with INTERVAL data types
  • Silent/Automated Installation

  • Using Column aliases
  • Using The DESCRIBE command
  • Using The SQL SELECT statement
  • Using concatenation operator, literal character strings, alternative quote operator, and the DISTINCT keyword
  • Using Arithmetic expressions and NULL values in the SELECT statement

  • Manipulating strings with character functions in SQL SELECT and WHERE clauses
  • Performing arithmetic with date data
  • Manipulating numbers with the ROUND, TRUNC and MOD functions
  • Manipulating dates with the date function

  • Restricting Group Results
  • Creating Groups of Data
  • Using Group Functions
  • Using Single Row Subqueries
  • Using Multiple Row Subqueries

  • Managing Database Transactions
  • Using Data Manipulation Language
  • Controlling transactions
  • Managing Indexes
  • Managing Synonyms
  • Managing Sequences
  • Creating and using temporary tables
  • Managing constraints


Fees Structure : 15500 INR / 185 USD
Total No of Class : 92 Video Class
Class Duration : 62:30 Working Hours
Download Feature : Download Avalable
Technical Support : Call / Whatsapp : +91 8680961847
Working Hours : Monday to Firday 9 AM to 6 PM
Payment Mode : Credit Card / Debit Card / NetBanking / Wallet (Gpay/Phonepay/Paytm/WhatsApp Pay)

Brochure       Buy Now       Sample Demo

Fees Structure : 30000 INR / 355 USD
Class Duration : 60 Days
Class Recording : Live Class Recording available
Class Time : Monday to Firday 1.5 hours per day / Weekend 3 Hours per day
Technical Support : Call / Whatsapp : +91 8680961847
Working Hours : Monday to Firday 9 AM to 6 PM
Payment Mode : Credit Card / Debit Card / NetBanking / Wallet (Gpay/Phonepay/Paytm/WhatsApp Pay)

Download Brochure       Pay Online

Information Technologies

Why People Like us!

For over a decade, we have been on a mission: helping everyone grow up in IT Industry. Today, we are asking that you join us.

Read More

More Info

About Us Contact Us Privacy Policy Terms & Condition Refund Policy FAQs & Help

Account

My Account Course Details Shopping Cart Wishlist Order History Payment Details

Contact

Address: Chennai, Tamilnadu, India

Email: info@zetlantechnologies.com

Phone: +91 8680961847

Payment Accepted

Zetlan Technologies, All right reserved.