Overview
Accessing a relational Database requires understanding of Structured Query Language (SQL). This hands-on course picks up where most SQL users’ skills end. The focus of the course is on understanding SQL syntax, being able to write an efficient complex query, and “Thinking in SQL”. A core component of this class is understanding performance. This course includes an in-depth look at the factors that affect performance and understanding the issues prior to asking a DBA for help. This course explores the ANSI-95 SQL standard, along with Oracle SQL.
Audience
This course is designed for all individuals with prior working knowledge of SQL who want to improve their skills and knowledge base.
Length
3 days
Outline
- Introduction
- Review of Basic SQL Queries
- The SELECT Statement
- Inserting Records
- Updates
- Deletes
- Bulk Commands
- Advanced Selects
- Using SQL Functions
- Aliases
- Calculations
- Character Functions
- Composite Functions
- Date/Time Functions
- Numeric Functions
- Conversion Functions
- Sorting
- Multiple-Column Sorting
- Self Joins
- NULLs in Joins
- Subqueries
- Correlated Subqueries
- Subqueries as a Data Source
- Subqueries in Selection Criteria
- The EXISTS Operator
- The UNION Operator
- Understanding Views
- Invoking Views
- Column Based Logic
- Row Based Logic
- The WHERE Clause
- Limiting Rows
- Limiting Rows with a Sort
- AND, OR, NOT Logic
- BETWEEN Logic
- The IN Operator
- Understanding NULLs
- Pattern Matching
- DISTINCT Logic
- Aggregate Functions
- SUM, COUNT, MIN, MAX
- Grouping Results
- HAVING Clause
- Basic Joins
- Outer Joins
- Full Joins
- Understanding Stored Procedures
- Invoking Stored Procedures
- Thinking in Performance
- The Major Factors Effecting performance
- Understanding the Database Schema
- When to Recommend Index Changes
- When to ask A DBA for Help
- Summary