Skip to content Skip to site navigation Skip to service navigation

SQL Essentials

Class Sessions

Datesort descending Cost
  • Wed Feb 14, 9:00 am to 4:00 pm
$395

Class Code

ITS-2521

Class Description

Are you tasked with creating reports where your data is stuck in a huge database? Learn how to retrieve that data on your own with SQL, the standard programming language for creating, updating, and retrieving information stored in databases.

Objectives

In this day-long class, we will cover basic database concepts so you can understand your data. Then we'll move into writing SQL statements that will allow you to retrieve, sort and filter data. This class will enable students to turn ordinary questions into statements that the database can understand. We will also use simple functions to generate new data and create summaries. All this while joining multiple tables together to retrieve data into your results!

Activities

This is a hands-on class with instructor walk-throughs and practice labs to allow students to become familiar with the SQL language and working with databases. Our day starts with an overview of what makes up a database. Then we look at the structure of a SQL statement, specifying proper fields, filtering rows using criteria, sorting data.

Prerequisites

Basic knowledge of relational databases and query terms is recommended.