ANSI SQL Querying Primer

DSOC0019 -- 1 Day Training Class

This ANSI SQL Querying Primer  class is to provide students with the technical skills required to write basic ANSI-SQL queries.

This training course is intended for people who are responsible for writing queries, reports, etc.

After completing the training class, students will be able to:

• Write Basic Queries using ANSI SQL 

Prerequisites

Before attending this training class, students should:

• Have experience using a Microsoft Windows-based operating system
• Be comfortable working with data in some environment
• Possess basic keyboarding/typing skills

ANSI SQL Querying Primer

Training Module 1: Overview of Relational Databases

• Relational Databases 
• Data Modeling Basics
• One-to-One Relationships
• One-to-Many Relationships
• Many-to-Many Relationships 

Training Module 2: Introduction to ANSI-SQL

• The ANSI-SQL Programming Language
• The DML (Data Manipulation Language) subset of ANSI-SQL
• ANSI-SQL Syntax Elements

Training Module 3: Overview of The SELECT Statement

• Introduction to Query Analyzer
• High-level discussion of the SELECT Statement clauses:
  • SELECT
  • FROM
  • WHERE
  • GROUP BY
  • HAVING
  • ORDER BY
• Simple Querying
• SQL Style and Formatting Basics

Training Module 4: The SELECT Clause

• Selecting Fields
• Selecting Expressions 
• Combining Fields and Expressions
• Aliasing Field Names
• Subquerying in the SELECT Clause

Training Module 5: The WHERE Clause

• A Review of Comparison Operators
• Limiting Rows Returned with WHERE Clauses
• Comparing Fields to Other Fields 
• Comparing Fields to Expressions
• Using the IN statement
• Using the EXISTS and NOT EXISTS Clauses
• Subquerying in the WHERE Clause
• NULL comparisons  
• Joining Tables in the WHERE Clause

Training Module 6: The ORDER BY Clause

• Ascending Sorts
• Descending Sorts
• Nested Sorts
• Sorting Expressions

Training Module 7: The GROUP BY and HAVING Clauses

• A Review of the DISTINCT keyword 
• A Review of Types of Aggregation
• Simple Aggregation with the GROUP BY Clause 
• Mixing Aggregates with Grouped Fields
• Expressions in the GROUP BY Clause
• Subquerying in the GROUP BY Clause
• The HAVING Clause -- Why We Need It

Training Module 8: The FROM Clause

• Table Name Aliasing
• The Comma-Delimited List Approach
• The Myriad of JOIN Types
• INNER JOIN Clauses
• LEFT JOIN Clauses
• Why You Don't Need RIGHT JOINs, etc. 
• Joining Tables
• Joining Literals
• Compound Joins
• Subquerying in the JOIN Clause

Training Module 9: Some Final Touches

• The UNION Statement 
• Aliasing Subqueries