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

2. Introduction to SQL

2.1 SELECT Statement Like

2.2 SELECT 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

3.1 Databases, Tables, Keys, Constraints, and Indexes Like

3.2 IF Statements and Transactions Like

3.3 Views and Stored Procedures Like