!! Exclusive Republic Day Offer Until 28th !!
  info@vedait.in
  +91 - 7733880344

Oracle

  • Introduction to SQL
  • RDBMS Concepts in SQL
  • SQL RDBMS Database System
  • SQL Data Types
  • SQL Clauses- Part 1
  • SQL Clauses- Part 2
  • SQL Operators- Arithmetic, Comparison, Logical
  • SQL Operators- Alias, IN, BETWEEN
  • Expressions in SQL
  • CREATE, DROP, and SELECT Database in SQL
  • CREATE, ALTER & DROP Table in SQL
  • SQL Comments: Single- and Multi-line
  • SQL Primary & Foreign Keys
  • SQL Statements
  • SQL DISTINCT Keyword
  • SQL Constraints
  • DEFAULT and CHECK Constraints in SQL
  • COUNT Function in SQL Server
  • SUM Function in SQL Server
  • SQL LIKE Clause
  • Wildcard Characters in SQL
  • TRUNCATE & ALTER Commands
  • Null Values and the UNION Clause in SQL
  • SQL Date & Time Functions
  • Joins in SQL- Inner, Left, Right, Full
  • SQL Null Functions
  • SQL Sequences
  • SQL Subqueries
  • SQL Query Optimization Tools
  • SQL Duplicate Records
  • Stored Procedures in SQL
  • SQL Cursors and their Types
  • SQL Indexes & their Types
  • SQL Server Transactions
  • SQL Auto Increment Field
  • SQL Injection (SQLi)
  • SQL Database Tuning Tutorial
  • Pseudocolumn in Oracle SQL
  • Embedded SQL

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

NOSQL Database

  • 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
Chat on WhatsApp