Database-Training

Course Key Notes:

1. Weekdays batch will be of daily 2 hours

2. This is Database Administration Workshop

3. Theory and Live demonstration on each topic

4. Daily sessions will be recorded and uploaded to google drive

5. Lab, Quiz, Workbook, Tools/Software given in advance

6. Each topic will be having quiz and multiple-choice answers

7. Daily practical task will be assigned and reviewed

8. This course will be covering real time demonstration and examples

9. Resume and Cover letter writing after course completion

10.We will be reviewing the Interview Questions

11.After the course we will be conducting the Mock Interview

Course Fees:

Course fees for Database Course 10K INR or 125 USD

Click here to Register
Click here for more Information

Database Course Contents:

1. Environment Setup:

a) Software Download

Linux OS ISO image

Oracle Software

Oracle Patches

VMware Workstation Download

Oracle Virtual Box Download 

b) VMware Workstation or Oracle Virtual Box Installation

c) Linux Installation (RHEL/OEL/Ubuntu)

Understanding the Linux Partition

Yum repo setup

Installation custom rpms and packages 

d) Other tools download installation

Winscp 

Putty 

MobaXterm  

2. Setting up DNS and DHCP and name resolution

a) DNS

b) DHCP

c) Nameserver 

d) Forward Resolution

e) Reverse Resolution

3. Installing 11g / 12c / 19c  Oracle Software

a) Download Oracle database software

b) Install and configure 11g / 12c /19c Oracle Database Software 

GUI mode runInstaller

Silent Mode

4. Creating 11g / 12c / 19c databases (manual) 

5. Creating 11g / 12c / 19c databases (GUI mode using dbca)

6. 11g / 12c /19c Architecture.

Complete understanding of 11g and 12c and 19c architecture

7. Oracle Administration and management.

a) Starting and shutting down database.

b) Understanding control files / datafiles / redo log files / archive files / temp files

c) Understanding Server parameter file and Parameter files

d) Understanding password files

e) Automatic memory management

f) Different components in SGA and PGA 

8. Tablespaces / Segments / Extents and Data Blocks

a) Dictionary managed vs Locally managed tablespaces.

b) Automatic Segment space management

c) Understanding Segments / extents and blocks and Relationships

d) Data Block parameters

e) Different block Sizes 

9. ASM Architecture Overview and Administration

a) ASM Architecture

b) Why we need ASM and Its Advantages

c) ASM instance parameters

d) ASM Administration 

10. 12c / 19c Multitenant Database Architecture and New Features

a) Complete Understanding of Multitenant architecture

b) CDB and PDB Understanding  

c) Installation of Pluggable database and Cloning Pluggable Database

11. Oracle networking

a) Configuring and maintaining listeners.ora

b) Configuring and maintaining tnsnames.ora

c) Configuring and maintaining sqlnet.ora

d) SQL Developer or Toad Download and Installation

e) How to connect to database using SQL Developer or Toad

12. User Account Management

a) users or schemas

b) Privileges 

c) Roles
d) Profiles

13. Database Backup and Recovery Understanding

a) Understanding the Backup strategy

b) Various Types of Backup

c) Complete understanding of RMAN Vs Conventional backups  

14. RMAN and Conventional Backup & Recovery

a) Conventional Backup 

Cold Backup 

Hot Backup

Logical Backup

User managed Backups 

b) RMAN Backup 

Full database Backup

Level 0 Backup 

Level 1 Backup (Cumulative and Differential)

c)   Different RMAN Backup and Restore scenarios 

15. Database Cloning (RMAN and Conventional)

a) Cloning database using Conventional methods

b) Cloning database using RMAN

16. Applying Patches (PSU/CPU/BP/ONEOFF/MERGE Patch etc)

a) Different types of Patches

b) OPatch patching tool 

c) How to apply patch at binary level (Oracle Home).

d) How to apply patch at database level.

17. Database upgrade

a) Understanding of Database Upgrade from 11g to 12c

b) Understanding of Database Upgrade from 11g to 19c

c) Converting 12c noncdb to 12c pluggable database

18. Dataguard Architecture and Standby database / Data guard Understanding

a) Dataguard Architecture

b) Different Types of Standby Databases and Standby database modes

c) Configure physical standby database

d) Understanding logical and snapshot standby database

19. Shell Scripting Overview

a) Basic scripts and writing some sample scripts 

b) Scheduling jobs using shell script and cronjob

c) Oracle Database automation shell scripts 

20. Expdp / Impdp backups

a) Expdb and impdb (tables, schemas, tablespaces and databases)

b) Real time scenarios on How to improve and troubleshoot expdp and impdp

21. 12c and 19c New Features

22. AWR reports / ADDM reports / ASH report

a) How to generate AWR  / ADDM / ASH reports?

b) How to read AWR  / ADDM / ASH reports?

23. Real time and Practical Scenarios and excises

24. Proactive Monitoring and Alert mechanism and Maintenance 

25. Performance tuning

a) Index Rebuild

b) gather states 

c) Generate AWR reports / ADDM reports / ASH report

d) Miscellaneous 

26. Resume and Cover letter Preparation

27. Interview Questions

Frequently asked Interview questions and answers 

28. Mock Interview

Mock interview and Tips on how to crack interview

 

Click here to Register
Click here for more Information

Regards,

Mallik