Oracle SQL

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.

Info@learnworks.com
Oracle SQL

Description

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