PROKODA Gmbh

Oracle Database: SQL and PL/SQL Fundamentals Ed 2

PROKODA Gmbh
Online

3.385 
Möchten Sie den Bildungsanbieter lieber direkt anrufen?
0221/... Mehr ansehen

Wichtige informationen

Tipologie Seminar
Methodologie Online
Beginn nach Wahl
  • Seminar
  • Online
  • Beginn:
    nach Wahl
Beschreibung

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 YouEnsure 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 PracticesDemonstrations 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 BundleNote: This course is a combination of Oracle Database: SQL Workshop I and Oracle Database: PL/SQL Fundamentals courses.

Einrichtungen (1)
Wo und wann
Beginn Lage
nach Wahl
Online
Beginn nach Wahl
Lage
Online

Zu berücksichtigen

· An wen richtet sich dieser Kurs?

PL/SQL-EntwicklerTechnischer BeraterFormsentwickler

· Voraussetzungen

Erforderliche Vorkenntnisse:Familiarity with programming conceptsFamiliarity with data processing concepts and techniques

Fragen & Antworten

Teilen Sie Ihre Fragen und andere User können Ihnen antworten

Was lernen Sie in diesem Kurs?

SQL
PL SQL

Themenkreis

IntroductionWorking with Oracle Cloud Exadata Express Cloud ServiceRetrieve Data using the SQL SELECT StatementRestricted and Sorted DataUsage of Single-Row Functions to Customize OutputConversion Functions and Conditional ExpressionsAggregated Data Using the Group FunctionsDisplay Data From Multiple TablesUsage of Subqueries to Solve QueriesSET OperatorsData ManipulationDDL Statements to Create and Manage TablesOther Schema ObjectsIntroduction to PL/SQLPL/SQL IdentifiersWrite Anonymous PL/SQL blocksSQL statements in PL/SQL blockControl StructuresComposite Data TypesExplicit CursorsException HandlingStored Procedures and FunctionsIntroductionRetrieve 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 TablesUsage of Subqueries to Solve QueriesSET OperatorsData ManipulationDDL Statements to Create and Manage TablesOther Schema ObjectsIntroduction to PL/SQLPL/SQL IdentifiersWrite Executable StatementsInteraction with the Oracle Server Control StructuresUsage of Composite Data Types Explicit CursorsException Handling Stored Procedures and Functions

Zusätzliche Informationen

Förderung durch z.B. Bildungsprämie und NRW-Bildungsscheck möglichEmpfehlenswerte verwandte Kurse:Oracle Database: Develop PL/SQL Program Units Ed 2 The Oracle Database: Develop PL/SQL Program Units Ed 2 course helps students enhance their skills as PL/SQL developers by learning to develop stored procedures, functions, packages, and database triggers. Oracle Database: Develop PL/SQL Program UnitsThis Oracle Database: Develop PL/SQL Program Units training helps you enhance your skills by developing stored procedures, functions, packages, and database triggers. Learn to manage PL/SQL program units and use Oracle-supplied packages. Oracle Database 12c: Advanced PL/SQLThisOracle Database 12c: Advanced PL/SQL training teaches you how to use the advanced features of PL/SQL. Learn how to efficiently design and tune PL/SQL to interface with the database and integrate with the other applications. In this course, you will be introduced to Oracle Database Exadata Express Cloud Service.Oracle Database 12c R2: Advanced PL/SQL Ed 2 In the Oracle Database 12c R2: Advanced PL/SQL course, students learn how to use the advanced features of PL/SQL in order to design and tune PL/SQL to interface with the database and integrate with the other applications. Verwendete Datenbank Version:Oracle Database 12c Release 2 (12.2.0.1.0)Oracle Database 12c Release 1 (12.1.0.1.0)URL zur Kursbeschreibung als PDF:http://education.oracle.com/pls/web_prod-plq-dad/view_pdf?c_org_id=34&c_lang=D&c_id=D80198GC20Seminarzeiten dieses Online-Trainings:17:00 Uhr bis 1:00 Uhr (Mitteleuropäischer Zeit)

User, die sich für diesen Kurs interessiert haben, interessierten sich auch für...
Mehr ansehen