Live Chat
Monday - Friday 8am - 6pm EST Chat Now
Contact Us
Monday - Friday 8am - 8pm EST 1-866-716-6688 Other Contact Options
Checkout

Cart () Loading...

    • Quantity:
    • Delivery:
    • Dates:
    • Location:

    $

Oracle 11g: Programming with SQL I and II

GK# 400137

Course Overview

Oracle Database 11g delivers economies of scale on easily managed low-cost grids, making it easier to reduce cost of downtime with maximum availability architecture, change IT systems faster using Real Application Testing, partition and compress data to run queries faster using less disks, securely protect and audit data, and enable total recall of data, and make productive use of standby resources with Active Data Guard.

This course addresses Oracle Database 11g Programming with SQL and is focused on:

Oracle Database 11g: SQL Fundamentals I

  • Using SQL to Query Your Database
  • Conversion Functions, Group Functions, and Joins
  • Subqueries, Set Operators, and Data Manipulation
  • Using DDL, Views, Sequences, Indexes, and Synonyms

Oracle Database 11g: SQL Fundamentals II

  • Controlling User Access and Managing Schema Objects
  • Data Dictionary Views and Large Data Sets
  • Managing Data in Different Time Zones
  • Using Subqueries and Regular Expressions

 

For self-paced learning, you will have access to this course for 12 months from the purchase date.

Delivery Format Options

  • Self-Paced

    Self-Paced

    Recordings, hands-on labs and expert instructors empower you to train on your own schedule.

    From

    $2025 CAD

  • Private Group Training

    Private Group Training

    Train your entire team in a private, coordinated professional development session at the location of your choice.

    Receive private training for teams online and in-person.

Request a date or location for this course.

What You'll Learn

Oracle Database 11g: SQL Fundamentals I

  • Concepts and components of an Oracle Database 11g database, how to retrieve information from it using SQL, and the steps for sorting, limiting, modifying, and formatting this information
  • Steps for writing queries that convert data from one type to another, specify conditions, perform calculations on groups of rows or even tables, and return values from more than one table
  • Steps for manipulating queries to return the data you need, using subqueries and set operators, and manipulating the actual data using INSERT, UPDATE, DELETE, and other data manipulation language (DML) statements
  • Steps for creating, defining, and dropping tables, manipulating how their data can be viewed, and using schema objects to generate integers, improve queries, and rename tables

Oracle Database 11g: SQL Fundamentals II

  • Steps for controlling user access to objects and for maintaining these objects by dropping columns and adding constraints and indexes
  • Steps for querying data dictionary views to view schema objects and for performing operations on large amounts of data, such as inserting data into multiple tables and merging table rows
  • Steps for managing data in different time zones in Oracle Database 11g, for managing time intervals, and for using datetime functions
  • Steps for retrieving data using subqueries and using regular expressions to search for, match, and replace strings

Who Needs To Attend

Business and systems analysts, application developers, PL/SQL developers, forms developers, and data warehouse administrators; database administrators, database designers, developer support engineers, and technical administrators