Home sep Computer Based Training (CBT) sep IT Training sep Oracle sep Oracle 11g

Oracle 11g Introduction to SQL Online Training Course

     
Oracle 11g Introduction to SQL Training CDs
Single User License: $499.00
Multi-User Non-Concurrent License: $999.00
     

If you're curious about the latest generation of Oracle and SQL, you're not alone. Oracle 11g offers over 500 new features that promise better automation, technical innovations, simplified solutions, and reduced administrative costs.

The self-paced Oracle 11g Introduction to SQL CBT is an excellent resource for a self-directed examination of the new SQL 11g features. This course covers a variety of topics including language functionality enhancements, executing dynamic SQL, performance improvement enhancements, language usability enhancements, coding trigger enhancements, data warehousing enhancements, and SQL Developer enhancements.

The Oracle 11g Introduction to SQL training CD is packed with high quality video segments featuring an expert instructor who helps you explore the Oracle and SQL environments. As you watch the Oracle 11g Introduction to SQL training videos, you'll get an up close view of the features in action and you'll learn exactly how to use them.

The self-paced Oracle 11g Introduction to SQL CBT blends the best of instructor-led training with the best of computer based training. End result: you learn from the best and reinforce your learning with hands-on practice.

Install the Oracle 11g Introduction to SQL training CD on your PC or laptop and enjoy 24/7 access to training videos, simulations, hands-on labs, and interactive content. The course covers many complex concepts. Instead of taking extensive notes as you would do in a regular class, you can simply re-watch any of the Oracle 11g Introduction to SQL training videos as often as you need. In addition, you can jump ahead to topics you need to understand now.

Traditional classes require a huge and regular time commitment. Unfortunately, many working professionals have heavy workloads that can't accommodate another commitment. Instead of juggling work and school, use the Oracle 11g Introduction to SQL training CD. With this delivery format, you are in charge of your studies. You set the time and date and you decide how long to devote to your learning. This format is flexible, convenient, interactive, and effective. You can learn about Oracle 11g and SQL even if you are short osn time.

Course Titles:

  • Fundamentals
  • Advanced SQL

Related Titles:

Oracle 11g Introduction to SQL Training Video CBT Features:
   
   
Outline:
   
 

Fundamentals

  • Introduction
  • Retrieving Data Using SQL Select Statements
  • Restricting and Sorting Data
  • Using Single-Row Functions to Customize Output
  • Using Conversion Functions and Conditional Expressions
  • Reporting Aggregated Data Using the Group Functions
  • Displaying Data from Multiple Tables
  • Using Subqueries to Solve Queries
  • Using the Set Operators
  • Manipulating Data
  • Using DDL Statements to Create and Manage Tables
  • Creating Other Schema Objects

Advanced SQL

  • Controlling User Access
  • Managing Schema Objects
  • Managing Objects with Data Dictionary Views
  • Manipulating Large Data Sets Managing
  • Data in Different Time Zones
  • Retrieving Data Using Subqueries
  • Regular Expression Support