Oracle SQL for development and database management Training Course

Course Code

osqldevdm

Duration

35 hours (usually 5 days including breaks)

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

Bookings, Prices and Enquiries

Private Classroom

From 9700EUR

Private Remote

From 6250EUR

Public Classroom

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

Related Categories

Related Courses

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