Linux/Shell scripts

Linux/Shell Scripts

Linux and Shell Scripts

Linux and shell scripts are powerful tools for automation and system management. Whether you're a beginner or an advanced user, mastering shell scripting can help streamline tasks, automate processes, and improve efficiency.

  • Linux & Shell scripts

    ✔ Linux Installation

    ✔ Basic Commands
    ✔ Permissions Commands
    ✔ Search Commands
    ✔ System Commands
    ✔ File Commands

    ✔ Editors - Vim
    ✔ Compression Commands
    ✔ Job Scheduling
    ✔ sysadmin Commands
    ✔ Network Commands
    ✔ File transfer Commands
    ✔ Shell - types

    ✔ Env. Variables
    ✔ Operators
    ✔ Arguments
    ✔ Conditions & Loops
    ✔ Scripts for log monitoring
    ✔ Scripts for DB and Instance monitoring

SQL - for Developers

SQL - ORACLE

SQL - Structured Query Language

SQL is a standard language for managing and manipulating relational databases. It allows users to create, read, update, and delete data in a structured manner. SQL is widely used in various applications, from web development to data analysis.

  • Introduction to SQL

    ✔ SQL Developer

    ✔ Logging in SQL*Plus
    ✔ Connecting to Database on windows and Linux

  • SQL languages- DDL, DML, TCL, DCL

    ✔ Database Objects

    ✔ CREATE TABLE statement
    ✔ Data types
    ✔ Database Objects
    ✔ CREATE TABLE statement
    ✔ Data types
    ✔ Overview of constraint
    ✔ Creating a table using subquery
    ✔ Use the ALTER TABLE statement to add, modify, and drop a column
    ✔ DROP TABLE statement

  • Select Statements

    ✔ Arithmetic expressions and NULL values in the SELECT statement

    ✔ Column aliases
    ✔ Use of concatenation operator, literal character strings, alternative quote operator, and the DISTINCT keyword
    ✔ DESCRIBE command

  • Functions and sorting data

    ✔ Sorting rows using ORDER BY clause

    ✔ SQL row limiting clause in a query
    ✔ Describe the differences between single row and multiple row functions
    ✔ Manipulate strings with character function in the SELECT and WHERE clauses
    ✔ Manipulate numbers with the ROUND, TRUNC and MOD functions
    ✔ Perform arithmetic with date data
    ✔ Manipulate dates with the date functions

  • SQL languages- DDL, DML, TCL, DCL

    ✔ Database Objects

    ✔ CREATE TABLE statement
    ✔ Data types
    ✔ Database Objects
    ✔ CREATE TABLE statement
    ✔ Data types
    ✔ Overview of constraint
    ✔ Creating a table using subquery
    ✔ Use the ALTER TABLE statement to add, modify, and drop a column
    ✔ DROP TABLE statement

  • Constraints and SET Operators

    ✔ Managing constraints

    ✔ TYPES of Constraints
    ✔ ON DELETE Cascade option
    ✔ Set Operators - UNION , UNION ALL, INTERSECT, MINUS
    ✔ ORDER BY clause in set operations

  • Conversion Functions and Conditional Expressions

    ✔ Describe implicit and explicit data type conversion

    ✔ Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions
    ✔ Apply the NVL, NULLIF, and COALESCE functions to data
    ✔ Conditional Expressions
    ✔ Group Functions
    ✔ Aggregate Functions
    ✔ Grouping Rows (GROUP BY and HAVING clause)

  • Joins and Sub-Queries

    ✔ Introduction to JOINS

    ✔ Natural, Self-Join, Outer, Cross/Cartesian Joins
    ✔ Single Row subqueries
    ✔ Multiple row subqueries
    ✔ Correlated subqueries
    ✔ EXISTS and NOT EXISTS operators
    ✔ Subqueries with the SELECT, INSERT, UPDATE, and DELETE statements
    ✔ Inline Views

  • Views, Sequences and Synonyms

    ✔ Why Views

    ✔ View TYPES
    ✔ Sequences and its use
    ✔ Synonyms - private and public

  • Loadind and Unloading data from /to files

    ✔ SQL*Loader

    ✔ DBMS_ErrorLog
    ✔ Loading files ti DB from CSV, TXT
    ✔ External tables
    ✔ Spool files to txt, html, CSV

  • Indexes

    ✔ Btree , Bitmap, Function Based

    ✔ Where and how to use of indexes
    ✔ Forcing index to get used
    ✔ Composite indexes
    ✔ user_indexes, user_ind_columns, user_ind_expressions

  • User Creation and Privileges

    ✔ Introduction to tablespace

    ✔ User creation
    ✔ Grant and revoke privileges
    ✔ Object and system privileges
    ✔ GRANT and ADMIN options

  • Partitions

    ✔ Range, List , hash, Composite

    ✔ Interval, reference, virtual
    ✔ Partition indexes
    ✔ Global Vs Local indexes
    ✔ parallelism and partition Pruning

  • Materialized Views

    ✔ Materialized views

    ✔ Materialized view logs
    ✔ Refreshing materialized views
    ✔ Fast refresh and complete refresh
    ✔ Query rewrite

  • SQL - Tuning

    ✔ Optimizer
    ✔ finding Long running SQLs
    ✔ About Statistics
    ✔ Fragmentation / Defragmentation
    ✔ Joining Methods
    ✔ Using Hints
    ✔ Reading Execution plan
    ✔ Wait Events
    ✔ Locks Vs Deadlocks
    ✔ real World Examples for Tuning

  • Exp & Imp

    ✔ Exp
    ✔ imp
    ✔ Schema/table refresh
    ✔ compiling invalid Objects
    ✔ Case studies on real world examples

  • Dictionary Views

    ✔ user_tables, user_indexes
    ✔ user_tab_columns, user_constraints
    ✔ user_cons_columns, user_objects
    ✔ user_views, user_sequences
    ✔ user_synonyms,user_Segments
    ✔ user_tab_privs, user_sys_privs
    ✔ user_role_privs, user_ind_columns
    ✔ user_indexes, user_ind_columns,user_ind_expressions
    ✔ user_tab_partitions, user_tab_subpartitions
    ✔ user_ind_partitions, user_ind_subpartitions

Oracle Database administration

DBA - ORACLE

ORACLE Database Administration

Oracle Database Administration (DBA) is a critical role in managing and maintaining Oracle databases. DBAs are responsible for ensuring the availability, performance, and security of databases, as well as performing backups, recovery, and troubleshooting. This section covers the essential tasks and responsibilities of an Oracle DBA, including installation, configuration, monitoring, and performance tuning.

  • Preparing Environment

    ✔ Product and Editions
    ✔ Release 5 values
    ✔ Licensing
    ✔ OLAP/OLTP
    ✔ Tier Architecture
    ✔ Operating System
    ✔ Databases
    ✔ Future of DBA

  • Linux for Oracle DBA

    ✔ Preparing Environment
    ✔ Linux Installation
    ✔ Oracle database installation
    ✔ Silent mode installation
    ✔ Automatic Startup and Shutdown
    ✔ Xming

  • Database Concepts

    ✔ Architecture
    ✔ Query Flow
    ✔ SGA
    ✔ PGA
    ✔ BG Process
    ✔ Startup and Shutdown
    ✔ Manual db creation
    ✔ Startup & Shutdown
    ✔ Dbca Creation
    ✔ Controlfile
    ✔ Logfile
    ✔ Archive logfile
    ✔ Manage Tablespaces and Datafiles
    ✔ Storage parameters
    ✔ Space parameters
    ✔ DBMS_STATS
    ✔ Undo
    ✔ Temp
    ✔ Partition
    ✔ Fragmentation
    ✔ Flashback
    ✔ Index
    ✔ Roles and Profiles
    ✔ Dbms Jobs and Scheduler

  • Introduction of Backup

    ✔ Umb Backup
    ✔ Umb Cloning
    ✔ Umb Recover
    ✔ System
    ✔ Undo
    ✔ Logfile
    ✔ Datafile

  • Tns/ Listener

    ✔ DB Link
    ✔ Materialized View

  • Logical Backup

    ✔ Export Parameter
    ✔ Import Parameter
    ✔ Exp Cloning
    ✔ Expdp Parameter
    ✔ Impdp parameter
    ✔ Datapump Cloning

  • Rman Introduction

    ✔ Configuration
    ✔ Commands
    ✔ Backup
    ✔ Rman Cloning
    ✔ Catalog Cloning
    ✔ No catalog Cloning
    ✔ Active Cloning
    ✔ Rman recovery
    ✔ PTTR
    ✔ Incremental Backup & Recovery

  • Introduction of Tuning

    ✔ Sql Tuning
    ✔ TKprof
    ✔ Stats Pack
    ✔ ASH
    ✔ ADDM
    ✔ AWR
    ✔ Wait events

  • Utilities

    ✔ Nid
    ✔ Cscan
    ✔ Log miner
    ✔ Orapwd
    ✔ Dbv
    ✔ Oerr

  • Patches And Upgradation

    ✔ Opatch utilities
    ✔ Version Patch
    ✔ CPU/PSU Patching
    ✔ Bundle Patching
    ✔ Interim Patches
    ✔ Upgrading database from 12c to 19c

  • Introduction of Data Guard

    ✔ Architecture
    ✔ Configuration of Physical standby
    ✔ Physical to Logical Conversion
    ✔ Switchover
    ✔ Failover
    ✔ Dgmgrl
    ✔ Active Standby database

  • Introduction of ASM

    ✔ Asm Architecture
    ✔ Bg process
    ✔ Asm with grid installation
    ✔ Adding and Deleting Disks
    ✔ Creating database files using asm
    ✔ Asm to Non-asm
    ✔ Non-asm to Asm
    ✔ Asm disk rebalancing operation
    ✔ Disk failure

Oracle Real Application Cluster Administration (RAC)

RAC DBA - ORACLE

ORACLE RAC Database Administration

Oracle Real Application Clusters (RAC) is a high-availability solution that allows multiple instances of Oracle Database to run on different servers while accessing a shared database. This section covers the essential tasks and responsibilities of an Oracle RAC DBA, including installation, configuration, monitoring, and performance tuning in a clustered environment.

  • Prerequisite

    ✔ Linux Installation in Virtual Box
    ✔ IP Configure for RAC in Linux Machine
    ✔ Storage options to maintain RAC databases
    ✔ NAS configure for RAC storage

  • Introduction to Grid Infrastructure

    ✔ What is a Cluster?
    ✔ What is a Flex Cluster?
    ✔ Clusterware Characteristics
    ✔ Oracle Clusterware
    ✔ Hardware and Software Concepts (High level)
    ✔ Shared Storage Overview

  • Oracle Clusterware Architecture

    ✔ Cluster Storage Requirements
    ✔ Clusterware Initialization and OHASD
    ✔ Clusterware Process Architecture
    ✔ Location Independent Names, Addresses and Name Resolution (GNS, SCAN, VIP..)

  • Grid Infrastructure Pre-Installation Tasks

    ✔ Shared Storage for Oracle Clusterware
    ✔ Checking System Requirements
    ✔ Single Client Access Name for the Cluster
    ✔ Redundant Interconnect Usage
    ✔ Kernel Requirements
    ✔ Groups and Users
    ✔ Shell Settings
    ✔ Oracle Validated Configuration

  • Installing Grid Infrastructure

    ✔ Installing Oracle Grid Infrastructure
    ✔ Verifying the Oracle Clusterware Installation

  • RAC Utilities

    ✔ The ocrcheck Utilitiy
    ✔ The ocrdump Utility
    ✔ The crs_stat Utility
    ✔ The crsctl Utility
    ✔ The Server Control (SRVCTl) Utility
    ✔ SRVCTL ADD
    ✔ SRVCTL CONFIG
    ✔ SRVCTL ENABLE and DISABLE
    ✔ SRVCTL GETENV
    ✔ SRVCTL MODIFY
    ✔ SRVCTL RELOCATE
    ✔ SRVCTL REMOVE
    ✔ SRVCTL START
    ✔ SRVCTL STOP

  • Managing Cluster Nodes

    ✔ About Oracle Clusterware
    ✔ Backing Up and Recovering Voting Disks
    ✔ Adding and Removing Voting Disks
    ✔ The OCR
    ✔ Changing the OCR Configuration
    ✔ Adding and Removing an OCR Location
    ✔ backing Up and Recovering the OCR
    ✔ Restoring from Automatic OCR Backups
    ✔ Moving or Replacing the OCR
    ✔ Repairing the OCR Configuration
    ✔ Troubleshooting the OCR
    ✔ Adding Oracle Clusterware Homes
    ✔ Prerequisites for Running addNode.sh
    ✔ Adding a Node with addNode.sh
    ✔ Configuring the node role
    ✔ Removing a Node from the Cluster

  • RAC Service Management

    ✔ Overview or Services
    ✔ Types of Servicers
    ✔ Creating Services with DBCA
    ✔ Creating SErvices with SRVCTL
    ✔ Preferred and Available Instances for Services
    ✔ Using Services
    ✔ Managing Services
    ✔ Service Views
    ✔ Tracing with Services

  • Failover

    ✔ Transparent Application Failover(TAF)
    ✔ Client-Side vs Server-Side TAF
    ✔ Configuring TAF on the client
    ✔ Configuring TAF on the Server
    ✔ Using SRVCTL to configure TAF

  • Traditional Clusterware Management

    ✔ Oracle Clusterware startup and shutdown
    ✔ Administering the Oracle Cluster Registry Disk file
    ✔ Network Administration
    ✔ What-If Command Evaluation
    ✔ Clusterware Admin Tools Review

  • Patching Grid Infrastructure

    ✔ Types of Patches
    ✔ Obtaining Oracle Clusterware Patches
    ✔ Rolling Patches
    ✔ OPatch Overview
    ✔ Installing a Rolling Patch with OPatch

  • Troubleshooting Oracle Clusterware

    ✔ Diagnostic Framework Support for CRS
    ✔ Cluster Health Monitor Enhancements Overview
    ✔ Component level checks – cluvfy with -comp
    ✔ Troubleshooting Node Evictions
    ✔ Log files and Diagnostic Collection
    ✔ The column Utility

Contact

Need Help? Contact Us

Address

A108 Adam Street, New York, NY 535022

Call Us

+1 5589 55488 55

Email Us

info@example.com

Loading
Your message has been sent. Thank you!