Introduction to SQL Programming Training in Altoona, Iowa

Chapter 1. Relational Databases and SQL

• Relational Databases
• SQL
• Schema
• Integrity
• DDL
• DML

Chapter 2. Tools

• Tools and Environment
• Creating the Course Schema

Chapter 3. The select Statement

• SQL Syntax
• Basic Query Structure
• Null Values
• Result Sets

Chapter 4. The select Clause

• The Expression List
• Character Expressions
• Column Headers and Aliases
• Mathematical Expressions
• Functions
• Using distinct

Chapter 5. The where Clause

• Filtering Predicates
• SQL Operators and Precedence
• Equality and Inequality Operators
• Logical Operators
• between
• like
• in
• is null
• Functions

Chapter 6. The order by Clause

• Sorting by Column Names
• Sorting by Expressions
• Sorting by Ordinal

Chapter 7. Aggregate Functions

• Aggregates
• count
• avg
• Querying Groups
• Grouping and the where Clause
• Choosing and Filtering Groups

Chapter 8. Standard Subqueries

• What is a Subquery?
• Standard Subqueries
• Using Aggregate Functions
• Subquery Operators

Chapter 9. SQL-Standard Joins

• Why Joins?
• Foreign Keys and Joins
• Qualifying Columns
• Table Aliases
• Inner and Outer Joins

Chapter 10. Correlated Subqueries

• Correlated Subqueries
• Subqueries and Scope
• Performance

Chapter 11. DDL for Tables

• Tables
• Object Names
• Data Types
• Creating a Table
• Dropping a Table

Chapter 12. Maintaining the Data in Tables

• Identifying Column Position and Data Type
• The insert Statement
• The update Statement
• The delete Statement
• Transaction Control
• Auto-Commit

Appendix A. Learning Resources

Appendix B. Course Schema

• The Entity Relationship Model
• The Schema Description