SQL Programming

Request more details:

submit request
Description:
Students learn how to create, retrieve and manipulate objects in a relational database using ANSI standard Structured Query Language (SQL)
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