Udemyintermediatees

Curso Intermedio I de Oracle

Learn Oracle database skills and become an Oracle expert. This course expands your knowledge for career advancement.

Related:MySQL
4.8(41)
71students
11h 53m
Certificate
Miguel Viruete
Miguel VirueteExperto en Oracle

Course Content

Curso Intermedio I de Oracle is an intermediate-level Udemy course taught by Miguel Viruete. It runs 11h 53m, is taught in Spanish, and includes a certificate of completion. Learners rate it 4.8 out of 5 from 41 reviews, with 71 students enrolled. It is a paid course, first published June 2025.

Unlock Advanced Oracle SQL & PL/SQL Skills

This intermediate-level Oracle course will elevate your programming capabilities and set you apart in the Oracle developer community. We go beyond the basics of SQL and PL/SQL, diving into powerful features often missed in introductory materials.

Here's what you'll master:

  • Advanced SQL Techniques: Explore topics beyond standard SQL, including effective use of SQL*Plus, the powerful WITH clause for complex queries, and writing portable queries using ANSI notation.
  • PL/SQL Mastery: Gain expertise in advanced PL/SQL concepts like REF_Cursors for dynamic data handling and autonomous transactions for robust application logic.
  • Oracle Collections: Understand the different types of collections available in Oracle and learn best practices for their efficient management.
  • Triggers Deep Dive: Discover the full potential of triggers, not just DML triggers, but also other trigger types that can significantly enhance your database environment.
  • Data Loading Strategies: Compare and contrast various data loading methods, with a strong focus on the advantages of using external tables for streamlined data import.
  • Advanced Database Objects: Learn about Oracle directories, and the creation and utilization of both regular and materialized views. We'll focus on achieving FAST refresh for materialized views, exploring the techniques and limitations involved.
  • Essential Oracle Packages: Utilize powerful built-in packages like UTL_FILE for reading and writing text files directly from your database, and DBMS_JOB and DBMS_SCHEDULER for automating tasks and scheduling jobs.

The course culminates in a practical final exercise, reinforcing the key concepts and skills you've acquired throughout the program. This course is designed to help you become a more proficient and valuable Oracle database developer.

$ whoami — the devs behind tutorialsearch.io

Hire the developers behind TutorialSearch.io

We built this site — full-stack web apps, AI integration & automation. Tell us what you need and we'll build yours.

5.0(27)
2h 15m
all

Curso sobre el tratamiento de bulimia

by AEPSIS Asociación Española de Psicología Sanitaria

5.0(12)
2h 18m
all

Curso sobre acoso escolar, bullying

by AEPSIS Asociación Española de Psicología Sanitaria

5.0(7)
1h 39m
all
5.0(23)
7h 26m
all
5.0(43)
2h 13m
all
5.0(11)
4h 10m
beginner