Prashant Munshi

Practical SQL Masterclass || (Visit description box for more info)

MySQL What is DBMS || (Visit description for more info)

MySQL What is RDBMS? || (Visit description for more info)

MySQL Introduction to SQL || (Visit description for more info)

MySQL Operator OR || (Visit description for more info)

MySQL Pipe Operator || (Visit description for more info)

MySQL Column Alias || (Visit description for more info)

MySQL Temporal Operator INTERVAL || (Visit description for more info)

MySQL EXISTS Operator || (Visit description for more info)

MySQL Filtering INNER JOIN Results || (Visit description box for more info)

MySQL Group Functions Introduction || (Visit description box for more info)

MySQL CREATE TABLE Statement || (Visit description box for more info)

SQL Subquery - Correlated subquery in SQL - Oracle subqueries - NULL subquery in SQL

Authid in Oracle - Definers rights in Oracle - Invoker rights in PL SQL - Authid in PL SQL

Constraints in DBMS - Constraints in SQL - Integrity Constraints in DBMS - Constraints in Oracle

SQL Logical Operators - AND operator in SQL - OR operator in SQL

Column Object - Object Type in Oracle - Objects in Oracle - Oracle Objects - PL SQL Objects

Sysdate Oracle - Sysdate SQL - Pseudo columns in Oracle - Pseudo Column - Pseudo columns in SQL

SQL Distinct - Distinct Query Example - SQL Order By clause - SQL Order By

Initially Deferred Constraint | Deferrable Constraint in Oracle | Deferred Constraints Oracle

System Triggers in Oracle - Trigger in Oracle - Trigger in PL SQL - Trigger in DBMS

SQL Single Row Functions Part 4 - SQL Functions Tutorial with examples - SQL Single Row Functions

Normalization in DBMS : Normalization - Normalization in Database with Example - Normal Forms

Record %ROWTYPE variable in oracle pl sql example - PL SQL record type in oracle - Oracle rowtype

SQL decode vs case - Decode and Case difference - Difference between Case and Decode

PL SQL Function - User Defined Functions in PLSQL - Functions in Oracle - Create function in PLSQL

Ref Cursor in Oracle PL/SQL - Strong & Weak Ref Cursor - Sys_refcursor - Types of Ref Cursors

Stored Procedure - Execute Privilege - PL/SQL Stored Procedure Privileges - Procedure in PL SQL

PL/SQL Forward Declarations - What is Forward Declaration in Oracle - What is Forward Declaration

Pl Sql Cursor Subqueries - Embedded Cursor in PL SQL - Nested Cursor Expression - PL/SQL Cursors

PL/SQL Weak Ref Cursor in Oracle Database - PL/SQL Tutorial - Ref Cursor in Oracle

SQL AND, OR, NOT, BETWEEN Operators - Oracle SQL - Learn SQL - Oracle SQL Tutorial

MySQL Single Row INSERT Operation || (Visit description for more info)

PL/SQL Conditional Statements Example - Case Statements in PL SQL - If Then Else in PL SQL

SQL Subqueries Tutorial - SQL Subqueries for Beginners - SQL Subqueries

Relational Algebra Tutorial for Beginners - Relational Algebra Model in DBMS - Relational Calculus

Oracle Built in Functions - SQL Functions Tutorial with examples- SQL Single Row Functions

SQL Joins - SQL Joins With Examples - SQL Joins Tutorial for Beginners

SQL set operations - SQL set operators tutorial - Set operators in Oracle

PL SQL Procedure - Stored Procedures in PL/SQL - Stored Procedure in Oracle

PL SQL Object Inheritance - (Visit description for more info)

inner joins vs outer joins - inner join left join right join full outer join

Implicit cursors - Implicit Cursor Example - Implicit Cursors in PL SQL - Where Current of

SQL Create Table - Create Table in SQL Oracle - Create Table in Oracle

Object Types in Oracle - (Visit description for more info)

Cursor For Loop in PL/SQL - Explicit Cursor - Parameterized Cursors - Explicit Cursor Orcle

SQL NULL - SQL NULL values - SQL NULL functions - SQL NVL function - SQL NVL Oracle

PL/SQL Sys_Ref Cursor in Oracle Database - Ref Cursor and Sys_RefCursor in Oracle Example

Oracle Built in Functions part 2 - SQL Functions Tutorial with examples- SQL Single Row Functions

PL/SQL exception handling - (Visit description for more info)

PL SQL For Loop - PL SQL While Loop Example - Loops in Oracle PL SQL - PL SQL Loop

Object Type in Oracle - Oracle Object Type - Object Oriented Database - Object Oriented Programming

Object Tables - Row Objects - Object Type in Oracle - Objects in Oracle - Oracle Objects

Foreign key integrity Constraint - Type of Constraint in Database

SQL delete vs truncate - delete and truncate difference - SQL delete vs truncate vs drop

PL SQL Packages - Initialization - Packages in PL SQL - Introduction to PL/SQL Packages

SQL Single Row Functions Part 3 - SQL Functions Tutorial with examples - SQL Single Row Functions

Oracle Architecture Tutorial for Beginners - Oracle DBA Tutorial for Beginners

Super Key in DBMS - Candidate Key in DBMS - Primary key - DBMS Keys