Oracle Database: SQL and PL/SQL Fundamentals (D80198)
Seminar
Online
Beschreibung
-
Kursart
Seminar
-
Methodik
Online
-
Beginn
auf Anfrage
Familiarity with programming concepts
Familiarity with data processing concepts and techniques
Standorte und Zeitplan
Lage
Beginn
Beginn
Hinweise zu diesem Kurs
Application Developers
Forms Developer
Technical Consultant
Functional Implementer
Portal Developer
Reports Developer
PL/SQL Developer
Run data definition language (DDL) statements to create and manage schema objects
Run data manipulation statements (DML) to update data in the Oracle Database
Use PL/SQL programming constructs and conditionally control code flow (loops, control structures, and explicit cursors)
Use cursors to process rows
Create reports of sorted and restricted data
Describe stored procedures and functions
Describe the features and syntax of PL/SQL
Design PL/SQL anonymous block that execute efficiently
Display data from multiple tables using the ANSI SQL 99 JOIN syntax
Create reports of aggregated data
Employ SQL functions to generate and retrieve customized data
Handle runtime errors
Retrieve row and column data from tables with the SELECT statement
Meinungen
Erfolge dieses Bildungszentrums
Sämtlich Kurse sind auf dem neuesten Stand
Die Durchschnittsbewertung liegt über 3,7
Mehr als 50 Meinungen in den letzten 12 Monaten
Dieses Bildungszentrum ist seit 15 Mitglied auf Emagister
Themen
- SQL
- PL SQL
Inhalte
- 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
Oracle Database: SQL and PL/SQL Fundamentals (D80198)