Class Series Details

Below are the descriptions, prerequisites, schedule, and cost for the class(es) within this class series.

To register for a class, add it to your cart.

SQL Language

SQL is a universal language that interacts with practically every database program. SQL can be used within databases like Access or with web programming languages like ASP, ColdFusion, and PHP.

This class will cover the basics of coding your own SQL statements using MySQL. MySQL is an open-source database management system.

Part 1 - Introduction

Prerequisites: Working knowledge of your database software.

Recommended: Database Design Basics Seminar or equivalent experience.

Class Topics:

• Retrieval queries
• Setting criteria
• Sorting and grouping
• Joining tables

Part 2 - Introduction

Prerequisites: SQL Language Part 1 or equivalent experience.

Class Topics:

• Union queries
• Inserting, updating, and deleting data
• Creating and removing tables, fields, and indexes
• Subqueries