> > > D80198

Oracle Database: SQL and PL/SQL Fundamentals (D80198)

Kursbeschreibung Kurstermine Detaillierter Kursinhalt
 

Kursüberblick

This Oracle Database: SQL and PL/SQL Fundamentals 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.
Benefits to You

Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling consolidation onto database clouds.

Hands-On Practices

Demonstrations and hands-on practice reinforce the fundamental concepts that you'll learn in this course. By enrolling in this course, you'll begin using Oracle SQL Developer to develop these program units. SQL*Plus is available as optional tools.

Course Bundle

Note: This course is a combination of Oracle Database: SQL Workshop I and Oracle Database: PL/SQL Fundamentals courses.

Zielgruppe

  • Application Developers
  • Forms Developer
  • Technical Consultant
  • Functional Implementer
  • Portal Developer
  • Reports Developer
  • PL/SQL Developer

Voraussetzungen

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

Kursziele

  • 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

Kursinhalt

  • 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
Classroom Training
Modality: G

Dauer 5 Tage

Preis (exkl. MwSt.)
  • Deutschland: 3.350,- €
  • Schweiz: Fr. 4.140,-
Termine und Buchen
Online Training
Modality: U

Dauer 5 Tage

Preis (exkl. MwSt.)
  • Deutschland: 3.155,- €
Termine und Buchen
 
Zum Buchen bitte auf den Ortsnamen klicken Kurstermine
Dies ist ein Instructor-led Online Training, das über WebEx in einer VoIP Umgebung durchgeführt wird. Sollten Sie Fragen zu einem unserer Online-Kurse haben, können Sie uns jederzeit unter +49 (0)40 25334610 oder per E-Mail an info@flane.de kontaktieren.
Deutschland
17.12. - 21.12.2018 Online Training Zeitzone: Europe/Berlin Kurssprache: englisch
11.02. - 15.02.2019 Online Training Zeitzone: Europe/Berlin Kurssprache: englisch
04.03. - 08.03.2019 München
15.04. - 19.04.2019 Online Training Zeitzone: Europe/Berlin Kurssprache: englisch
24.06. - 28.06.2019 München
 

Cookies verbessern unsere Services. Durch die Benutzung unserer Website erklären Sie sich mit unserer Verwendung von Cookies einverstanden.   Verstanden.