Boot Camp

Advance SQL

Boot Camp
Session Start
Free Trial
January 13, 2024 3
Get All Classes
Session Start
Pay in Installment
Full Payment
Discount
January 13, 2024 $150.00 Monthly
$500.00
Discount on Call
Course Includes
Introducing SQL
  • What is SQL (Structured Query Language)?
  • Role of SQL in RDBMS
  • Oracle data types
Data Definition Language
  • Create
  • Alter
  • Truncate
  • Drop
  • Rename
Data Manipulation Languages
  • Insert
  • Update
  • Delete
  • Merge
Transaction Control Languages
  • Commit
  • Rollback
  • Savepoint
Data Control Languages
  • Grant
  • Revoke
Operators
  • Arithmetic Operators
  • Relational Operators
  • Relation Negation Operators
  • Logical Operators
  • Set Operators (Union, Union All, Intersect, Minus)
Joins
  • Inner Join
  • Left Outer Join
  • Right Outer Join
  • Full Outer join
  • Self Join
Sub Query
  • Single row Subquery
  • Multi row Subquery
  • Correlated Subquery