Minha Conta
Recuperar Senha

Digite seu endereço de e-mail que foi cadastrado e enviaremos seus dados de acesso.

Minha Conta

Ao se cadastrar, você concorda com a Política de Privacidade e Segurança

Mudar Data: Photoshop CS6 Módulo I
Preço
15/09 a 26/09 Manhã 4000,00
15/09 a 26/09 Manhã 4000,00
15/09 a 26/09 Manhã 4000,00
15/09 a 26/09 Manhã 4000,00
  Itens Preço
Carrinho de Compras
O carrinho está vazio.
INVESTIMENTO TOTAL:0,00

Esqueci minha senha

Foi enviado um e-mail para com os dados de acesso.

Curso de Oracle 11g - Program with PL/SQL

O curso Oracle 11g - Program with PL/SQL introduz e apresenta todos os benefícios da linguagem de programação PL/SQL na plataforma Oracle em aulas práticas. Em contato com instrutores especializados, o aluno desenvolverá suas habilidades de criar e depurar procedimentos de armazenamento, funções e pacotes, além de customizar aplicações sem remover códigos.
Para o melhor aproveitamento do curso Oracle 11g - Program with PL/SQL, é imprescindível ter participado de cursos básicos de SQL e Oracle 11g ou possuir conhecimentos equivalentes.

Conteúdo Programático do Curso

  • TópicoIntroduction
    • Course Objectives.
    • Course Agenda.
    • Describe the Human Resources (HR) Schema.
    • PL/SQL development environments available in this course.
    • Introduction to SQL Developer.
  • TópicoDeclare PL/SQL Identifiers
    • List the different Types of Identifiers in a PL/SQL subprogram.
    • Usage of the Declarative Section to Define Identifiers.
    • Use variables to store data.
    • Identify Scalar Data Types.
    • The %TYPE Attribute.
    • What are Bind Variables?
    • Sequences in PL/SQL Expressions.
  • TópicoInteraction With the Oracle Server
    • Invoke SELECT Statements in PL/SQL.
    • Retrieve Data in PL/SQL.
    • SQL Cursor concept.
    • Avoid Errors by using Naming Conventions when using Retrieval and DML Statements.
    • Data Manipulation in the Server using PL/SQL.
    • Understand the SQL Cursor concept.
    • Use SQL Cursor Attributes to Obtain Feedback on DML.
    • Save and Discard Transactions.
  • TópicoComposite Data Types
    • Use PL/SQL Records.
    • The %ROWTYPE Attribute.
    • Insert and Update with PL/SQL Records.
    • INDEX BY Tables.
    • Examine INDEX BY Table Methods.
    • Use INDEX BY Table of Records.
  • TópicoException Handling
    • Understand Exceptions.
    • Handle Exceptions with PL/SQL.
    • Trap Predefined Oracle Server Errors.
    • Trap Non-Predefined Oracle Server Errors.
    • Trap User-Defined Exceptions.
    • Propagate Exceptions.
    • RAISE_APPLICATION_ERROR Procedure.
  • TópicoStored Functions and Debugging Subprograms
    • Create, Call, and Remove a Stored Function.
    • Identify the advantages of using Stored Functions.
    • Identify the steps to create a stored function.
    • Invoke User-Defined Functions in SQL Statements.
    • Restrictions when calling Functions.
    • Control side effects when calling Functions.
    • View Functions Information.
    • How to debug Functions and Procedures?
  • TópicoDeploying Packages
    • Overloading Subprograms in PL/SQL.
    • Use the STANDARD Package.
    • Use Forward Declarations to solve Illegal Procedure Reference.
    • Implement Package Functions in SQL and Restrictions.
    • Persistent State of Packages.
    • Persistent State of a Package Cursor.
    • Control side effects of PL/SQL Subprograms.
    • Invoke PL/SQL Tables of Records in Packages.
  • TópicoDynamic SQL
    • The Execution Flow of SQL.
    • What is Dynamic SQL?
    • Declare Cursor Variables.
    • Dynamically Executing a PL/SQL Block.
    • Configure Native Dynamic SQL to Compile PL/SQL Code.
    • How to invoke DBMS_SQL Package?
    • Implement DBMS_SQL with a Parameterized DML Statement.
    • Dynamic SQL Functional Completeness.
  • TópicoTriggers
    • Describe Triggers.
    • Identify the Trigger Event Types and Body.
    • Business Application Scenarios for Implementing Triggers.
    • Create DML Triggers using the CREATE TRIGGER Statement and SQL Developer.
    • Identify the Trigger Event Types, Body, and Firing (Timing)
    • Differences between Statement Level Triggers and Row Level Triggers.
    • Create Instead of and Disabled Triggers.
    • How to Manage, Test and Remove Triggers?
  • TópicoPL/SQL Compiler
    • What is the PL/SQL Compiler?
    • Describe the Initialization Parameters for PL/SQL Compilation.
    • List the new PL/SQL Compile Time Warnings.
    • Overview of PL/SQL Compile Time Warnings for Subprograms.
    • List the benefits of Compiler Warnings.
    • List the PL/SQL Compile Time Warning Messages Categories.
    • Setting the Warning Messages Levels: Using SQL Developer, PLSQL_WARNINGS Initialization Parameter, and the DBMS_WARNING View Compiler Warnings: Using SQL Developer, SQL*Plus, or the Data Dictionary Views.
  • TópicoManage Dependencies
    • Overview of Schema Object Dependencies.
    • Query Direct Object Dependencies using the USER_DEPENDENCIES View.
    • Query an Objects Status.
    • Invalidation of Dependent Objects.
    • Display the Direct and Indirect Dependencies.
    • Fine-Grained Dependency Management in Oracle Database 11g.
    • Understand Remote Dependencies.
    • Recompile a PL/SQL Program Unit.
  • TópicoIntroduction to PL/SQL
    • Overview of PL/SQL.
    • Identify the benefits of PL/SQL Subprograms.
    • Overview of the types of PL/SQL blocks.
    • Create a Simple Anonymous Block.
    • How to generate output from a PL/SQL Block?
  • TópicoWrite Executable Statements
    • Describe Basic PL/SQL Block Syntax Guidelines.
    • Learn to Comment the Code.
    • Deployment of SQL Functions in PL/SQL.
    • How to convert Data Types?
    • Describe Nested Blocks.
    • I
    • dentify the Operators in PL/SQL.
  • TópicoControl Structures
    • Conditional processing using IF Statements.
    • Conditional processing using CASE Statements.
    • Describe simple Loop Statement.
    • Describe While Loop Statement.
    • Describe For Loop Statement.
    • Use the Continue Statement.
  • TópicoExplicit Cursors
    • What are Explicit Cursors?
    • Declare the Cursor.
    • Open the Cursor.
    • Fetch data from the Cursor.
    • Close the Cursor.
    • Cursor FOR loop.
    • The %NOTFOUND and %ROWCOUNT Attributes.
    • Describe the FOR UPDATE Clause and WHERE CURRENT Clause.
  • TópicoStored Procedures
    • Create a Modularized and Layered Subprogram Design.
    • Modularize Development With PL/SQL Blocks.
    • Understand the PL/SQL Execution Environment.
    • List the benefits of using PL/SQL Subprograms.
    • List the differences between Anonymous Blocks and Subprograms.
    • Create, Call, and Remove Stored Procedures.
    • Implement Procedures Parameters and Parameters Modes.
    • View Procedure Information.
  • TópicoPackages
    • Listing the advantages of Packages.
    • Describe Packages.
    • What are the components of a Package?
    • Develop a Package.
    • How to enable visibility of a Packages Components?
    • Create the Package Specification and Body using the SQL CREATE Statement and SQL Developer.
    • Invoke the Package Constructs.
    • View the PL/SQL Source Code using the Data Dictionary.
  • TópicoImplement Oracle-Supplied Packages in Application Development
    • What are Oracle-Supplied Packages?
    • Examples of some of the Oracle-Supplied Packages.
    • How does the DBMS_OUTPUT Package work?
    • Use the UTL_FILE Package to Interact with Operating System Files.
    • Invoke the UTL_MAIL Package.
    • Write UTL_MAIL Subprograms.
  • TópicoDesign Considerations for PL/SQL Code
    • Standardize Constants and Exceptions.
    • Understand Local Subprograms.
    • Write Autonomous Transactions.
    • Implement the NOCOPY Compiler Hint.
    • Invoke the PARALLEL_ENABLE Hint.
    • The Cross-Session PL/SQL Function Result Cache.
    • The DETERMINISTIC Clause with Functions.
    • Usage of Bulk Binding to Improve Performance.
  • TópicoCreating Compound, DDL and Event Database Triggers
    • What are Compound Triggers?
    • Identify the Timing-Point Sections of a Table Compound Trigger.
    • Understand the Compound Trigger Structure for Tables and Views.
    • Implement a Compound Trigger to Resolve the Mutating Table Error.
    • Comparison of Database Triggers to Stored Procedures.
    • Create Triggers on DDL Statements.
    • Create Database-Event and System-Events Triggers.
    • System Privileges Required to Manage Triggers.
  • TópicoManage PL/SQL Code
    • What Is Conditional Compilation?
    • Implement Selection Directives.
    • Invoke Predefined and User-Defined Inquiry Directives.
    • The PLSQL_CCFLAGS Parameter and the Inquiry Directive.
    • Conditional Compilation Error Directives to Raise User-Defined Errors.
    • The DBMS_DB_VERSION Package.
    • Write DBMS_PREPROCESSOR Procedures to Print or Retrieve Source Text.
    • Obfuscation and Wrapping PL/SQL Code.

Confira todas as datas deste treinamento

Início Término Período Unidade Preço
Por favor, aguarde...Por favor, aguarde...
Boleto

5% de desconto
no Boleto

Certificados de segurança
Formas de pagamento
Formas de Pagamento

Conheça algumas profissões relacionadas ao curso

O curso Oracle 11g - Program with PL/SQL garante ao egresso as noções necessárias de programação em SQUL para atuar como um DBA moderno e em sintonia com o mercado.
O curso Oracle 11g - Program with PL/SQL é ideal para profissionais que desejam desenvolver aplicações e soluções para a plataforma Oracle.
Com o curso Oracle 11g - Program with PL/SQL o formado está apto para criar aplicações e desenvolver soluções completas utilizando a plataforma Oracle, atuando como desenvolvedor desktop.
ICS

Certificações Impacta deste curso:

Recomendamos para você