Getting started with PL/SQL

• What is PL/SQL
• Anonymous Block
• Data Types
• Variables
• Comments
• Constants

Conditional control

• IF statements
• CASE statements
• GOTO
• NULL statement

Iterative processing with loops

• Basic LOOP statement
• Numeric FOR LOOP statement
• WHILE loop
• CONTINUE

Select Into

• SELECT INTO

Exception handlers

• Exception
• Raise exceptions
• Using raise_application_error
• Exception propagation
• Handling other unhandled exceptions

Records

• Record

Cursors

• Cursor
• Cursor FOR LOOP
• Cursor with parameters
• Cursor Variables with REF CURSOR Updatable cursor

Stored procedures and Functions

• Procedure
• Implicit statement results
• Function
• Cursor variables

Packages

• Introduction to the PL/SQL package
• Package specification
• Package body
• Drop Package

Triggers

• Triggers
• Statement-level triggers
• Row-level triggers
• INSTEAD OF triggers
• Disable triggers
• Enable triggers
• Drop Triggers
• How to fix the mutating table error

PL/SQL Collections

• Associative Arrays
• Nested Tables
• VARRAY

Introduction

• Arrays Functions and Operators

Understanding Basic PostgreSQL Syntax

• Basic SQL Commands - UPDATE
• Basic SQL Commands – DELETE

Querying Data with the SELECT Statement

• Wildcards (%, _)
• The SELECT List
• SELECT List Wildcard (*)
• The FROM Clause
• How to Constrain the Result Set
• DISTINCT and NOT DISTINCT

Arrays Functions and Operators

• array_append
• array_cat
• array_lower
• array_to_string
• array_agg
• every, Count, sum, avg
• Array Operators

Filtering Results with the Where Clause

• WHERE Clause
• Boolean Operators
• The AND Keyword
• The OR Keyword
• Other Boolean Operators BETWEEN, LIKE, IN, IS, IS NOT

Shaping Results with ORDER BY and GROUP BY

• ORDER BY
• Set Functions
• Set Function And Qualifiers
• GROUP BY
• HAVING clause

Matching Different Data Tables with JOINs

• Table Aliases
• CROSS JOIN
• INNER JOIN
• OUTER JOINs
• LEFT OUTER JOIN
• RIGHT OUTER JOIN
• FULL OUTER JOIN
• SELF JOIN
• Natural Join

Creating Database Tables

• NULL Values
• PRIMARY KEY
• CONSTRAINT
• ALTER TABLE
• DROP TABLE

PostgreSQL Transactions

• BEGIN, COMMIT, ROLLBACK

PostgreSQL Constraints

• CHECK, UNIQUE, NOT NULL

Introduction

• DBMS and RDBMS concepts

Querying data

• SELECT FROM
• SELECT

Sorting data

• ORDER BY

Filtering data

• WHERE 
• SELECT  DISTINCT
• AND
• OR
• IN 
• NOT IN
• BETWEEN 
• LIKE
• LIMIT
• IS NULL

Joining tables

• Table & Column Aliases
• Joins
• INNER JOIN 
• LEFT JOIN 
• RIGHT JOIN
• CROSS JOIN
• Self-join 

Grouping data

• GROUP BY
• HAVING 
• ROLLUP

Subqueries

• Subquery 
• Derived table
• EXISTS

Set operators

• UNION and UNION ALL 
• INTERSECT
• MINUS

Modifying data in MySQL

• INSERT
• INSERT Multiple Rows
• INSERT INTO SELECT
• INSERT IGNORE
• UPDATE
• UPDATE JOIN
• DELETE
• ON DELETE CASCADE
• DELETE JOIN
• REPLACE
• UPDATE JOIN
• Prepared Statement

MySQL transaction

• Transaction 
• able locking

Managing databases

• Selecting a MySQL database
• CREATE DATABASE
• DROP DATABASE

Working with tables

• MySQL storage engines
• CREATE TABLE 
• AUTO_INCREMENT 
• ALTER TABLE 
• Renaming tables
• Removing a column from a table
• Adding a new column to a table
• DROP TABLE
• Temporary tables
• TRUNCATE TABLE
• Generated columns

MySQL data types

• MySQL data types 
• INT
• DECIMAL
• BIT
• BOOLEAN
• CHAR
• VARCHAR
• TEXT
• DATE
• TIME 
• DATETIME
• TIMESTAMP
• JSON
• ENUM

MySQL constraints

• NOT NULL
• Primary key
• Foreign key
• Disable foreign key checks
• UNIQUE constraint
• CHECK constraint
• DEFAULT
• CHECK constraint emulation

MySQL import & export CSV

• Import CSV File Into MySQL Table
• Export MySQL Table to CSV

• Introduction to MongoDB
• MongoDB Environment Setup
• Features of MongoDB
• Pros & Cons of MongoDB
• Comprehansive Guide
• Why MongoDB should we learn
• The 16 Data Types of MongoDB
• Updating Documents in MongoDB
• Deleting Documents in MongoDB
• Creating a Database in MongoDB
• Dropping a Database in MongoDB
• MongoDB Data Modeling with Document Structure
• Projection in MongoDB and How it Affects Performance
• MongoDB Capped Collection
• Operations Performed on Document
• Backup & Restore Methods
• MongoDB Text Search
• MongoDB RockMongo
• MongoDB GridFS
• MongoDB Regular Expression (regex)
• How to Execute MongoDB in PHP
• MongoDB Vs Hadoop
• Limiting Records in MongoDB with skip()
• MongoDB Indexes and their Types
• MongoDB Relationships & Database Reference
• How to Execute MongoDB in Java
• MongoDB Covered &Analyzing Query
• MongoDB ObjectId& Atomic Operations
• Generate Auto Increment Sequence
• MongoDB Aggregation
• MongoDB Replication &Sharding
• Working of MapReduce in MongoDB

• Introduction to Cassandra
• Cassandra Environment Setup
• Features of Cassandra
• Cassandra Applications
• Cassandra Glossary
• Cassandra Architecture
• Cassandra vs Hadoop
• Cassandra vs MongoDB
• Cassandra vs RDBMS
• Cassandra vs HBase
• 9 Cassandra Shell Commands
• The Data Model in Cassandra
• Cassandra API- References, CQL, Thrift
• 4 Cassandra Monitoring Tools
• Cassandra Clusters and the Cluster Builder
• Cassandra CRUD Operations
• Cassandra Query Language Shell (CQLSH)
• 10 Cassandra Documented Shell Commands
• Data Definition Commands in CQL
• Data Manipulation Commands in CQL
• CQL Clauses- SELECT, WHERE, ORDER BY
• Cassandra Data Types- Built-in, Collection, User-defined
• User-defined Data Types in Cassandra
• Cassandra Collection Data Types- List, Set, Map
• Troubleshooting in Cassandra