WE GET YOU IN SHAPE FOR FIELD USE.
For your trainings and workshops, H&L place particular value to individuality.
We will train you on site on your own systems, tailored to your requirements. Thus we can ensure a highly practical approach.
Here, you will benefit from the competence, the know-how and the long-lasting project expertise of our instructors.
Course Number: HL-ORA1
Title: SQL Basics
The Structured Query Language (SQL) forms the basis for any access to relational databases. The INSERT, UPDATE, DELETE and SELECT commands allow the access to and the modification of the data. The efficient use of this language is the basis for all further work with the Oracle database, whether for developers, database administrators or so-called power users in data warehouse environments.
In this training, the basics of SQL and its use within the Oracle database are taught. Case examples show how the language may be used efficiently.
- Structure of the Oracle database
- Description of database objects
- Description of language elements
- Usage of Oracle functions
- Table joins
- Data manipulation
- Use of SQL*Plus for data formatting