Oracle SQL for development and database management Training Course

Course Code

osqldevdm

Duration

35 hours (usually 5 days including breaks)

Overview

This 5-day course demonstrates how to use Oracle SQL for database development and database management.

Course Outline

Database Development

  • Recapping the basic principles behind relational databases
    • Concepts and terminology     
  • Retrieving data using the SELECT statement
  • Using simple and more complex JOINS to retrieve data from multiple tables
    • SELF, INNER and OUTER joins
  • Restricting and sorting data, conditional expressions
    • Single row functions: string, date and time manipulation
    • IF-THEN-ELSE statements
  • Conversion of data between types
  • Creating aggregated reports
  • Using correlated and uncorrelated subqueries in SELECT statements
  • Retrieving and manipulating data using subqueries
  • Running Data Manipulation Statements in Oracle to manage database transactions
  • Query optimisation and efficiency

Database Management

  • The Oracle Data Dictionary: introduction and usage
  • Creating views, indexes, constraints and synonyms
  • Controlling and revoking user access to schema objects (tables, views)
  • Managing indexes and constraints

Testimonials

★★★★★
★★★★★

Bookings, Prices and Enquiries

Private Classroom

From 8700EUR

Private Remote

From 7500EUR (15)

Public Classroom

Cannot find a suitable date? Choose Your Course Date >>Too expensive? Suggest your price

Course Discounts

Course Venue Course Date Course Price [Remote / Classroom]
Business Process Modelling in BPMN 2.0 Istanbul, Taksim Mon, 2018-10-01 09:30 4725EUR / 5525EUR
jBPM for Process Designers Izmir Mon, 2018-10-15 09:30 6300EUR / 7300EUR
Administering and Optimizing HipHop Virtual Machine (HHVM) Istanbul, Taksim Thu, 2018-10-18 09:30 2700EUR / 3300EUR
Nato Architecture Framework (NAF) Ankara Mon, 2018-12-17 09:30 7875EUR / 9075EUR
Cloud Computing Overview Istanbul, Taksim Thu, 2019-01-10 09:30 1350EUR / 1750EUR

Course Discounts Newsletter

We respect the privacy of your email address. We will not pass on or sell your address to others.
You can always change your preferences or unsubscribe completely.

Some of our clients

is growing fast!

We are looking to expand our presence in your region!

As a Business Development Manager you will:

  • expand business in the region
  • recruit local talent (sales, agents, trainers, consultants)
  • recruit local trainers and consultants

We offer:

  • Artificial Intelligence and Big Data systems to support your local operation
  • high-tech automation
  • continuously upgraded course catalogue and content
  • good fun in international team

If you are interested in running a high-tech, high-quality training and consulting business.

contact us right away!