SQL & Oracle

SQL & Oracle

  • Introduction to Databases
    • What is Database?
    • Difference between SQL & Oracle
    • DBMS vs RDBMS
  • SQL Basics
    • Data Types
    • DDL, DML, DCL, TCL commands
    • Creating & Modifying Tables
  • SQL Queries
    • SELECT Statements
    • WHERE Clause
    • ORDER BY, GROUP BY, HAVING
  • Constraints
    • Primary Key
    • Foreign Key
    • Unique, Check & Not Null
  • Joins & Subqueries
    • INNER JOIN, LEFT JOIN, RIGHT JOIN
    • Self Join
    • Nested Subqueries
  • Functions
    • Aggregate Functions (SUM, AVG, COUNT)
    • String Functions
    • Date & Conversion Functions
  • PL/SQL (Oracle)
    • Introduction to PL/SQL
    • Variables & Data Types
    • Control Structures (IF, LOOP)
  • PL/SQL Programming
    • Procedures
    • Functions
    • Packages
  • Triggers & Cursors
    • Implicit & Explicit Cursors
    • Row-level & Statement-level Triggers
  • Database Security & User Management
    • Creating Users
    • Grant & Revoke Permissions
    • Roles & Privileges
  • Backup & Recovery
    • Export & Import
    • Database Backup Strategies
    • Recovery Techniques
  • Mini Projects
    • Student Management System
    • Library Database
    • Inventory Management

Features of the course


Advance Lab

Excellent Trainers

Reasonable Fees

Apply Now