Call 0800 860 6719 info@uniquelearn.co.uk

Oracle® 11g SQL Advanced
Programming

  • Teacher
  • Category
  • Course
    5 days
  • Course Price
    £1600
Oracle SQL Advanced programming

Book Now

In this course, delegates will develop deeper insight into relational database design and RDBMS operation, learn concepts and specific SQL syntax for extended Oracle® datatypes, learn analysis and tuning techniques to increase SQL performance, and master advanced features of Oracle SQL for large data sets and data warehouses.

Course Objective

Delegates will develop deeper insight into relational database design and RDBMS operation, learn concepts and specific SQL syntax for extended Oracle® datatypes, learn analysis and tuning techniques to increase SQL performance, and master advanced features of Oracle SQL for large data sets and data warehouses.

Target Audience

  • Application developers
  • Database administrators
  • System administrators and users

What’s included?

  • All accompanying course material
  • Refreshments will also be provided throughout the duration of your training.

Pr-requisition

Oracle 11g SQL Fundamentals.

Course Outline

  • Database Design Concepts
  • SQL Sub queries
  • Hierarchical Queries
  • Object Types
  • Times, Dates, and Strings
  • Temporary Tables
  • SQL Tuning Tools
  • SQL Tuning
  • Indexes
  • Oracle Analytic Functions
  • Data Warehouse Features
  • Formatting Reports with SQL*Plus

Course Information

  • Class Start : Days: 10 Feb
  • Course Duration : 5 days
  • Student Capacity : Small classes
  • Class Schedule : Weekdays, Weekends
  • Class Time : 10:00-17:00
  • Course Price : £1600
  • Teacher Name :

Comments

Leave a Reply

Your e-mail address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Related Posts

This website uses cookies to improve your experience. We’ll assume you are ok with this, but you can opt-out if you wish.