Introduction to SQL/PLSQL Accelerated Ed 2
Seminar
Online
Beschreibung
-
Kursart
Seminar
-
Methodik
Online
-
Beginn
auf Anfrage
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.
Standorte und Zeitplan
Lage
Beginn
Beginn
Hinweise zu diesem Kurs
Data Warehouse-AdministratorPL/SQL-EntwicklerTechnischer BeraterDatenbankadministratorenSystemanalytikerFormsentwicklerEntwickler
Erforderliche Vorkenntnisse:Familiarity with data processing concepts and techniquesData processingEmpfohlene Vorkenntnisse:Previous programming experience
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
- Java
- SQL
- PL SQL
- Business
- Oracle
- Database
- JDBC
- SQLJ
- DevelopersIn
- Technologies
Inhalte
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)
Introduction to SQL/PLSQL Accelerated Ed 2