Course overview of the couse Oracle Database PL/SQL Fundamentals Ed 2
The Oracle Database PL/SQL Fundamentals Ed 2 course introduces students to the PL/SQL programming language. In the class, students learn to create PL/SQL blocks of application code.
Learn To:
- Use various features of PL/SQL.
- Write anonymous blocks of code in PL/SQL.
- Use various PL/SQL conditional constructs and loops in program blocks.
- Interface the PL/SQL code with the database.
- Use stored procedures and functions in their program blocks.
- Handle Exceptions in PL/SQL code.
Course Information
- Delivery Method: Classroom
- Course Duration: 2 days
- Course Level: Beginners
Audience Summary
- IT Professional
- PL/SQL Developers
Prerequisites for the course Oracle Database PL/SQL Fundamentals Ed 2
- Familiarity with programming concepts
- Familiarity with data processing concepts and techniques
Course content summary for the Oracle Database PL/SQL Fundamentals Ed 2
- Introduction
- Introduction to PL/SQL
- Declaring PL/SQL Variables
- Writing Anonymous PL/SQL blocks
- Using SQL Statements within a PL/SQL Block
- Writing Control Structures
- Working with Composite Data Types
- Using Explicit Cursors
- Handling Exceptions
- Creating Stored Procedures and Functions
More Evolutiontech Courses for Oracle Database
- Oracle Database: Develop PL/SQL Program Units Ed 2
- Oracle Database: Introduction to SQL Ed 2
- Oracle Database: SQL Workshop I Ed 2
- Oracle Database: SQL Workshop II Ed 2
- Oracle Database: Program with PL/SQL
- Oracle Database: SQL and PL/SQL Fundamentals Ed 2
Fale Conosco
Solicite o conteúdo programático do curso “Oracle Database PL/SQL Fundamentals Ed 2” ao nosso departamento comercial