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

Postgres SQL - for Developers

SQL - Postgres

Postgresql SQL - Structured Query Language

SQL (Structured Query Language) is a standard programming language used to manage and manipulate relational databases. It is widely used for querying, inserting, updating, and deleting data in databases. SQL is essential for database developers and administrators to interact with databases effectively. This section covers the fundamental concepts and commands of SQL, including data definition, data manipulation, and data control.

  • Introduction to Postgres SQL

    ✔ Connecting psql

    ✔ Logging in pgadmin
    ✔ Connecting to Database on windows and Linux

  • Querying Data

    ✔ Select
    ✔ Column aliases
    ✔ Order By
    ✔ Select Distinct

  • Filtering Data

    ✔ Where
    ✔ AND operator
    ✔ OR operator
    ✔ Limit
    ✔ Fetch
    ✔ In
    ✔ Between
    ✔ Like
    ✔ Is Null

  • 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

  • Joining Multiple Tables

    ✔ Joins
    ✔ Table aliases
    ✔ Inner Join
    ✔ Left Join
    ✔ Self-join
    ✔ Full Outer Join
    ✔ Cross Join
    ✔ Natural Join

  • Grouping Data

    ✔ Managing constraints

    ✔ Group By
    ✔ Having

  • Set Operations

    ✔ Union
    ✔ Intersect
    ✔ Except

  • Grouping sets, Cubes, and Rollups

    ✔ Grouping Sets
    ✔ Cube
    ✔ Rollup

  • Subquery

    ✔ Subquery
    ✔ Correlated Subquery
    ✔ ANY
    ✔ ALL
    ✔ EXISTS

  • Common Table Expressions

    ✔ PostgreSQL CTE
    ✔ Recursive query using CTEs

  • Modifying Data

    ✔ Insert
    ✔ Insert multiple rows
    ✔ Update
    ✔ Update join
    ✔ Delete
    ✔ Upsert

  • Transactions

    ✔ PostgreSQL Transactions

  • Import & Export Data

    ✔ Import CSV file into Table
    ✔ Export PostgreSQL Table to CSV file

  • Managing Tables

    ✔ Data types
    ✔ Create a table
    ✔ Select Into & Create table as
    ✔ Auto-increment column with SERIAL
    ✔ Sequences
    ✔ Identity column
    ✔ Alter table
    ✔ Rename table
    ✔ Add column
    ✔ Drop column
    ✔ Change column data type
    ✔ Rename column
    ✔ Drop table
    ✔ Truncate table
    ✔ Temporary table
    ✔ Copy a table

  • PostgreSQL Constraints

    ✔ Primary key
    ✔ Foreign key
    ✔ DELETE CASCADE
    ✔ CHECK constraint
    ✔ UNIQUE constraint
    ✔ NOT NULL constraint
    ✔ DEFAULT constraint

  • PostgreSQL Data Types in Depth

    ✔ Boolean
    ✔ CHAR, VARCHAR, and TEXT
    ✔ NUMERIC
    ✔ DOUBLE PRECISION
    ✔ REAL
    ✔ Integer
    ✔ DATE
    ✔ Timestamp
    ✔ Interval
    ✔ TIME
    ✔ UUID
    ✔ Array
    ✔ hstore
    ✔ JSON
    ✔ User-defined data types
    ✔ Enum
    ✔ XML
    ✔ BYTEA
    ✔ Composite Types

  • Conditional Expressions & Operators

    ✔ CASE
    ✔ COALESCE
    ✔ NULLIF
    ✔ CAST

PL/pgSQL - for Developers

PL/pgSQL - Postgres

PL/pgSQL - Procedural Language

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

  • PL/pgSQL Introduction

    ✔ Introduction to PostgreSQL PL/pgSQL
    ✔ Dollar-quoted string constants
    ✔ Block Structure

  • Variables & Constants

    ✔ Variables
    ✔ Select into
    ✔ Row type variables
    ✔ Record type variables
    ✔ Constants

  • Reporting messages and errors

    ✔ Raising errors and reporting messages
    ✔ Assert

  • Control Structures

    ✔ If statement
    ✔ Case statements
    ✔ Loop statements
    ✔ While loop
    ✔ For loop
    ✔ Exit
    ✔ Continue

  • User-defined Functions

    ✔ Create Function
    ✔ Function parameter modes
    ✔ Function overloading
    ✔ Functions that return a table
    ✔ Functions that return one or more rows
    ✔ Drop function

  • Exception Handling

    ✔ Handling exceptions

  • Stored Procedures and functions

    ✔ Create procedure and function
    ✔ Drop procedure and function
    ✔ Stored procedures with INOUT parameters

  • Cursors

    ✔ Types of Cursors

  • Trigger Functions

    ✔ Trigger procedures using PL/pgSQL