dba training 10daneces

Oracle – DBA 11g, 12c & 18c

4 Star Rating: Very Good 4.40 out of 5 based on 315 ratings.
  • Overview
  • Course
  • Certifications

Oracle 12c is a new version of database management system. 10Daneces provides oracle 12c dba training according to the current requirement of IT industry. The Oracle Database 12c is a relational database management system (RDBMS) produced and marketed by Oracle Corporation. The specialty of this new version is the inclusion of cloud computing capability, represented by `c` in the name 12c. The term 12c DBA is often used for 12c Database Administrator, which represents a person or a group of people responsible for creation and maintenance of an Oracle 12c Database. Oracle Corporation offers a certification programme for DBAs as OCA and OCP. In this exam any DBA test his skills and get certification.
Oracle 12c Database provides efficient, reliable, secure data management for high-end applications such as high-volumeon-line transaction processing (OLTP) environments, query-intensive data warehouses, and demanding Internet applications. Our faculty provide how the student will learn and how to create an development, testing and production database and manage the various structures in an effective and efficient manner including performance monitoring, database security, user management, and backup/recovery techniques.
This course is designed to give you a organizational environment in basic database administration and advances your success as an Oracle professional in the area of database administration. You will gain a concept of the Oracle database logincal and physical architecture and how its components work and interact with one another. The lesson topics are reinforced with structured hands-on practices. This course is designed to prepare you for the corresponding OCA exam. Oracle continues to dominate the database environment in all over world. Oracle 9i,10g,11g,12c,18c are being used in the industry. Oracle is usually conducted on Linux Server platform. If you prefer, you can opt for Oracle on windows. Database Administrators (DBAs) is responsible for designing, support and implementation, maintenance of computerized databases in today’s organizations.

BENEFITS OF ORACLE DBA courses:

    • Establish your competence in Oracle's widely respected database and business technologies
    • Distinguish you from co-workers and competing job candidates
    • You increased job security in your current position
    • Perform at a higher level than other employees
    • Companies that hire Oracle professional individuals are shown to have increased staff retention

Prerequisites :

The candidates having familiarity with data processing + SQL Basic concepts and techniques are eligible to go through this training.

Exams for Certifications :

Level Exam Name Exam Code
OCA Oracle Database 12c: SQL Fundamental 1Z0-061
Oracle Database 12c: Administration I 1Z0-062
OCP Oracle database 12c:Administration II 1Z0-063

Oracle Database 11G Architecture

  • Instance vs. Oracle Database 11G
  • Components of an Oracle Database 11G Instance
  • Components of an Oracle Database 11G
  • Data files, Control files and Redo Logs
  • Checkpoints, Roll Forward and Rollback
  • Redo log concepts, Instance and Media recovery
  • Buffer Cache Block Management – LRU List
  • SGA vs. PGA
  • Background processes

Software and Database Installation

  • Unix Kernel Parameters Setup
  • Important configuration files – sysctl.conf, limits.conf, meminfo ,cpuinfo
  • Installation of Oracle Software
  • Installation Oracle Database 11G using DBCA
  • Setting up of Environment
  • Startup and Shutdown of the Oracle Database 11G

Oracle Database 11G Init Parameters

  • Init parameters
  • Displaying init.ora values with v$parameter
  • Sizing SGA components
  • Shared pool concepts and components
  • Overview of PGA for sorting and pga_aggregate_target
  • Alteration of Modifiable and Non Modifiable Init parameters vs. Spfile
  • Explaining the use of control files
  • File locations for control Files
  • Obtaining Control File Information
  • Multiplexing Control File
  • Convert Oracle Database 11G to Archive log Mode
  • Archiving the Oracle Redo Logs

Oracle Database 11G Tablespace Management

  • Managing Tablespaces – Create, alter, drop, rename, offline, online, read only, read write
  • Creating, Resizing, Renaming, offline Datafiles
  • Creating and Managing Temporary Tablespaces and Tempfiles
  • Creating and Managing Undo Tablespaces
  • Understanding Undo Retention
  • Free Space / Used Space in Tablespace
  • Troubleshooting Undo – snapshot too old
  • Online redo log (log_buffer)
  • Dictionary queries

Oracle Database 11G Redo Management, Management of Database Segments

  • Redo log switch
  • Multiplexing the Online Redo Log Files
  • Dictionary and v$ views
  • The dba_, all_ and user_ structures
  • Querying the tables, indexes, and segments views
  • Monitoring the alert log
  • Oracle Database trace/dump files
  • Oracle Database tables : Creation and Maintenance Operations
  • Oracle Database Indexes : Creating B*-Tree, bitmap and function-based Indexe
  • Oracle Database Views

Oracle Database 11G Reorg, Users, Roles , Profiles , Privileges

  • Reorganize Tables
  • Index rebuilding
  • Creating New Database Users
  • Managing Profiles
  • Identifying System and Object Privileges
  • Granting and Revoking Privileges
  • Creating and Modifying Roles
  • Displaying user security Information from the Data Dictionary

Oracle Database 11G*Net configuration

  • Understanding the Listener and how connection takes place from Client to Server
  • Use Netca
  • Creating the listener.ora file
  • Creating the tnsnames.ora file
  • Verifying network connectivity with ping and tnsping
  • Testing Oracle Database 11G connection via Listener

Oracle Database 11G Backup & Recovery

  • Hot vs. Cold backups
  • Backup in Archivelog vs. Noarchivelog Mode
  • Taking Cold Backups
  • Taking Hot Backups
  • Concepts of Hot Backup
  • Complete and Incomplete Recovery
  • Restoration from cold Backup with complete data loss
  • Restoring and Recovering from loss of Datafiles – System and non-system ,loss of Read Only Tablespaces
  • Loss of Controlfiles
  • Loss of Redo Logs – Innotactive and notactive
  • Complete and Incomplete Recovery

Oracle Database 11G Backup and Recovery management using RMAN

  • Advantages of RMAN
  • Advantages of Catalog over Nocatalog
  • Catalog Creation
  • RMAN Closed Database and Hot Backups
  • RMAN Backup Management (Backup Database , tablespace , Datafile ,controlfile ,archivelogs , spfile)
  • Viewing Backups using List
  • Configure RMAN(Configure channels , autobackup , tape / disk ,retention Policies)
  • Reporting Bacukups
  • Restoring and Recovering from loss of Datafiles – System and non system ,loss of Read Only Tablespaces
  • Loss of Controlfiles
  • Loss of Redo Logs – Inactive and Active
  • Complete and Incomplete Recovery

Oracle Database 11G DBA Utilities

  • Imp and exp utilities
  • Data pump (impdp and expdp
  • DB Verify for Corruption
  • Flashback Oracle Database, Flashback Drop , Flashback Query
  • Using opatch for Oracle Database Patching.

Oracle Cloning Of Oracle Database

  • Cloning using Hot Backup
  • Cloning Using RMAN Duplicate Database

Performance Management: Understand Problem , Check OS and Automated Reports

  • Understand the Performance Problem Scope
  • Discuss with the affected Users
  • Check dynamic performance views useful in tuning
  • Use dynamic performance views to view statistics and wait events
  • Create and manage AWR snapshots
  • Generate AWR reports
  • Generate ADDM reports
  • Log a performance Service Request with Oracle Support

Oracle Performance Management: Tuning the Oracle Database 11G Instance

  • Tuning SGA
  • Tuning the Shared Pool
  • Tuning the Buffer Cache
  • Checkpoint and Redo Tuning
  • Diagnose checkpoint and redo issues
  • Size the redo log file
  • Size the redo log buffer
  • Diagnose PGA memory issues
  • Size the PGA memory
  • Diagnose temporary space issues
  • Understanding Locks
  • Detect enqueue contention

Database 11G Performance Management: DBMS_STATS, Detect Fragmentation , SQL Tuning

  • Cost Based Optimizer
  • Using EXPLAIN PLAN
  • Using “set autotrace”
  • Interpreting EXPLAIN PLAN Output
  • Collecting Schema , table and index statistics (dbms_stats)
  • Checking Statistics
  • Tracing a Database Session
  • Using TKPROF to analyze a trace File

Oracle Database 11G Maintenance & Job Scheduling and Processes

  • Monitoring Systems
  • Commonly configured Oracle Database Alerts and Actions to be taken
  • Common Monitoring Problems Encountered and Resolution
  • Change Management Process , Approval Process
  • Ticket Management Process (Severity , Priority , SLAs,Communication Protocol).

Oracle Certified Associate Certification

Oracle Certified Associate Certification Exam :
  • Step 1 - Pass One Exam Oracle Database 12c: SQL Fundamentals I Exam Number : (1Z0-061) OR Oracle Database SQL Expert Exam Number : 1Z0-071
  • Step 2 - Pass Exam Oracle Database 12c: Administration I Exam Number : (1Z0-062)Complete the above 2 exams to become “Oracle Database 12c Administrator Certified Associate Certification-OCA”

Syllabus for Oracle Certified Associate Certification Exam

Oracle Database 12c: SQL Fundamentals I Exam Number : (1Z0-061)
  • Retrieving Data Using the SQL SELECT Statement
  • Restricting and Sorting Data
  • Using Single-Row Functions to Customize Output
  • Using Conversion Functions and Conditional Expressions
  • Reporting Aggregated Data Using the Group Functions
  • Displaying Data from Multiple Tables
  • Using Sub queries to Solve Queries
  • Using the Set Operators
  • Manipulating Data
  • Using DDL Statements to Create and Manage Tables
  • Creating Other Schema Objects
Oracle Database 12c: Administration I Exam Number : (1Z0-062)
  • Exploring the Oracle Database Architecture
  • Preparing the Database Environment
  • Creating an Oracle Database
  • Managing the Oracle Instance
  • Configuring the Oracle Network Environment
  • Managing Database Storage Structures
  • Administering User Security
  • Managing Data and Concurrency
  • Managing Undo Data
  • Implementing Oracle Database Security
  • Database Maintenance
  • Performance Management
  • Intelligent Infrastructure Enhancements
  • Backup and Recovery Concepts
  • Performing Database Backups
  • Performing Database Recovery
  • Moving Data

Drop us a query

Course Features

Real-Life Case Studies
Assignments
Lifetime Access
Expert Support
Global Certification
Job Portal Access