You are leaving our Website
Using an external Link:
You are now leaving our website. The following page is operated by a third party. We accept no responsibility for the content, data protection, or security of the linked page..
URL:
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?'
Agenda:
- Basics
- Definition of terms, data modeling, database structure
- Definition of terms, data modeling, database structure
- Data Definition Language (DDL)
- Creating, modifying, deleting database objects
- Creating, modifying, deleting database objects
- Data Manipulation Language (DML)
- Creating, modifying, deleting data
- Creating, modifying, deleting data
- Data Control Language (DCL, TCL)
- Permission concept, user management, transaction concept
- 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
Guaranteed implementation:
from 2 Attendees
Booking information
Price:
2.690,00 € plus VAT.
(including lunch & drinks)
Appointment selection:
No appointment available
Authorized training partner
Authorized training partner
Memberships
Memberships
Shopping cart
DB100: Oracle™ SQL
was added to the shopping cart.