Oracle Database 12c R2: SQL Workshop II

Beschreibung

The Oracle Database: SQL Workshop II Ed 2 course will help students enhance their skills as Application developers by learning to manage the database objects, data dictionary views and multicolumn subqueries. Students also learn to write more efficient queries using the functions supporting the timezone and regular expressions.

Learn To:

  • Grant and revoke privileges and roles.
  • Manage schema objects and data dictionary views.
  • Write efficient and complex subqueries.
  • Use the in-built functions supporting the usage of regular expressions and time zone.

Benefits To You

This course is designed for application developers with basic SQL language skills. Students learn how to use the advanced features of SQL in order to query and manipulate data within the database. Students will also learn how to control privileges at the object and system level. Advanced querying and reporting techniques are explained. Students will learn to use the regular expression support in SQL.

Students benefit by using Oracle SQL Developer as the main environment tool for writing SQL. SQL*Plus is introduced as an optional tool. Demonstrations and hands-on practice reinforce the concepts.

kursziele

  • Add new users with different levels of access privileges
  • Manage schema objects
  • Run data definition language (DDL) statements to create and manage schema objects
  • Manage objects with data dictionary views
  • Manipulate large data sets in the Oracle database by using subqueries
  • Manage data in different time zones
  • Control database access to specific objects
  • Write multiple-column subqueries
  • Use scalar and correlated subqueries
  • Use the regular expression support in SQL

Zielgruppe / Vorkenntnisse

  • PL/SQL-Entwickler
  • Datenbankadministratoren
  • Systemanalytiker
  • Formsentwickler

Empfehlenswerte verwandte Kurse:

Oracle Database: SQL Workshop I
The Oracle Database: SQL Workshop course will help students enhance their skills as Application developers by learning to manage the database objects, data dictionary views and multicolumn subqueries. Students also learn to write more efficient queries using the functions supporting the timezone and regular expressions.

Oracle Database: SQL Workshop I
This Oracle Database: SQL Workshop II helps you manage the database objects, data dictionary views and multicolumn subqueries. Learn to write more efficient queries using the functions supporting the timezone and regular expressions.

Kursinhalt

  • Introduction
  • Introduction to Data Dictionary Views
  • Creating Sequences, Synonyms, Indexes
  • Creating Views
  • Managing Schema Objects
  • Retrieving Data by Using Subqueries
  • Manipulating Data by Using Subqueries
  • Controlling User Access
  • Manipulating Data Using Advanced Queries
  • Managing Data in Different Time Zones

Weitere Infos



Beginn:
Am ersten Kurstag um 10.00 Uhr: Ca. 15 Minuten sind vor Kursbeginn für die Registrierung vorgesehen. An den nachfolgenden Tagen sind die Kurszeiten von 9.00 - 17.00 Uhr.

Kurssparche: Deutsch

Enthaltene Leistungen:

    Schulungsunterlagen
    Teilnahmezertifikat
    Getränke (Kalte und Warme)
    Obst und Snacks
    Mittagessen

Kursdetails

Startdatum 23.07.2020
Enddatum 24.07.2020
Anmeldungsende 19.07.2020
Netto Einzelpreis € 1.326,00
Speaker English
Kurs-Nr. Oracle Database: SQL Workshop II
Ort LVC
Abgeschlossen