This is a 2-day class (6-hours per day) that includes lecture, lab and testing for up to 12 students.
Attendees will learn how to access and manipulate Oracle data using SQL (Structured Query Language).
The attendees will construct SQL statements and scripts to solve simple and complex business questions by writing SQL in a variety of tools and applications.
Lectures and topics are enhanced with live illustrations and hands-on exercises.
Introduction to SQL commands for data extraction and manipulation.
Introduction to SQL commands to create Oracle objects including tables, indexes and views.
Exposure to Oracle tools SQL*Plus and SQL Developer.
Exposure to Quest Software's Toad application.
Introduction to advanced SQL topics including group functions, joins, analytical SQL, tuning and much more.
AUDIENCE: The focus of this course is to give a working knowledge of SQL to non-IT people or to people who are new to the relational database world.
ATTENDEES RECEIVE: o Study Guide with presentations and relevant white papers o SQL Reference pocket guide o Example files with SQL and SQL*Plus scripts
COURSE OUTLINE: Day 1: Introduction to Oracle SQL o Oracle RDBMS Architecture overview o Introduction to Toad, Toad Data Point, SQL*Plus and SQL Developer o Introduction to SQL DML (Data Manipulation Language) - Database queries (SELECT) - Data Manipulation (INSERT, UPDATE, DELETE) o Introduction to SQL DDL (Data Dictionary Language) - Create Tables - Create Indexes - Create Views o Introduction to SQL Scripts
Day 2: Advanced SQL Topics o Functions o Advanced SQL
- Joins - ANSI SQL Syntax - Sub-Queries o Group Functions o Analytical SQL - Windowing - Partitioning - Ranking - Percentiles o Intro to SQL Tuning o Referential Integrity o Using ODBC Drivers and MS Products o Building HTML ReportsType your paragraph here.