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

Oracle Database 12c R2: SQL Workshop 2 Training Course in Finland

Finland is a country located in northern Europe. Helsinki is the capital and largest city of the country. The majority of the people are Finns but there is also a small Lapp population in Lapland, where the country is famous for the Northern Lights. Finland's national languages are Finnish and Swedish.

Known for its vast forests, lakes, and natural beauty, Finland is one of the world's largest producers of forest products, such as paper, pulp, and lumber. One of the world's largest sea fortresses Suomenlinna, Rovaniemi with the "White Nights", dogsled safaris and of course the Northern Lights are what makes Finland so popular for tourists. Finland is one of the best places in the world to see the Northern Lights and attracts millions of tourists during its seasons.

Finland is home to a thriving technology industry and is widely recognized as one of the world's leading technology hubs. Companies such as Nokia and Rovio (creator of the popular game Angry Birds) are based in Finland. Some of the key factors that have contributed to Finland's success in technology include; strong investment in research and development, a highly educated workforce and fundings.

Finland has a strong educational system, and is widely regarded as one of the world's most literate countries. In fact, Finland's literacy rate is one of the highest in the world, and its students consistently perform well in international tests of math and reading ability.

Also, as a pioneer in environmental sustainability, Finland is known for its efforts to reduce its carbon footprint and promote clean energy. This Nordic country is also famous for its unique and distinctive cultural heritage, including its traditional folk music and its elaborate traditional costumes.

Helsinki, Finland's capital city, is the country's business center. Helsinki is Finland's largest city, and it is home to many of the country's major corporations and organizations, including many of the country's leading technology firms. The city is also a commercial, trade, and financial center, as well as one of the busiest ports in the Nordic region.

Take advantage of our diverse IT course offerings, spanning programming, software development, business skills, data science, cybersecurity, cloud computing and virtualization. Our knowledgeable instructors will provide you with practical training and industry insights, delivered directly to your chosen venue in Finland.

Oracle Database 12c R2: SQL Workshop 2 Training in Finland

Upcoming Trainings

Oracle Database 12c R2: SQL Workshop 2 Training in Finland

Prerequisites

What You Will Learn

Outline

Upcoming Trainings