Oracle Database SQL and PL-SQL Fundamentals Ed 2

Course overview of the course Oracle Database SQL and PL-SQL Fundamentals Ed 2

This Oracle Database SQL and PL-SQL Fundamentals Ed 2 training delivers the fundamentals of SQL and PL/SQL along with the benefits of the programming languages using Oracle Database technology. You’ll explore the concepts of relational databases.

Learn To

  • Write queries against single and multiple tables, manipulate data in tables and create database objects.
  • Use single row functions to customize output.
  • Invoke conversion functions and conditional expressions.
  • Use group functions to report aggregated data.
  • Create PL/SQL blocks of application code that can be shared by multiple forms, reports and data management applications.
  • Develop anonymous PL/SQL blocks, stored procedures and functions.
  • Declare identifiers and trap exceptions.
  • Use DML statements to manage data.
  • Use DDL statements to manage database objects.
  • Declare PL/SQL Variables.
  • Conditionally control code flow (loops, control structures).
  • Describe stored procedures and functions.
  • Retrieve row and column data from tables.

Course Information

  • Delivery Method: Classroom
  • Course Duration: 5 days
  • Course Level: Beginners

Audience Summary

  • IT Professional
  • PL/SQL Developers

Prerequisites for this course

  • Familiarity with programming concepts
  • Familiarity with data processing concepts and techniques

Learn To:

  • Identify what a SQL statement is.
  • Understand the Oracle Relational Database.
  • Use SQL Developer.
  • Write reports using SQL Statements.
  • Manipulate data in relational tables and save the data.

Course content summary for the course Oracle Database SQL and PL-SQL Fundamentals Ed 2

  • Introduction
  • Working with Oracle Cloud Exadata Express Cloud Service
  • Retrieve Data using the SQL SELECT Statement
  • Restricted and Sorted Data
  • Usage of Single-Row Functions to Customize Output
  • Conversion Functions and Conditional Expressions
  • Aggregated Data Using the Group Functions
  • Display Data From Multiple Tables
  • Usage of Subqueries to Solve Queries
  • SET Operators
  • Data Manipulation
  • DDL Statements to Create and Manage Tables
  • Other Schema Objects
  • Introduction to PL/SQL
  • PL/SQL Identifiers
  • Write Anonymous PL/SQL blocks
  • SQL statements in PL/SQL block
  • Control Structures
  • Composite Data Types
  • Explicit Cursors
  • Exception Handling
  • Stored Procedures and Functions

More Evolutiontech Courses for Oracle Database

Fale Conosco

Solicite o conteúdo programático completo do treinamento “Oracle Database SQL and PL-SQL Fundamentals Ed 2” ao nosso departamento comercial

Deixe uma resposta

O seu endereço de e-mail não será publicado. Campos obrigatórios são marcados com *