SQL Training

SQL Introduction – 1 Day

Getting Started

• Relational Database Concepts
• The role of SQL
• ANSI 89 & 92 standards

Writing Basic SQL Statements

• Selecting data
• SELECT statement syntax
• SQL vs SQL*Plus commands

Restricting and Sorting Data

• Limiting the rows returned by a query
• Sorting the rows

Single Row Functions

• The types of functions available in SQL
• Using Character, Number and Date functions in SELECT statements
• Conversion functions and their uses

Getting data from multiple tables

• Joining multiple tables in a SELECT statement
• The Cartesian Product
• Different join types

Aggregating data using group functions

• Aggregate or group functions
• Grouping data using the GROUP BY clause

SQL Tools

• SQL Query Analyser
• The Object Browser
• Creating and executing script files