Introduction to Oracle 11G SQL Programming Training in Chicopee

Enroll in or hire us to teach our Introduction to Oracle 11G SQL Programming class in Chicopee, Massachusetts by calling us @303.377.6176. Like all HSG classes, Introduction to Oracle 11G SQL Programming may be offered either onsite or via instructor led virtual training. Consider looking at our public training schedule to see if it is scheduled: Public Training Classes
Provided there are enough attendees, Introduction to Oracle 11G SQL Programming may be taught at one of our local training facilities.
We offer private customized training for groups of 3 or more attendees.

Course Description

 
In this class, students will learn how to create, retrieve, and manipulate objects in Oracle 11g Structured Query Language (SQL). Students will also be introduced to Oracle 11g database features and tools.
Course Length: 2 Days
Course Tuition: $790 (US)

Prerequisites

Familiarity with relational database concepts is recommended.

Course Outline

 

Relational Database and SQL Overview
Review of Relational Database Terminology
Relational Database Management Systems
Introduction to SQL
Oracle Versioning and History
Logical and Physical Storage Structures
Connecting to a SQL Database
Datatypes
Sample Database

Using Oracle SQL*Plus
SQL*Plus
The SQL Buffer
Buffer Manipulation Commands
Running SQL*Plus Scripts
Tailoring Your SQL*Plus Environment
Viewing Table Characteristics
SQL*Plus Substitution Variables
Interactive SQL*Plus Scripts
SQL*Plus LOB Support
Graphical Clients

SQL Queries – The SELECT Statement
The SELECT Statement
The CASE...WHEN Expression
Choosing Rows with the WHERE Clause
NULL Values
Compound Expressions
IN and BETWEEN
Pattern Matching: LIKE and REGEXP_LIKE
Creating Some Order

Scalar Functions
SQL Functions
Using SQL Functions
String Functions
Regular Expression Functions
Numeric Functions
Date Functions
Date Formats
Conversion Functions
Literal Values
Intervals
Oracle Pseudocolumns

SQL Queries - Joins
Selecting from Multiple Tables
Joining Tables
Self Joins
Outer Joins

Aggregate Functions and Advanced Techniques
Subqueries
Correlated Subqueries
The EXISTS Operator
The Aggregate Functions
Nulls and DISTINCT
Grouping Rows
Combining SELECT Statements

Data Manipulation and Transactions
The INSERT Statement
The UPDATE Statement
Introduction to Oracle® 11g
SQL Programming
The DELETE Statement
Transaction Management
Concurrency
Explicit Locking
Data Inconsistencies
Loading Tables From External Sources

Data Definition and Control Statements
Datatypes
Defining Tables
Constraints
Inline Constraints
Modifying Table Definitions
Deleting a Table Definition
Controlling Access to Your Tables

Other Database Objects
Views
Creating Views
Updatable Views
Sequences
Synonyms

Appendix A - The Data Dictionary
Introducing the Data Dictionary
DBA, ALL, and USER Data Dictionary Views
Some Useful Data Dictionary Queries

Course Directory [training on all levels]

Upcoming Classes
Gain insight and ideas from students with different perspectives and experiences.

Interesting Reads Take a class with us and receive a book of your choosing for 50% off MSRP.