Oracle SQL

In this course you will learn how a Database works: the structure of SQL, how to build queries, DML, Commit and Rollback, Subqueries, Joins and Set Operations. Also you will learn how to manipulate dates, numbers and strings with standard Functions, and how to handle null-values. It also has chapters on working witj SQL*Developer and querying in Oracle eBS.

Topics

Background and History
Objects in the Database
Select
Functions
Order by
Where
Group or Aggregate functions
Subqueries
Joins
Sets
Insert, update, delete
DDL: Data Definition Language
Views
Rights and Synonyms
Dictionary
SQL*Developer: Run queries, Excel
Queries in Oracle eBS

Audience

Developer
Manager

Course Formats

This course is available as:

Instructor led training
e-Learning
Book
Any combination of the 3 options

Client support is on top of our priority. Connect with us and learn more about our service via support@learnworks.com

+31 85-800-5800

Apeldoorn, The Netherlands

learnworks.com