Enable Technology

Database 

Oracle SQL




Course Overview


A two day intensive course familiasing participants with the use of SQL in an Oracle context. SQL statements will be written and executed using a number of Oracle environments including SQL* Plus and Oracle SQL Developer.

Duration: 2 day course



Course Content


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 CASE...WHEN Expression 
Choosing Rows with the WHERE Clause 
NULL Values 
Compound Expressions 
IN and BETWEEN 
Pattern Matching: LIKE and REGEXP_LIKE 

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 
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






Email us about this courses         Telephone on 01952 305730






Training Locations: Enable Technology run courses in Wolverhampton, Telford, Shrewsbury, Birmingham, Cannock, Walsall, Dudley, Sandwell, Bridgnorth, Lichfield, Burton-upon-Trent, Stafford, Redditch, Bromsgrove, Solihull, Tamworth, Worcester, Shropshire, Staffordshire, Worcestershire and across the West Midlands.




West Midlands Scheduled Courses: Excel VBA; MS Project, SSRS; SQL; Crystal Reports; HTML;Adobe Illustrator; ASP.NET; Dreamweaver; Flash; Photoshop; InDesign; Google Scripting; Visio; PHP; Microsoft Access; JQuery JavaScript; Web Development; Office;

Birmingham Scheduled Courses: SQL; Excel VBA; MS Access;Photoshop; Adobe Illustrator; InDesign; Dreamweaver; MS Project;Visio; Flash; SSRS;PHP; JavaScript JQuery; HTML CSS; Microsoft Office;

Wolverhampton Scheduled Courses: Microsoft Access; Excel VBAMS Project; Visio; Adobe Illustrator; Photoshop; Dreamweaver; InDesign; Flash; HTML CSS; JavaScript; SQL; Microsoft Office; Adobe

Telford Scheduled Courses: SQL; Excel VBA; MS Project; Visio; PowerPoint; Photoshop; Adobe InDesign; Illustrator; Dreamweaver; Web Design; Office;

Cannock Scheduled Courses: Excel VBA; PHP; Microsoft Access; Visio; MS Project; PowerPoint; Dreamweaver; Photoshop; InDesign; Adobe Illustrator; Flash; JavaScript; HTML CSS;

Walsall Scheduled Courses: Excel; Access; MS Project; Visio; Photoshop; InDesign; Adobe Illustrator; Dreamweaver; Flash; SQL; JavaScript; HTML CSS;

Dudley Scheduled Courses: Excel; MS Access; SQL; MS Project;Visio; Adobe Illustrator; InDesign; Photoshop; Dreamweaver; Flash; JavaScript; HTML CSS;

Sandwell Scheduled Courses: Access;Excel; Microsoft Project; Visio; PowerPoint; Adobe Illustrator; Photoshop; Adobe InDesign; Dreamweaver; Flash; JavaScript; HTML CSS; SQL;

Shropshire Scheduled Courses: Illustrator; InDesign; Adobe; Dreamweaver; Flash; Photoshop; Excel; Project; Visio; PowerPoint; Office; JavaScript; HTML; Access;

Staffordshire Scheduled Courses: Illustrator; InDesign; Photoshop; Dreamweaver; Flash; Adobe; Excel;