Courses & Certifications

Courses & Certifications PL SQL

PL SQL

Oracle Database 12c: SQL and PL/SQL Fundamentals

Introduction

  • Retrieve Data using the SQL SELECT Statement
  • Restricted and Sorted Data
  • Usage of Single-Row Functions to Customize Output
  • Converting Functions and Conditional Expressions
  • Aggregated Data Using the Group Functions
  • Display Data From Multiple Tables
  • Usage of Subqueries to Solve Queries
  • SET Operators
  • Data Handling
  • DDL Statements to Create and Manage Tables
  • Other Schema Objects
  • Introduction to PL/SQL
  • PL/SQL Identifiers
  • Write Executable Statements
  • Interaction with the Oracle Server
  • Control Structures
  • Usage of Composite Data Types
  • Explicit Cursors
  • Exception Handling
  • Stored Procedures and Functions
  • Online Classes
  • 1 to 1 Advantage
  • Flexible Dates
  • Flexible Timings
  • Placement Support
  • PL SQL
  • Price: ₹25000