Oracle Database: SQL & PL/SQL Development

Categories: Oracle
Wishlist Share

About Course

Write efficient SQL and PL/SQL on Oracle Database: queries, joins, procedures, packages, triggers and performance basics.

Who this training is for

  • Developers and analysts
  • Oracle application teams

Syllabus

  1. Module 1: SQL basics — SELECT, joins, functions
  2. Module 2: Advanced SQL — Subqueries, analytic functions
  3. Module 3: PL/SQL fundamentals — Blocks, variables, control flow
  4. Module 4: Program units — Procedures, functions, packages
  5. Module 5: Triggers & cursors — Cursors, exceptions, triggers
  6. Module 6: Performance — Indexes, explain plans

🏢 Training your team?

This course is available as live online batches, onsite workshops at your office, or self-paced access for your employees with progress reports for HR. The syllabus can be tailored to your systems and projects.

🎁 Book a free demo for your team Corporate plans

Show More

What Will You Learn?

  • Write complex SQL queries
  • Build PL/SQL procedures, functions and packages
  • Handle exceptions and cursors
  • Tune SQL with explain plans

Course Content

Module 1: SQL basics
SELECT, joins, functions

Module 2: Advanced SQL
Subqueries, analytic functions

Module 3: PL/SQL fundamentals
Blocks, variables, control flow

Module 4: Program units
Procedures, functions, packages

Module 5: Triggers & cursors
Cursors, exceptions, triggers

Module 6: Performance
Indexes, explain plans

Student Ratings & Reviews

No Review Yet
No Review Yet
Scroll to Top