Are you a new bee to Oracle Database Administration and searching for best suitable course? This course is very apt for you to begin the career as Oracle DBA. If you are looking for basic, strong and real hands on training on SQL, Linux and Oracle 12c database architecture concepts then you are at the right course. You will be introduced to this DBA role and get your hands dirty with concepts and basic activities that every DBA does in their day-to-day job as a beginner.

Get hands-on experience on standalone Oracle 12c Database environment now.

  • Install and Implement yourself.
  • Simple and easy to understand.
  • Meet industry standards.

System requirements:

  • Laptop/Desktop with at least 3GB RAM.
  • Minimum of Dual Core processor.
  • 40 GB of disk space.

Training details:

  • 13 SQL, 4 Linux and 32 DBA Sessions.
  • Trainer: Pawan Kumar Yaddanapudi.
  • Includes supporting documents, software’s and Log files.
  • Anytime assistance.

Pick your mode of learning:

Video tutorials:

  • Learn at your own pace.
  • Saves 50% of your money.
  • Revise any number of times for 6 months.
  • Assured quality and content as classroom/online training.

Online training:

  • One scheduled session per day.
  • Good internet connectivity required.
  • Batch of minimum 5 students.

Course Content

SQL Fundamentals-I

1. INTRODUCTION
1.1. Overview
1.2. Oracle account
1.3. Oracle Live SQL account
1.4. Accessing Live SQL
1.5. RDBMS & Oracle
1.6. RDBMS vs EXCEL

2. RETRIEVING DATA USING THE SQL SELECT STATEMENT
2.1. Basic SELECT statement
2.2. Arithmetic expressions and NULL values in the SELECT statement
2.3. Column aliases
2.4. Use of concatenation operator, literal character strings, alternative quote operator, and the DISTINCT keyword
2.5. Remove DUPLICATE rows
2.6. DESCRIBE command

3. RESTRICTING AND SORTING DATA
3.1. Limit the rows that are retrieved by a query
3.2. Sort the rows that are retrieved by a query
3.3. Use ampersand substitution to restrict and sort output at run time

4. USING SINGLE-ROW FUNCTIONS TO CUSTOMIZE OUTPUT
4.1. Describe various types of functions available in SQL
4.2. Use character, number, and date functions in SELECT statements

5. USING CONVERSION FUNCTIONS AND CONDITIONAL EXPRESSIONS
5.1. Implicit and explicit data type conversion
5.2. TO_CHAR, TO_DATE, TO_NUMBER functions
5.3. Nesting functions
5.4. General functions
5.5. Conditional expressions

6. GROUP FUNCTIONS
6.1. Types and syntax
6.2. Use AVG, SUM, MIN, MAX, COUNT
6.3. Use DISTINCT keyword within group functions
6.4. NULL values in a group function
6.5. Grouping rows
6.6. HAVING clause

7. DISPLAYING DATA FROM MULTIPLE TABLES
7.1. Types of JOINS and its syntax
7.2. Natural join
7.3. USING clause
7.4. ON clause
7.5. Self-join
7.6. Nonequijoins
7.7. OUTER join
7.8. LEFT OUTER join
7.9. RIGHT OUTER join
7.10. FULL OUTER join
7.11. Cartesian product
7.12. Cross join

8. USING SUB-QUERIES TO SOLVE QUERIES
8.1. Subquery: Types, syntax, and guidelines
8.2. Single-row subqueries
8.3. Group functions in a subquery
8.4. HAVING clause with subqueries
8.5. Multiple-row subqueries
8.6. Use ALL or ANY operator
8.7. Null values in a subquery

9. SET OPERATORS
9.1. Types and guidelines
9.2. Tables used in this lesson
9.3. UNION and UNION ALL operator
9.4. INTERSECT operator
9.5. MINUS operator
9.6. Matching the SELECT statements
9.7. Using the ORDER BY clause in set operations

10. MANIPULATING DATA
10.1. Adding new rows in a table
10.2. INSERT statement
10.3. Changing data in a table
10.4. UPDATE statement
10.5. Removing rows from a table
10.6. DELETE statement
10.7. TRUNCATE statement
10.8. Database transactions control using COMMIT, ROLLBACK, and SAVEPOINT
10.9. Read consistency
10.10. FOR UPDATE clause in a SELECT statement

11. USING DDL STATEMENTS TO CREATE AND MANAGE TABLES
11.1. Database objects
11.2. Naming rules
11.3. CREATE TABLE statement
11.4. Access another user’s tables
11.5. DEFAULT option
11.6. Data types
11.7. Overview of constraints: NOT NULL, PRIMARY KEY
11.8. FOREIGN KEY, CHECK constraints
11.9. Creating a table using a subquery
11.10. ALTER TABLE
11.11. Read-only tables
11.12. DROP TABLE statement

12. OTHER DATABASE OBJECTS
12.1. Overview of views
12.2. Creating, modifying, and retrieving data from a view
12.3. DML operations on a view
12.4. Dropping a view
12.5. Overview of sequences
12.6. Creating, using, and modifying a sequence
12.7. Cache sequence values
12.8. NEXTVAL and CURRVAL pseudocolumns
12.9. Overview of indexes
12.10. Creating, dropping indexes
12.11. Overview of synonyms
12.12. Creating, dropping synonyms

LINUX – BASICS

1. LINUX INSTALLATION
1.1. Installation of software to install virtual servers
1.2. Installation of Enterprise Linux – Compatible to Oracle
1.3. Configure Putty

2. LINUX COMMANDS
2.1. List all the LINUX/UNIX commands DBA needs
2.2. Understand the functionality of each command

ORACLE DATABASE ADMINISTRATION

1. INSTALL ORACLE DATABASE – NON CDB
1.1. Software’s introduction
1.2. OEL installation
1.3. OS Network configuration
1.4. Putty configuration
1.5. OS – pre-requisites
1.6. Install Oracle software
1.7. Install oracle network configuration
1.8. Install oracle database
1.9. Demonstrate connecting method to database
1.10. purpose of oraenv
1.11. start/stop listener and database
1.12. Check Oracle inventory
1.13. purpose of /etc/oratab file

2. ORACLE DATABASE ARCHITECTURE 1 – NON CDB
2.1. Connecting to a Server
2.2. Oracle Database Architecture: Overview
2.3. Connecting to the Database
2.4. Interacting with an Oracle Database
2.5. Oracle Database Server Structures
2.6. Oracle Database Memory Structures
2.7. Database Buffer Cache
2.8. Redo Log Buffer
2.9. Shared Pool
2.10. Allocation and Reuse of Memory in the Shared Pool
2.11. Large Pool
2.12. Java Pool and Streams Pool
2.13. Fixed SGA
2.14. In-Memory Column store
2.15. Types of Applications – Real Time

3. ORACLE DATABASE ARCHITECTURE 2 – NON CDB
3.1. Process Architecture
3.2. Categories – Processes
3.3. PGA
3.4. Database Writer Process (DBWn)
3.5. LogWriter Process (LGWR)
3.6. Checkpoint Process (CKPT)
3.7. System Monitor Process (SMON)
3.8. PMON
3.9. RECO
3.10. ARCn
3.11. LREG
3.12. Redo Cycle
3.13. Other background processes
3.14. New Architecture Reference Image

4. STORAGE & IN-MEMORY ARCHITECTURE – NON CDB
4.1. Introduction to Storage architecture – Linux Installation
4.2. Logical and Physical Database Structures
4.3. Tablespaces and Data Files
4.4. SYSTEM and SYSAUX Tablespaces
4.5. Segments, Extents, and Blocks
4.6. In-Memory Cache – Database
4.7. Connect the dots

5. INITIALIZATION PARAMETER FILES – NON CDB
5.1. SPFILE and PFILE
5.2. Create spfile from pfile
5.3. Create pfile from spfile
5.4. Simplified Initialization Parameters
5.5. Deal with parameters
5.6. Change dynamic and static parameters with SPFILE
5.7. Change dynamic and static parameters with PFILE

6. DATABASE STARTUP AND SHUTDOWN – NON CDB
6.1. Startup Options: Stair up
6.2. Shutdown Options: Stair down
6.3. Viewing the Alert Log
6.4. Using Trace Files
6.5. What is DDL & Debug Log files
6.6. Dynamic Performance Views
6.7. Data Dictionary

7. CONFIGURING THE ORACLE NETWORK ENVIRONMENT – NON CDB
7.1. Oracle Net Services
7.2. Oracle Net Listener
7.3. Establishing Net Connections
7.4. Establishing a Connection – Client exercise
7.5. Oracle client installation
7.6. User Sessions
7.7. Database Service Registration
7.8. Tools for Configuring and Managing the Oracle Network
7.9. Listener Control Utility
7.10. Changing Listener NAME
7.11. Naming methods
7.12. Easy Connect
7.13. Local Naming
7.14. Directory Naming
7.15. External Naming Method
7.16. Testing Oracle Net Connectivity
7.17. User Sessions: Dedicated Server
7.18. User Sessions: Shared Server
7.19. Configuring Communication Between Databases

8. MANAGING DATABASE STORAGE STRUCTURES – NON CDB
8.1. Table in datafiles
8.2. What in blocks?
8.3. Tablespaces and Data Files
8.4. Space Management in Tablespaces
8.5. Creating a New Tablespace
8.6. Tablespaces in the Preconfigured Database
8.7. Dropping Tablespaces
8.8. Viewing Tablespace Information
8.9. Viewing Tablespace Contents
8.10. OMF – Oracle Managed Files
8.11. Enlarging the Database
8.12. Automatic Storage Management
8.13. List of Tablespace management activities – SRT

9. ADMINISTERING USER SECURITY – NON CDB
9.1. Database User Accounts
9.2. Predefined Accounts
9.3. Password file
9.4. Administrator Authentication
9.5. Creating a User
9.6. Drop a user
9.7. Unlocking a User Account and Resetting the Password
9.8. Reset password with HASH value
9.9. System and Object Privileges
9.10. Benefits of Roles
9.11. Assigning Privileges to Roles and Assigning Roles to Users
9.12. Predefined Roles
9.13. Create & Assigning Roles
9.14. DBMS_PRIVILEGE_CAPTURE in 12c
9.15. Profiles and Users
9.16. Password security in 12c

10. MANAGING UNDO DATA – NON CDB
10.1. What is Undo?
10.2. Transactions and Undo Data
10.3. Storing Undo Information
10.4. Undo Data Versus Redo Data
10.5. Managing Undo
10.6. Configuring Undo Retention
10.7. Guaranteeing Undo Retention
10.8. Changing an Undo Tablespace to a Fixed Size
10.9. Temporary Undo – in 12c

11. DATA CONCURRENCY MANAGEMENT – NON CDB
11.1. Oracle locks
11.2. Concurrency
11.3. Role of Enqueues
11.4. Handling conflicts
11.5. Deadlocks

12. PERFORMANCE MAINTENANCE – NON CDB
12.1. Terminology
12.2. Types
12.3. Performance Planning
12.4. Tune Instance
12.5. Tuning methodology
12.6. Sessions
12.7. Waits
12.8. Memory management
12.9. AMM & ASMM
12.10. SQL Tuning
12.11. Optimizer
12.12. Optimizer statistics
12.13. SQL Tuning Advisors

13. BACKUP AND RECOVERY CONCEPTS – NON CDB
13.1. Responsibilities
13.2. Categories of Failure
13.3. Details of Failures
13.4. Flashback basics
13.5. Understanding Instance Recovery
13.6. Phases of Instance Recovery
13.7. Complete vs Incomplete Recovery
13.8. Available Solutions
13.9. Configuring for Recoverability
13.10. Configuring the Fast Recovery Area
13.11. Multiplexing Control Files
13.12. Redo Log Files
13.13. Archive Log Files
13.14. Enabling ARCHIVELOG Mode

14. ORACLE DATABASE BACKUPS – NON CDB
14.1. Backup Solutions: Overview
14.2. Oracle Secure Backups
14.3. User-Managed Backup
14.4. Terminology
14.5. Full & Incremental backups
14.6. Recovery Manager (RMAN)
14.7. Configuring Backup Settings
14.8. Backing Up the Control File to a Trace File
14.9. Creating Backups
14.10. Viewing Backup Reports
14.11. Monitoring the Fast Recovery Area

15. ORACLE DATABASE RECOVERY – NON CDB
15.1. Keeping a Database Open
15.2. Data Recovery Advisor
15.3. Data Failure: Examples
15.4. Loss of a Control File
15.5. Loss of a Redo Log File
15.6. Loss of a Data File in NOARCHIVELOG Mode
15.7. Loss of a Noncritical Data File in ARCHIVELOG Mode
15.8. Loss of a System-Critical Data File in ARCHIVELOG Mode

16. REFRESHING DATA – NON CDB
16.1. Moving Data: General Architecture
16.2. SQL*Loader: Overview
16.3. Loading Data with SQL*Loader
16.4. Loading Methods
16.5. External Tables Overview
16.6. Using External Tables
16.7. Oracle Data Pump: Overview
16.8. Oracle Data Pump: Benefits
16.9. Data Pump Export and Import: Overview
16.10. Data Pump Utility: Interfaces and Modes
16.11. Data Pump Import
16.12. Data Pump Import: Transformations

17. ORACLE CDB ARCHITECTURE 1
17.1. Containers Introduction
17.2. Installing CDB database
17.3. CDB database checks
17.4. Benefits of CDB
17.5. CDB Configs
17.6. CDB Architecture overview
17.7. CDB Process Architecture
17.8. CDB Memory Architecture

18. ORACLE CDB ARCHITECTURE 2
18.1. CDB Storage Architecture
18.2. CDB Initialization Parameters
18.3. CDB Instance Management
18.4. CDB Network Management
18.5. CDB Tablespaces
18.6. CDB User Management

19. ORACLE CDB ARCHITECTURE 3
19.1. CDB Undo Data
19.2. Data Concurrency in CDB
19.3. RMAN CDB
19.4. Recovering CDB
19.5. CDB Performance Management
19.6. CDB Data Refresh

20. WORKING WITH DATABASE TOOLS & OTHER OBJECTS
20.1. Oracle DB Management Tools
20.2. SQL Plus
20.3. SQL developer
20.4. Oracle Enterprise Manager Express
20.5. OEM Cloud Control
20.6. PL/SQL Objects

21. WORKING WITH SUPPORT
21.1. Working with Oracle Support
21.2. Using MetaLink
21.3. Researching an Issue
21.4. Logging Service Requests
21.5. Managing Patches
21.6. Applying a Patch Release – SPU patch example
21.7. Online patching
21.8. Identify list of patches installed
21.9. Find OPatch version




Core DBA for Beginners – 12c