Introduction to SQL – 3 Days

Course Description – Introduction to SQL

This Introduction to SQL training course provides an in-depth introduction to the Structured Query Language, or SQL. Students learn key concepts of relational databases and query design, and have extensive opportunities to write database queries. The course also introduces table design and database update statements.

What You Will Learn

Understand the structure of relational databases.
Write simple select-from-where style queries.
Write standard and correlated subqueries.
Write queries that use all styles of table join.
Build database tables, and write insert, update, and delete statements to modify data.

Prerequisites

None.

Outline

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

System Requirements

Hardware Requirements (Minimum)	Core 2 Duo 1.5 GHz, 1 gig RAM, 1 gig disk space.
Hardware Requirements (Recommended)	Core 2 Duo 2.5 GHz, 1 gig RAM, 1 gig disk space.
Operating System	Tested on Windows XP Professional and Windows 7.
Network and Security	Limited privileges required
Software Requirements	All free downloadable tools.

Other courses to explore:

Oracle 12c Release 2 SQL Training – Onsite, Tailored, Low Cost

Oracle 12c Release 2 PL/SQL Development Training – Onsite, Tailored

Relational Database Design Training – Onsite, Tailored, Low Cost