SQL for IT Professionals

by Rick Bingen

This is an introduction to relational database structure and Structured Query Language (SQL). Not all associates that work in IT have a programming/development background and a knowledge of database structure and a query language can be very useful. Associates who can query a database themselves will gain efficiency in their day to day tasks. This course is aimed at those IT professionals that want to learn SQL and a basic overview of relational database structure.

1. Introduction to Relational Databases

1.1 Storyteller Tutorial Like

1.2 Relational Database Introduction Like

1.3 SQL Reference Guide Like

2. Introduction to SQL

2.1 SELECT Statement Like

2.2 WHERE Clause Like

2.3 Aggregate Functions Like

2.4 Joins and Unions Like

2.5 Update, Insert, and Delete Like

2.6 NULL Values Like

3. SQL Databases