Oracle Database 12c: Introduction to SQL, New Zealand

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

This Oracle Database: Introduction to SQL training helps you write subqueries, combine multiple queries into a single query using SET operators and report aggregated data using group functions. Learn this and more through hands-on exercises. 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.

There are no prerequisites for this course.

Data Warehouse Administrator
PL/SQL Developer
Application Developers
System Analysts
Business Analysts
Forms Developer
Developer

Identify the major structural components of the Oracle Database 12c
Create reports of aggregated data
Write SELECT statements that include queries
Retrieve row and column data from tables
Run data manipulation statements (DML) in Oracle Database 12c
Create tables to store data
Utilize views to display data
Control database access to specific objects
Manage schema objects
Display data from multiple tables using the ANSI SQL 99 JOIN syntax
Manage objects with data dictionary views
Write multiple-column sub-queries
Employ SQL functions to retrieve customized data
Use scalar and correlated sub-queries
Create reports of sorted and restricted data

Introduction to Oracle Database
Retrieve Data using the SQL SELECT Statement
Learn to Restrict and Sort Data
Usage of Single-Row Functions to Customize Output
Invoke Conversion Functions and Conditional Expressions
Aggregate Data Using the Group Functions
Display Data From Multiple Tables Using Joins
Use Sub-queries to Solve Queries
The SET Operators
Data Manipulation Statements
Use of DDL Statements to Create and Manage Tables
Other Schema Objects
Control User Access
Management of Schema Objects
Manage Objects with Data Dictionary Views
Manipulate Large Data Sets
Data Management in different Time Zones
Retrieve Data Using Sub-queries
Regular Expression Support

AKSIGORTA

Thank you for your efforts.

AKSIGORTA

It was a useful training. We're hopeful for the rest.

AKSIGORTA

I am satisfied with the given training.

O. T.
Softtech

It was a useful training with practical examples that I can use in my daily life. Thank you.

F. M. Ö.
Softtech

The training was useful in terms of providing tools and information that will be useful in our daily tasks. Our trainer was an expert and a good teacher in his field. Thank you.

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+

Upcoming Trainings

Join our public courses in our New Zealand facilities. Private class trainings will be organized at the location of your preference, according to your schedule.

Classroom / Virtual Classroom

26 November 2024