DB100: Oracle™ SQL

Training: Databases

In the seminar DB100 Oracle™ SQL you will receive an overview of the Oracle™ database architecture as well as working with SQL. You will learn the most important commands for data definition, manipulation and query (DDL, DML and Query).

We recommend as follow-up courses:

Unfortunately there are currently no available appointments.
Would you like to request an appointment? Then click on 'No matching appointment?'

Request prefered appointment period:

* All fields marked with an asterisk are mandatory fields.

Agenda:

  • Basics
    • Definition of terms, data modeling, database structure

  • Data Definition Language (DDL)
    • Creating, modifying, deleting database objects

  • Data Manipulation Language (DML)
    • Creating, modifying, deleting data

  • Data Control Language (DCL, TCL)
    • Permission concept, user management, transaction concept

  • Query
    • Creating complex queries,
    • Constructing subqueries
    • Using SQL functions
    • Set operators

  • Client access to database server using SQL Developer, SQL*Plus

  • SQLcl (the new SQL*Plus)

Objectives:

The course DB100 Oracle™ SQL will teach you the following knowledge and skills:

  • You are familiar with the basics of data modeling
  • You will be able to create and modify database objects such as tables, indexes, and views
  • You will know how to edit data in tables
  • You will be able to create queries for single or multiple tables
  • You will manage privileges at the object and system level
  • You will create SQL scripts and execute them

Target audience:

The training DB100 Oracle™ SQL is targeted at:

  • Programmers
  • Software Developers
  • Users of applications developed with SQL
  • Project Managers
  • Project Coordinators

Prerequisites:

To be able to follow the learning pace and content of the training DB100 Oracle™ SQL effectively, you must have the following prerequisites:

  • Basic IT knowledge
  • Basic knowledge of Unix or Windows operating systems
check-icon

Guaranteed implementation:

from 2 Attendees

Booking information

Price:

2.690,00 € plus VAT.

(including lunch & drinks)

Authorized training partner

NetApp Partner Authorized Learning
Commvault Training Partner
CQI | IRCA Approved Training Partner
Veeam Authorized Education Center
Acronis Authorized Training Center
AWS Partner Select Tier Training
ISACA Accredited Partner
iSAQB
CompTIA Authorized Partner
EC-Council Accredited Training Center

Memberships

Allianz für Cyber-Sicherheit
TeleTrust Pioneers in IT security
Bundesverband der IT-Sachverständigen und Gutachter e.V.
Bundesverband mittelständische Wirtschaft (BVMW)
Allianz für Sicherheit in der Wirtschaft
NIK - Netzwerk der Digitalwirtschaft
BVSW
Bayern Innovativ
KH-iT
CAST
IHK Nürnberg für Mittelfranken
eato e.V.
Sicherheitsnetzwerk München e.V.