PROKODA Gmbh

Introduction to SQL/PLSQL Accelerated Ed 2

PROKODA Gmbh
Online

6.770 
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 Introduction to SQL/PLSQL Accelerated course will teach you SQL and PL/SQL programming language concepts. Learn how to write SQL commands, develop stored PL/SQL procedures, functions, packages and database triggers. This accelerated course covers 10 days worth of content in only 5 days.Learn To:Understand the fundamental and core concepts of relational databases.Create reports of sorted and restricted data.Run data manipulation statements (DML).Retrieve row and column data from tables.Control privileges at the object and system level.Create indexes and constraints; alter existing schema objects.Create and query external tables.Create anonymous PL/SQL blocks, functions and procedures.Conditionally control code flow (loops, control structures).Create stored procedures, functions and packages.Conditionally control code flow (loops, control structures).Use PL/SQL packages to group and contain related constructs. Create triggers to solve business challenges. Leverage the Oracle supplied PL/SQL packages for various programming tasks. Benefits to YouBy enrolling in this course, you’ll gain expertise in relational database data management as you learn how to effectively use SQL commands against your business data. These features will help you query and manipulate data within the database, use the dictionary views to retrieve metadata and create reports about their schema objects. Extend the functionality of the SQL language with PL/SQL language to write application code.Participate in Hands-On ExercisesThrough hands-on instruction from expert Oracle instructors, you’ll learn to develop stored procedures, functions, packages and more. Hands-on exercises will help reinforce your learning.Course Bundle NoteThis course is a combination of Oracle Database: Introduction to SQL and Oracle Database: Program with PL/SQL 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?

Data Warehouse-AdministratorPL/SQL-EntwicklerTechnischer BeraterDatenbankadministratorenSystemanalytikerFormsentwicklerEntwickler

· Voraussetzungen

Erforderliche Vorkenntnisse:Familiarity with data processing concepts and techniquesData processingEmpfohlene Vorkenntnisse:Previous programming experience

Fragen & Antworten

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

Was lernen Sie in diesem Kurs?

Java
SQL
PL SQL
Business

Themenkreis


Förderung durch z.B. Bildungsprämie und NRW-Bildungsscheck möglichEmpfehlenswerte verwandte Kurse:Using Java - for PL/SQL and Database Developers This Java for PL/SQL and Developers training teaches you to access Oracle Database using JDBC , UCP, Java stored procedures and SQLJ technologies. Learn to create, load, resolve and publish Java classes in the Database and more.Oracle Database: SQL Tuning for DevelopersIn the Oracle Database: SQL Tuning for Developers course, you learn about Oracle SQL tuning and how to apply tuning techniques to your SQL code. Learn the different ways in which data can be accessed efficiently. In this course, you will be introduced to Oracle Database Exadata Express Cloud Service.Oracle Database: SQL Tuning for DevelopersIm Kurs "Oracle Database: SQL Tuning for Developers" lernen die Teilnehmer Oracle SQL-Tuning kennen und erfahren, wie sie die Tuningverfahren auf ihren SQL-Code anwenden. Die Teilnehmer lernen die verschiedenen Möglichkeiten kennen, mit denen sie effizient auf Daten zugreifen können.Oracle Database 12c: Analytic SQL for Data WarehousingThis Oracle Database 12c: Analytic SQL for Data Warehousing training teaches you how to use Analytic SQL to aggregate, analyze, report and model data. Interact with expert Oracle University instructors. In this course, you will be introduced to Oracle Business Intelligence Cloud Service. Verwendete Datenbank Version:Oracle Database 12c Release 2 (12.2.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=D80178GC20Seminarzeiten 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