Course Overview

#1 Oracle 11g DBA training program in USA

#1 Oracle training program in USA.Oracle Database 11g Administration + LINUX AdministrationGet trainer from Oracle certified DBA with 12 years DBA experienceGeneral information about the course

Comprehensive live training on Oracle 11g administration + LINUX administration.
Each student will get a leased LINUX/UNIX server with for hands-on LAB exercises!!!.
Total duration of the course is 90 hours (30 hour Linux & 60 hour Oracle 11g)
Course fee is $950 per student (INCLUDING LEASED SERVERS FOR LABS)
Course schedule is Monday, Wednesday, Friday & Sunday 9 PM to 11:30 PM EST.
Trainer has 12 years Oracle DBA experience and has a passion for teaching.
After each class, you will get

course material for certification exams
Hands-On LAB exercises which you need to finish before next class.
Recorded video of the live class which you can keep it forever and review it later.

1. Oracle Database Architecture

Memory structures in a Oracle instance
Process structures in a Oracle instance
Storage structures in a Oracle database

2. Installing Oracle RDBMS Software and Creating an Oracle Database

Configuring a UNIX server for installing Oracle RDBMS software
Installing Oracle RDBMS software using OUI(Oracle Universal Installer)
Creating a database using DBCA and scripts

3. Managing a Oracle Instance

Database initialization parameters
Different stages of database startup and shutdown
Various log/trace files for monitoring and research
Data dictionary and dynamic/static performance views

4. Configuring Network for connecting to a Oracle Database

Configuring Oracle networking for remote connections
Shared server and dedicated server architecture

5. Oracle Database Storage Structures

Database blocks, extents and segments
Tablespaces and datafiles
Creating and managing tablespaces
Dictionary and locally managed tablespaces

6. Administering Users and their Security in a Oracle Database

Creating and administering Database User/Schema accounts
Privileges administration, grant and revoke privileges
Roles and profiles administration

7. How Oracle works for Data and Concurrency

Database locks and undo usage for read consistency
Deadlocks

8. How Oracle Managed Undo Data

Overview of undo
Transactions and how they use undo
Administering undo

9. Oracle Database Statistics and AWR

Administering database statistics
Using AWR(Automatic Workload Repository)
Available advisors for proactive tuning
ADDM(Automatic Database Diagnostic Monitoring)
Using Oracle Enterprise Manager Grid Control(EMGC) or database control

10. Oracle Database Performance

Automatic Memory Management
Memory advisors
Administering invalid and unusable objects

11. Oracle Database Backup, Restore and Recovery

Identifying different kinds of errors that can occur in a Oracle database
Tuning instance recovery
What are checkpoints, redo log files and archived log files
Flash recovery area
Configuring a Oracle database in archivelog and noarchivelog mode.
Different types of backups
Performing backups
Restoring and recovering from various database failure scenarios

12. Oracle Utilities - SQL * Loader, External Tables and Datapump

Moving data using SQL* Loader
Moving data using external tables
Moving and backing up data using datapump

13. ASM

Describe Automatic Storage Management(ASM)
Init.ora for ASM
Startup/shutdown of ASM
ASM Disk groups

14. RMAN

Multiple archive log destinations for redundancy
Retention policy configuration
Configuring Flash Recovery Area
Administering RMAN Recovery Catalog
Administering RMAN scripts
Administering virtual recovery catalogs
Creating image file backups, whole database backups, archival backup for retention, compressed backups, encrypted backups
Reporting features in RMAN to query backups
Recovery scenarios

Lost temporary file
Lost redo log group
Lost password file
Lost system datafile
Lost undo datafile
Lost datafile belonging to index tablespace
Lost datafile belonging to data tablespace
Complete database recovery
Incomplete database recovery
Block recovery
TSPITR(TableSpace Point-In-Time Recovery)

15. Flashback Technology

How recycle bin works
Perform flashback query
Use flashback transaction
Perform flashback table operations
Configuring flashback database and administering flashback database operations

16. Database Scheduler

Creating jobs, programs and schedules
Creating windows and job classes
Default scheduled jobs in a Oracle database

17. PL/SQL

Server side PL/SQL programs
Creating database packages
Creating database stored procedures and functions
Creating database triggers

LINUX Administration Course Contents (30 Hours) 1. Basics of UNIX

Connecting securely to a Remote Server
Logging on/off the UNIX server
Commonly used UNIX tools - PuTTy, cygwin, vncserver/vncviewer, Secure CRT
Running a command

2. Working in the shell

Popular shells - bash, ksh , sh and csh
Common operations using shell. Running previously entered commands, automatically completing long commands, viewing environment variables are few to name

3. Processes and Users

Listing and terminating processes
Listing the users logged on
Changing users password
What is root and why it is super user
UNIX groups

4. Creating and Editing Files

Text and binary files
Creating and editing files
Common commands related to files touch, vi, cat, tail, head, mv, rm, diff
vi editor
soft and hard links

5. Managing Files and Directories

Commonly used directory commands pwd, cd, mkdir, rmdir, push, pop, ls
File/directory permission and ownership
Different file types and hidden files.
Find command

6. Archiving and compressing

tar and cpio commands to archive
compress, gzip, zip, uncompress, unzip and gunzip commands

7. Shell Scripting

Writing a simple shell script
Common programming tools -conditions, loops, menu choices in shell scripts
Modularizing scripts
Parameters and arguments
How to run Oracle database commands in a shell script
Running scripts in background
Debugging a script

8. Analyzing Server Performance

Identifying system bottlenecks
Identifying CPU bottlenecks
Monitoring disk space
Monitoring I/O
UNIX tools that help in analyzing server performance - top, sar, iostat, vmstat, mpstat, uptime

9. Configuring system resources

Displaying server hardware/operating system information
Listing resources such as CPUs, memory
Kernel parameters

10. Managing Server Software

Installing packages
Linux installation tools yum, rpm
Completing prerequisites on a server to install Oracle software
Installing Oracle software on a Linux server
Installing a Oracle patchset
Installing a Oracle one-off patch

11. Automating Jobs

Automating database shutdown and startup with server reboot
Scheduling jobs - cron

Get Your Free Demo Training Session Now

Upcoming Batch Schedule For Online Database Training

Batch Date	Training Mode	Register
4/10/2024	Online Class	Enroll Now
4/22/2024	Online Class	Enroll Now
6/8/2024	Online Class	Enroll Now

Related Training Courses You May Be Interested

training on sql server with sponsorship in 2022 by an e-verified and inc 5000 company in new york

We are an e-Verified and Inc. 5000 Company is looking for Excellent Individuals in the below technologies with Sponsorship in 2022.Business analystPythonSQLMicrosoft SQL ServerSnowflakeScrum MasterJAVAFullstack DeveloperWE are also in the urge of starting the training for SQL Server Training..Skills Required:Agile development life-cycle experience is a added advantageShould be able to work with little supervision or no supervision on after trainingMust have knowledge on cloud systems (Azure and Aws any one is fine)Should have good idea on SQL / High aptitude for data analysis and modelingStrong skills developing queries, scripts, and stored proceduresShould be able to perfom optimization techniques on the given database Possess Analytical business analysis skills - as they should be able to gather requirements from the clients provided interaction with business users smoothly is a added advantageExcellent CE building reports using third party reporting tools (SQL Se..

View Course

database online training and job placement assistance - best trainers

Maintain a successful database. Enroll training with us. Provide support in complex problem-solving situations, address questions about technical problems and interact directly with internal staff as required. Join database training classes online. Best trainers are here in our institute.You can expect training courses on Oracle 11g DBA which are most recent in the business designed to give a complete overview of a unique area, and also personalized classes to suit your needs.Our training materials happen to be divided in to several number of modules lasting between 1 hour to 6 hours. You can choose training courses personalized specifically to your preferences. We use simple examples that will make you understand the topic completely.Our specialists offer practical solutions to all the challenges experienced by you. Our specialists provide you with productive training in Oracle 11g DBA courses and its latest software on how to use its features to sharpen yourself...

View Course

enroll database course with resume building by professionals- get discount

You can now learn Database Developer training from our Experts. We are the best providers of any Database Developer Training with excellent syllabus. By placement, course syllabus and practicals we are one of the best Database Developer Training providers in the US at low cost.With the sense of personal hands-on Database training and optional follow up mentoring we can guarantee that the training is sure to provide you maximum benefit with a good Job and certification.The training is offered in classroom, online modes with classes on weekends, weekdays and fast track by certified experts with real-time live projects.Drop in your requirements below and we will get back to you soon...

View Course