We can host this training at your preferred location. Contact us!

Official Oracle Curriculum

This Oracle Database: SQL Workshop II helps you enhance your skills as an Application developer by learning how to manage the database objects, data dictionary views and multicolumn subqueries. Expert Oracle instructors will teach you how to write more efficient queries using the functions that support 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.
Use the regular expression support in SQL.

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.

Advanced Features of SQL:

By enrolling in this course, you'll also gain exposure to using the advanced features of SQL to query and manipulate data within the database. Learn to control privileges at the object and system level, while deep diving into advanced querying and reporting techniques.

Reinforce Your Knowledge with Hands-On Practices:

During this SQL workshop, you'll use 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 new concepts that are introduced.

Target Audience:

Forms Developer
Functional Implementer
System Analysts
Application Developers
PL/SQL Developer

Familiarity with SQL Developer, SQL*Plus
Basic Knowledge of SQL
delegates should have attended or have knowledge to Oracle Database: SQL Workshop I

Please note: In order to provision you with your courseware and lab access for this course QA must share several items of basic personal information with our partner (usually your full name and email address). For more information on this please visit our QA Partner data sharing page. If you have any questions or concerns please contact your QA account manager.

At the end of this course you will be able to:

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
Control database access to specific objects
Manipulate large data sets in the Oracle database by using subqueries
Manage data in different time zones
Write multiple-column subqueries
Use scalar and correlated subqueries
Use the regular expression support in SQL

Introduction

Course Objectives, Course Agenda and Appendixes Used in this Course
Provide an insight of the development environments
Tables used in the Course
Review of the SQL Concepts

Introduction to Data Dictionary Views

Introduction to Data Dictionary
Describe the Data Dictionary Structure
Using the Data Dictionary Views
Querying the Data Dictionary Views

Creating Sequences, Synonyms, Indexes

Overview of sequences
Overview of synonyms
Overview of indexes

Creating Views

Overview of views

Managing Schema Objects

Managing constraints
Creating and using temporary tables
Creating and using external tables

Retrieving Data by Using Subqueries

Retrieving Data by Using a Subquery as Source
Working with Multiple-Column subqueries
Using Scalar subqueries in SQL
Correlated Subqueries
Working with the WITH clause

Manipulating Data by Using Subqueries

Using Subqueries to Manipulate Data
Inserting by Using a Subquery as a Target
Using the WITH CHECK OPTION Keyword on DML Statements
Using Correlated Subqueries to Update and Delete rows

Controlling User Access

System privileges
Creating a role
Object privileges
Revoking object privileges

Manipulating Data

Overview of the Explicit Default Feature
Using multitable INSERTs
Using the MERGE statement
Performing flashback operations
Tracking Changes in Data

Managing Data in Different Time Zones

Working with CURRENT_DATE, CURRENT_TIMESTAMP,and LOCALTIMESTAMP
Working with INTERVAL data types
Using Datetime functions in queries

Why have you chosen us?

I have attended a training from Bilginc IT Academy before and I was satisfied.

I have attended a training from a different provider and it was not helpful.

Other

How many employees do you have in your IT department?

0 – 50

50 – 250

250 – 1000

1000+

Oracle Database: SQL Workshop 2 Training Course in Germany

The Federal Republic of Germany is the second most populous country in Europe and is located in Central Europe. The official language of the country is German. Germany is one of the richest countries in the world. The main exports of the country include motor vehicles and iron and steel products.

Here are some fun facts about Germany:
The fairy tale writer, the Brothers Grimm, came from Germany and wrote many famous stories such as Cinderella, Snow White, and Sleeping Beauty.
Germany is home to the largest theme park in Europe, the Europa-Park.
The famous composer Ludwig van Beethoven was born in Germany.
The Autobahn, the German highway system, is known for having no general speed limit.

Berlin was divided by the Berlin Wall from 1961 to 1989. Known for its street art, Berlin has many colorful murals and graffiti throughout the city. Also, Berlin is home to many famous museums, such as the Pergamon Museum and the Museum Island. Many clubs and bars stay open until the early hours of the morning in this big city.

Another popular city is Munich, which is famous for its Oktoberfest beer festival that attracts millions of visitors every year. Munich is also home to many historic buildings, including Nymphenburg Palace and the Marienplatz town square.

The country's capital and largest city is Berlin, however Frankfurt is considered to be the business and financial center of Germany. It is home to the Frankfurt Stock Exchange, the European Central Bank, and many other financial institutions. Because of its central location within Europe and its status as a major financial hub, Frankfurt is often referred to as the "Mainhattan," a play on the city's name and its association with the Manhattan financial district in New York City.

Frankfurt is also a major transportation hub, with the largest airport in Germany and one of the largest in Europe, Frankfurt Airport. Additionally, it is a popular destination for tourists, with its historic city center, beautiful parks, and vibrant cultural scene.

Some of the top German technology companies like Siemens AG, Bosch, SAP SE, Deutsche Telekom, Daimler AG and Volkswagen has business centers in Frankfurt. The country has a strong tradition of engineering and innovation, and is home to many other world-class technology companies and research institutions.

Tailored to meet the specific needs of Germany, Bilginç IT Academy combines cutting-edge training methodologies with our comprehensive range of Certification Exam preparation courses and accredited corporate training programs. Experience a transformative approach to IT training that will redefine your expectations.

Oracle Database: SQL Workshop 2 Training in Germany

Upcoming Trainings

Oracle Database: SQL Workshop 2 Training in Germany

Prerequisites

What You Will Learn

Outline

Upcoming Trainings