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 Denmark

Denmark is a constitutionally unitary state that is in Northern Europe. The population of the country is 5.91 million and 800,000 of them live in the capital and largest city, Copenhagen. And Danish is the official language. Denmark is a part of Scandinavia, like Norway and Sweden. The country experiences changeable weather, since it's located in the meeting point of diverse air masses. The coldest month of Denmark is February while July is the warmest month.

The most popular tourist attractions are Tivoli Gardens, Nyhavn, Kronborg Slot and Viking Ship Museum. Tivoli is considered as the inspiration behind the Disney theme parks, which also contains roller coasters, puppet theaters, restaurants and food pavilions. And the reason why Kronborg Slot attracts tourists is because the castle is the setting of Shakespeare's Hamlet, and also a UNESCO World Heritage Site.

With a focus on meeting the unique requirements of Denmark, Bilginç IT Academy integrates advanced training methodologies into our diverse range of Certification Exam preparation courses and accredited corporate training programs. Prepare to revolutionize your perception of IT training with us.

Oracle Database: SQL Workshop 2 Training in Denmark

Upcoming Trainings

Oracle Database: SQL Workshop 2 Training in Denmark

Prerequisites

What You Will Learn

Outline

Upcoming Trainings