CERTIFICATE IN ORACLE SQL AND PLSQL

Duration: 4 MONTHS

Course Syllabus

  • Writing Basic SQL SELECT Statements
  • Restricting and Sorting Data
  • Single-Row Functions
  • Displaying Data from Multiple Tables
  • Displaying Data from Multiple Tables
  • Aggregating Data Using Group Functions
  • Manipulating Data
  • Creating and Managing Table
  • Including Constraints
  • Creating Views
  • Other Database Objects
  • Controlling User Access
  • Using SET Operators
  • Enhancements to the GROUP BY Clause
  • Extensions to DML and DDL Statements

PLSQL 

Programming in PL/SQL

  • Creating and Running PL/SQL Code
  • Loop Basics
  • Exception Handlers
  • Strings
  • Numbers
  • Records
  • Data Retrieval
  • Procedures, Functions, and Parameters
  • Packages
  • Triggers

Read More

Eligibility

.


Back to top