SQL Programming

Course Description

Students learn how to create, retrieve and manipulate objects in a relational database using ANSI standard Structured Query Language (SQL)
2 Days
Contact us for pricing
 

Prerequisites

Relational Database and SQL Overview

Review of Relational Database Terminology
Introduction to SQL
Connecting to a SQL Database

SQL Queries: The SELECT Statement

The SELECT Statement
Creating Some Order
CHoosing Row With the WHERE Clasue
NULL Values
Compound Expressions
Subqueries
IN and BETWEEN
The LIKE Operator

SQL Functions

SQL Functions
Using SQL functions
String Functions
Numeric Functions
Date Functions
Conversion Functions

Views and Other Schema Objects

Views
Creating Views
Using Views
Indexes
Sequences
Synonyms

SQL Queries - Joins

Selecting From Multiple Tables
Joining Tables
Joining More Than Two Tables
Self Joins
Outer Joins
Types of Outer Joins

Aggregate Functions and Advanced Techniques

Corrrelated Subqueries
The EXISTS Operator
The Aggregate Functions
Grouping Rows
Combining SELECT Statements
SQLSQL ProgrammingANSIANSI SQL