Home
Databases
Oracle SQL Bootcamp
Getting Started
SQL vs PL/SQL vs SQL*Plus
SQL Developer Setup
Connecting to Oracle
Basic SQL Syntax
SELECT Statement
FROM Clause
WHERE Clause
ORDER BY
DISTINCT Keyword
Arithmetic & Aliases
Filtering & Expressions
IN, NOT IN, BETWEEN, LIKE
IS NULL vs = NULL
Logical Operators: AND, OR, NOT
CASE and DECODE
NVL, NVL2, COALESCE, NULLIF
GREATEST and LEAST
Aggregation & Grouping
GROUP BY and HAVING
Aggregate Functions
ROLLUP and CUBE
GROUPING Functions
GROUP BY Clause
HAVING Clause
SQL Functions
String Functions
Number Functions
Date Functions
Conversion Functions
Joins
INNER and OUTER Joins
Self and Cross Joins
Join Conditions & Syntax
Subqueries
Scalar & Row Subqueries
Correlated Subqueries
IN, EXISTS, ANY, ALL
Set Operations
UNION vs UNION ALL
INTERSECT and MINUS
DML
INSERT
UPDATE
DELETE
MERGE
TRUNCATE
DELETE Statement
DDL
CREATE, ALTER, DROP
RENAME, COMMENT
Constraints
Primary, Unique, Foreign Keys
Check & Default
Indexes
Types of Indexes
Function-Based & Invisible Indexes
Transactions
COMMIT, ROLLBACK, SAVEPOINT
Locks & Deadlocks
Analytical Functions
RANK, DENSE_RANK, ROW_NUMBER
LAG, LEAD
FIRST_VALUE, LAST_VALUE
NTILE, PERCENT_RANK, CUME_DIST
CTE and WITH Clause
Recursive CTEs
Advanced SQL
PIVOT and UNPIVOT
MODEL Clause
Hierarchical Queries
Views
Simple and Complex Views
Materialized Views
PL/SQL Basics
Anonymous Blocks
Loops and IF
Exception Handling
Security & Access
GRANT and REVOKE
Roles and Privileges
Performance & Tuning
EXPLAIN PLAN & AUTOTRACE
Hints and Bind Variables
Statistics & Cost Estimation
Oracle-Specific Features
ROWNUM vs ROW_NUMBER()
FETCH FIRST ROWS
DUAL Table and Sequences
Flashback Queries
MySQL Bootcamp
Introduction to MySQL
Installing and Connecting MySQL
MySQL vs Other Databases
DDL and Table Operations
CREATE and DROP Database/Table
ALTER, RENAME, TRUNCATE
MySQL Data Types Overview
Keys and Constraints
DML: Data Manipulation
INSERT Data
UPDATE Data
DELETE and REPLACE
INSERT Statement
UPDATE Statement
SELECT Queries
WHERE Clause & Filtering
Sorting, Limiting, Aliases
ORDER BY Clause
LIMIT and OFFSET
Built-in Functions
String Functions
Numeric Functions
Date & Time Functions
Control Functions (IF, CASE)
Aggregation & Grouping
GROUP BY and HAVING
ROLLUP and Advanced Aggregation
Joins in MySQL
INNER, LEFT, RIGHT Joins
FULL OUTER and CROSS JOIN
Self Joins and Aliases
Subqueries and Sets
Subquery Types
UNION, INTERSECT, EXCEPT
UNION and UNION ALL
Views and Indexes
Creating & Using Views
Indexing & Performance
Transactions & Locks
COMMIT, ROLLBACK, SAVEPOINT
Isolation Levels & Locking
Data Integrity
Primary & Foreign Keys
NOT NULL, UNIQUE, DEFAULT
CHECK Constraints
Performance Tuning
EXPLAIN & Query Analysis
Index Optimization
User Management & Security
CREATE USER & GRANT
Roles and Permissions
User Management
Stored Procedures & Triggers
Stored Procedures & Functions
Stored Procedures
Triggers & Events
Import/Export & Backup
mysqldump & Restore
Importing CSV/Excel
MySQL Integration
MySQL with PHP
MySQL with Python
MySQL with Java
MySQL with Node.js
Replication & HA
Master-Slave, GTID
Semi-Sync & Read Replicas
Cloud & Hosting
AWS RDS & Google SQL
phpMyAdmin & cPanel
PL/SQL Bootcamp
Introduction to PL/SQL
What is PL/SQL?
Benefits of PL/SQL
PL/SQL vs SQL
PL/SQL Environment Setup
Using SQL Developer for PL/SQL
Anonymous Blocks
Executing PL/SQL in SQL*Plus / SQL Developer
PL/SQL Basics
PL/SQL Syntax
Variables and Data Types
Operators
Comments in PL/SQL
Control Structures
IF-THEN-ELSE
CASE Statement
LOOP, WHILE, FOR
Cursors
Implicit vs Explicit Cursors
Cursor FOR Loops
Parameterized Cursors
Cursor Attributes
Exception Handling
Predefined Exceptions
User-Defined Exceptions
WHEN OTHERS
Procedures and Functions
Creating Procedures
Creating Functions
IN, OUT, IN OUT Parameters
Packages
Package Specification and Body
Public vs Private Elements
Initializing in Packages
Triggers
BEFORE and AFTER Triggers
ROW vs STATEMENT Level Triggers
INSTEAD OF Triggers
Records and Collections
RECORD Type
INDEX BY Tables
Nested Tables
VARRAYS
Dynamic SQL
EXECUTE IMMEDIATE
DBMS_SQL Package
Bulk Operations
FORALL
BULK COLLECT
Performance Considerations
Advanced Topics
Autonomous Transactions
PRAGMA Directives
DBMS_OUTPUT and UTL Packages
Real-World Examples
Logging Tables
Audit Triggers
Email Notifications
Validation APIs
Best Practices & Performance
Naming Conventions
Code Modularity
Exception Handling Tips
Profiling and Debugging
SQL
EBS
Fusion
AP
AR
Cross References
Customer Information
EFF
GL
INV
ESS
OM
Organization Details
Pricing
Tax
miss
Posts in: MODEL Clause
MODEL Clause
Use the MODEL clause to perform complex, spreadsheet-like calculations directly within SQL.
Read More →