loading
hello dummmy text
koncpt-img

Core DBA for Beginners

Are you looking for best DBA training to begin your career as Oracle DBA? This course will help you to learn basics of Oracle database administration. It covers SQL fundamentals, Linux basics and Administration-I theoretical concepts and practical’s.

Pre-requisites (Free)

No Pre-requisites needed

System Requirements

CPU:Minimum of Dual Core processor

Memory: 3 GB

OS: Windows/MacOS

Space: 40 GB of disk spac

Training Details

31 DBA Sessions.

Trainer: Pawan Kumar Yaddanapudi.

Includes supporting documents, software’s and Log files.

Anytime assistance.

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.

SQL Fundamentals-I

  1. Introduction
    1. Oracle XE installation for SQL practice
    2. Oracle account creation
    3. Connecting to XE instance

  2. Retrieving Data Using the SQL SELECT Statement
    1. Basic SELECT statement
    2. Arithmetic expressions and NULL values in the SELECT statement
    3. Column aliases
    4. Use of concatenation operator, literal character strings, alternative quote operator, and the DISTINCT keyword
    5. Remove DUPLICATE rows
    6. DESCRIBE command

  3. Restricting and Sorting Data
    1. Limit the rows that are retrieved by a query
    2. Sort the rows that are retrieved by a query
    3. Use ampersand substitution to restrict and sort output at run time

  4. Using Single-Row Functions to Customize Output
    1. Describe various types of functions available in SQL
    2. Use character, number, and date functions in SELECT statements

  5. Using Conversion Functions and Conditional Expressions
    1. Implicit and explicit data type conversion
    2. TO_CHAR, TO_DATE, TO_NUMBER functions
    3. Nesting functions
    4. General functions
    5. Conditional expressions

  6. Group Functions
    1. Types and syntax
    2. Use AVG, SUM, MIN, MAX, COUNT
    3. Use DISTINCT keyword within group functions
    4. NULL values in a group function
    5. Grouping rows:
    6. GROUP BY clause
    7. HAVING clause
    8. Nesting group functions

  7. Displaying Data from Multiple Tables
    1. Types of JOINS and its syntax
    2. Natural join:
    3. USING clause
    4. ON clause
    5. Self-join
    6. Nonequijoins
    7. OUTER join:
    8. LEFT OUTER join
    9. RIGHT OUTER join
    10. FULL OUTER join
    11. Cartesian product
    12. Cross join

  8. Using Subqueries to Solve Queries
    1. Subquery: Types, syntax, and guidelines
    2. Single-row subqueries:
    3. Group functions in a subquery
    4. HAVING clause with subqueries
    5. Multiple-row subqueries
    6. Use ALL or ANY operator
    7. Null values in a subquery

  9. Set Operators
    1. Types and guidelines
    2. Tables used in this lesson
    3. UNION and UNION ALL operator
    4. INTERSECT operator
    5. MINUS operator
    6. Matching the SELECT statements
    7. Using the ORDER BY clause in set operations

  10. Manipulating Data
    1. Adding new rows in a table
    2. INSERT statement
    3. Changing data in a table
    4. UPDATE statement
    5. Removing rows from a table:
    6. DELETE statement
    7. TRUNCATE statement
    8. Database transactions control using COMMIT, ROLLBACK, and SAVEPOINT
    9. Read consistency
    10. FOR UPDATE clause in a SELECT statement

  11. Using DDL Statements to Create and Manage Tables
    1. Database objects
    2. Naming rules
    3. CREATE TABLE statement:
    4. Access another user’s tables
    5. DEFAULT option
    6. Data types
    7. Overview of constraints: NOT NULL, PRIMARY KEY
    8. FOREIGN KEY, CHECK constraints
    9. Creating a table using a subquery
    10. ALTER TABLE
    11. Read-only tables
    12. DROP TABLE statement

  12. Other Database objects
    1. Overview of views
    2. Creating, modifying, and retrieving data from a view
    3. DML operations on a view
    4. Dropping a view
    5. Overview of sequences
    6. Creating, using, and modifying a sequence
    7. Cache sequence values
    8. NEXTVAL and CURRVAL pseudocolumns
    9. Overview of indexes
    10. Creating, dropping indexes
    11. Overview of synonyms
    12. Creating, dropping synonyms

LINUX – BASICS

  1. Linux Installation
    1. Installation of software to install virtual servers
    2. Installation of Enterprise Linux – Compatible to Oracle
    3. Configure Putty

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

ORACLE DATABASE ADMINISTRATION

  1. INSTALL ORACLE DATABASE – NON CDB
    1. Softwares introduction
    2. Network configuration
    3. Install OS – pre requisites
    4. Install Oracle software
    5. Install oracle network configuration
    6. Install oracle database
    7. purpose of oraenv and /etc/oratab
    8. purpose of /etc/oratab file

  2. ORACLE DATABASE ARCHITECTURE 1 – NON CDB
    1. Connecting to a Server
    2. Oracle Database Architecture: Overview
    3. Connecting to the Database
    4. Interacting with an Oracle Database
    5. Oracle Database Server Structures
    6. Oracle Database Memory Structures
    7. Database Buffer Cache
    8. Redo Log Buffer
    9. Shared Pool
    10. Allocation and Reuse of Memory in the Shared Pool
    11. Large Pool
    12. Java Pool and Streams Pool
    13. Process Architecture
    14. Oracle Background processes in DETAIL
    15. Redo Cycle
    16. Other background processes
    17. Server process and buffer cache

  3. Storage Architecture
    1. Introduction to Storage architecture
    2. Logical and Physical Database Structures
    3. Tablespaces and Data Files
    4. SYSTEM and SYSAUX Tablespaces
    5. Segments, Extents, and Blocks

  4. Initialization Parameter Files
    1. Simplified Initialization Parameters
    2. SPFILE
    3. PFILE
    4. Change dynamic and static parameters with SPFILE
    5. Change dynamic and static parameters with PFILE
    6. Create spfile from pfile
    7. Create pfile from spfile

  5. Start/Stop and Log files
    1. Database Startup and Shutdown
    2. Startup Options: Examples
    3. Shutdown Options
    4. Shutdown Options: Examples
    5. Viewing the Alert Log
    6. Using Trace Files
    7. Dynamic Performance Views
    8. Data Dictionary

  6. Configuring the Oracle Network Environment
    1. Oracle Net Services
    2. Oracle Net Listener
    3. Establishing Net Connections
    4. Establishing a Connection
    5. User Sessions
    6. Tools for Configuring and Managing the Oracle Network
    7. Listener Control Utility
    8. Changing Listener NAME
    9. Database Service Registration
    10. Naming methods
    11. Local Naming
    12. Directory Naming
    13. External Naming Method
    14. Testing Oracle Net Connectivity
    15. User Sessions: Dedicated Server
    16. Configuring Communication Between Databases

  7. Managing Database Storage Structures
    1. Storage Structures
    2. How Table Data Is Stored
    3. Database Block: Contents
    4. Tablespaces and Data Files
    5. Space Management in Tablespaces
    6. Creating a New Tablespace
    7. Tablespaces in the Preconfigured Database
    8. Altering a Tablespace
    9. SMALLFILE and BIGFILE TABLESPACES
    10. Actions with Tablespaces
    11. Dropping Tablespaces
    12. Viewing Tablespace Information
    13. Gathering Storage Information
    14. Viewing Tablespace Contents
    15. Oracle Managed Files (OMF)
    16. Enlarging the Database
    17. Automatic Storage Management
    18. ASM: Key Features and Benefits

  8. Administering User Security
    1. Database User Accounts
    2. Predefined Accounts: SYS and SYSTEM
    3. Creating and drop a User
    4. Administrator Authentication
    5. Unlocking a User Account and Resetting the Password
    6. Reset password with HASH value
    7. System Privileges
    8. Object Privileges
    9. Revoking System Privileges
    10. Revoking Object Privileges
    11. Benefits of Roles
    12. Creating a Role and Assigning Roles to Users
    13. Profiles and Users
    14. Implementing Password Security Features
    15. Creating a Password Profile
    16. Supplied Password Verification Function:VERIFY_FUNCTION_11G
    17. Assigning Quotas to Users

  9. Managing Data and Concurrency
    1. Manipulating Data by Using SQL
    2. COMMIT and ROLLBACK Commands
    3. PL/SQL
    4. Administering PL/SQL Objects
    5. PL/SQL Objects
    6. Functions
    7. Procedures
    8. Packages
    9. Built-in Packages
    10. Triggers
    11. Triggering Events
    12. Locks
    13. Locking Mechanism
    14. Data Concurrency
    15. DML Locks
    16. Enqueue Mechanism
    17. Lock Conflicts
    18. Possible Causes of Lock Conflicts
    19. Detecting Lock Conflicts
    20. Resolving Lock Conflicts
    21. Deadlocks

  10. Managing Undo Data
    1. Data Manipulation
    2. Undo Data
    3. Transactions and Undo Data
    4. Storing Undo Information
    5. Undo Data Versus Redo Data
    6. Managing Undo
    7. Configuring Undo Retention
    8. Guaranteeing Undo Retention
    9. Changing an Undo Tablespace to a Fixed Size

  11. Database Maintenance & Performance Management
    1. Terminology
    2. Oracle Optimizer: Overview
    3. Optimizer Statistics
    4. Statistic Levels
    5. Preferences for Gathering Statistics
    6. Automatic Workload Repository(AWR)
    7. AWR Infrastructure
    8. Baselines
    9. Managing the AWR
    10. Automatic Database Diagnostic Monitor (ADDM)
    11. Advisory Framework
    12. Automated Maintenance Tasks
    13. Performance Monitoring
    14. Managing Memory Components
    15. Dynamic Performance Statistics
    16. Troubleshooting and Tuning Views
    17. Invalid and Unusable Objects
  12. Backup and Recovery Concepts
    1. Part of Your Job
    2. Categories of Failure
    3. Statement Failure
    4. User Process Failure
    5. Network Failure
    6. User Error
    7. Instance Failure
    8. Understanding Instance Recovery
    9. Phases of Instance Recovery
    10. Media Failure
    11. Configuring for Recoverability
    12. Configuring the Flash Recovery Area
    13. Multiplexing Control Files
    14. Redo Log Files
    15. Archive Log Files
    16. Enabling ARCHIVELOG Mode

  13. Performing Database Backups
    1. Backup Solutions: Overview
    2. Oracle Secure Backup
    3. User-Managed Backup
    4. Terminology
    5. Differential Incremental level 1
    6. Cumulative Incremental level 1
    7. Recovery Manager (RMAN)
    8. Configuring Backup Settings
    9. Backing Up the Control File to a Trace File
    10. Managing Backups
    11. Viewing Backup Reports
    12. Monitoring the Flash Recovery Area

  14. Performing Database Recovery
    1. Keeping a Database Open
    2. Data Recovery Advisor
    3. Data Failure: Examples
    4. Data Recovery Advisor Views
    5. Loss of a Control File
    6. Loss of a Redo Log File
    7. Loss of a Data File in NOARCHIVELOG Mode
    8. Loss of a Noncritical Data File in ARCHIVELOG Mode
    9. Loss of a System-Critical Data File in ARCHIVELOG Mode

  15. Moving Data
    1. Moving Data: General Architecture
    2. Directory Objects: Overview
    3. Creating Directory Objects
    4. SQL*Loader: Overview
    5. Loading Data with SQL*Loader
    6. SQL*Loader Control File
    7. Loading Methods
    8. External Table Population
    9. Using External Tables
    10. Oracle Data Pump: Overview
    11. Oracle Data Pump: Benefits
    12. Data Pump Export and Import: Overview
    13. Data Pump Utility: Interfaces and Modes
    14. Data Pump Import
    15. Data Pump Import: Transformations
    16. Data Pump: Performance Considerations
    17. Performance Initialization Parameters

  16. Working With Support
    1. Using the Support Workbench
    2. Creating a Service Request
    3. Packaging and Uploading Diagnostic Data to Oracle Support
    4. Working with Oracle Support
    5. MetaLink Integration
    6. Using MetaLink
    7. Researching an Issue
    8. Logging Service Requests
    9. Managing Patches
    10. Applying a Patch Release – SPU patch example
    11. Identify list of patches installed
    12. Find OPatch version

Frequently Asked Questions (FAQs)

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

Need More info ?

Wondering what ORSKL can do for you?

Related Posts

There are many variations of passages of Lorem Ipsum available but majority have suffered alteration in some.There are many variations.

Core DBA For Beginners

Knowledge That Can Always Keep Your Inbox Informed