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

PL/SQL - for Developers

PL/SQL - ORACLE

PL/SQL - Procedural Language / Structured Query Language

PL/SQL is Oracle's procedural extension for SQL. It combines the data manipulation power of SQL with the procedural capabilities of a programming language. PL/SQL allows you to write complex database applications that can handle large volumes of data efficiently. PL/SQL is a block-structured language, which means that code is organized into blocks that can be nested within each other.

  • Introduction to PLSQL

    ✔ PL/SQL Engine Architecture

    ✔ Structure Of PL/SQL
    ✔ The PLSQL Development Environments
    ✔ Executing SQL Statements
    ✔ Creating PLSQL Blocks
    ✔ Save to SQL Scripts
    ✔ Executing from SQL Scripts
    ✔ Creating Anonymous Blocks
    ✔ Generate Output from a PL/SQL Block

  • Declaring PLSQL variables

    ✔ Use of variables
    ✔ What are Identifiers
    ✔ Declaring PLSQL Variables
    ✔ Types of Variables
    ✔ Datatypes
    ✔ %TYPE Attribute
    ✔ Bind Variables
    ✔ Printing Bind variables
    ✔ Substitution Variables
    ✔ Using Define for variables

  • Writing PLSQL Codes

    ✔ PLSQL Block Syntax
    ✔ SQL Functions in PLSQL
    ✔ Nesting Functions
    ✔ Datatype Conversion
    ✔ Nested Blocks
    ✔ Operators
    ✔ Commenting Codes

  • Interacting with database

    ✔ SELECT statements in PLSQL
    ✔ DMLS using PLSQL Code
    ✔ SQL Cursor
    ✔ Implicit Cursors Attributes

  • Control Statements

    ✔ Controlling flow of execution
    ✔ Types of IF Statements
    ✔ CASE Statements
    ✔ Handling Nulls
    ✔ Interactive Control Statements

  • Looping Structures

    ✔ FOR Loop
    ✔ WHILE Loops
    ✔ GOTO Statements
    ✔ CONTINUE Statements
    ✔ Nested Loops and Labels

  • Composite Datatypes

    ✔ PLSQL records
    ✔ %ROWTYPE Attribute
    ✔ DMLs using %ROWTYPE
    ✔ Associative Arrays
    ✔ Using INDEX BY table Structure
    ✔ INDEX BY table of records

  • Explicit Cursors

    ✔ Cursors
    ✔ Controlling explicit Cursors
    ✔ Fetching data from cursors
    ✔ Cursors and records
    ✔ Closing cursors
    ✔ Cursor FOR loop
    ✔ Cursor Attributes
    ✔ Parameterized cursors
    ✔ For Update
    ✔ Cursor with subqueries
    ✔ Where CURRENT of

  • Exceptions

    ✔ What is Exception?
    ✔ Handling Exceptions
    ✔ Types of Exception
    ✔ Predefined Errors
    ✔ Non-predefined Exceptions
    ✔ User Defined Exceptions
    ✔ RAISE_APPLICATION_ERROR
    ✔ Handling Exceptions in block
    ✔ SQLCODE and SQLERRM in PLSQL

  • Database Triggers

    ✔ Types of triggers
    ✔ Creating DML Triggers
    ✔ Statement Vs Rows Level triggers
    ✔ Using OLD and NEW Qualifiers
    ✔ INSTEAD OF Triggers
    ✔ AUTONOMOUS Transaction
    ✔ Enabling and Disabling triggers
    ✔ Compiling Triggers
    ✔ Dropping Triggers
    ✔ System Level Triggers
    ✔ LOGON and LOGOFF triggers

  • Procedures and Functions

    ✔ Creating procedures
    ✔ IN, OUT, IN OUT Parameters
    ✔ Passing parameters to functions
    ✔ Calling Functions from PLSQL
    ✔ Invoking procedures in PLSQL
    ✔ Viewing Codes using Views
    ✔ Viewing USER_SOURCE
    ✔ Viewing USER_ERRORS
    ✔ Viewing SHOW ERRORS
    ✔ Viewing USER_OBJECTS
    ✔ Compiling invalid Objects

  • Create Packages

    ✔ Structures of Package
    ✔ What is STANDARD Package
    ✔ Public and Private Constructs
    ✔ Creating Package Specification
    ✔ Creating package Body
    ✔ Removing package
    ✔ Granting and Revoking permissions
    ✔ PLSQL Tables and records in packages

  • Oracle Supplied packages

    ✔ Native Dynamic SQL
    ✔ EXECUTE IMMEDIATE
    ✔ EXECUTE IMMEDIATE using variables
    ✔ DBMS_JOBS
    ✔ DBMS_SCHEDULERS

  • Using DDLS in PLSQL

    ✔ Running / Breaking Jobs
    ✔ UTL_FILE
    ✔ Creating Directory

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!