Visão Geral

Este curso apresenta os fundamentos da linguagem Oracle PL/SQL (Procedural Language/SQL), capacitando o participante a desenvolver blocos de código, procedimentos, funções, packages e gatilhos para automatizar processos e implementar regras de negócio em bancos de dados Oracle. O curso combina conceitos teóricos e atividades práticas para fornecer uma base sólida no desenvolvimento PL/SQL.

Objetivo

Após realizar este curso, você será capaz de:

• Compreender os fundamentos da linguagem Oracle PL/SQL
• Desenvolver blocos anônimos e estruturas de controle
• Criar procedimentos, funções e packages reutilizáveis
• Manipular dados utilizando SQL dentro de programas PL/SQL
• Implementar tratamento de exceções e depuração de código
• Automatizar processos e regras de negócio em bancos Oracle

Publico Alvo

• Desenvolvedores de banco de dados
• Programadores Oracle
• Analistas de sistemas
• Administradores de banco de dados (DBAs)
• Profissionais de suporte a aplicações
• Estudantes e profissionais que desejam atuar com Oracle Database

Pre-Requisitos

• Conhecimentos básicos de bancos de dados relacionais
• Conhecimentos de SQL (consultas, joins e manipulação de dados)
• Familiaridade com o Oracle Database ou Oracle SQL Developer

Conteúdo Programatico

Module 1: Introduction to PL/SQL Programming

1. Overview of PL/SQL architecture
2. Benefits of procedural programming in Oracle
3. Understanding PL/SQL execution environment
4. Structure of a PL/SQL block
5. Using Oracle SQL Developer for PL/SQL development
6. Writing and executing simple PL/SQL programs

Module 2: Variables, Data Types and Operators

1. Declaring variables and constants
2. PL/SQL data types
3. Variable scope and visibility
4. Assignment operators
5. Expressions and calculations
6. Type conversion techniques

Module 3: Program Control Structures

1. Conditional statements (IF, ELSIF, ELSE)
2. CASE expressions and statements
3. Loop structures
4. WHILE loops
5. FOR loops
6. Nested control structures

Module 4: Working with SQL in PL/SQL

1. Using SELECT INTO statements
2. Data manipulation with INSERT, UPDATE and DELETE
3. Transaction control concepts
4. Managing COMMIT and ROLLBACK operations
5. Using SQL functions within PL/SQL
6. Best practices for SQL integration

Module 5: Cursors and Record Processing

1. Introduction to cursors
2. Implicit and explicit cursors
3. Cursor attributes
4. Cursor FOR loops
5. Processing multiple rows
6. Working with records and collections

Module 6: Exception Handling

1. Understanding runtime errors
2. Built-in exceptions
3. User-defined exceptions
4. Exception handling blocks
5. Logging and error reporting techniques
6. Debugging PL/SQL applications

Module 7: Procedures and Functions

1. Creating stored procedures
2. Creating stored functions
3. Input and output parameters
4. Function return values
5. Calling procedures and functions
6. Reusable code development practices

Module 8: Packages and Modular Programming

1. Introduction to packages
2. Package specification and body
3. Managing package variables
4. Package procedures and functions
5. Benefits of modular development
6. Package maintenance and versioning

Module 9: Triggers and Database Automation

1. Introduction to database triggers
2. BEFORE and AFTER triggers
3. Row-level and statement-level triggers
4. Auditing and validation triggers
5. Trigger management and maintenance
6. Trigger best practices

Module 10: Practical Labs and Real-World Applications

1. Developing complete PL/SQL programs
2. Business rule implementation exercises
3. Database automation scenarios
4. Error handling and debugging workshops
5. Performance and code optimization basics
6. Final PL/SQL development project