Coronavirus (COVID-19) information: Live classes available in-person or online from our fully vaccinated instructors. Learn more about our reopening.


SQL Level 1

SQL Level 1

SQL Level 1: Course Description

Get comfortable with the fundamentals of SQL, how relational databases work, and start pulling data with SQL queries. Learn the basics of relational databases and SQL in this course. Quickly get up and running to start pulling data from databases with SQL. Learn to perform calculations and manipulate data with SELECT, ORDER, GROUP, SUM, and more. 

SQL Level 1 Course Dates

All classes are led by a live instructor. Class times listed are Eastern time.


Please call 800-851-9237 or 781-376-6044 to schedule a course.

Contact AGI to request course dates.

SQL Level 1: Full Overview

Basic Concepts

1) Microsoft SQL Server

2) What is SQL?

3) What are Relational Databases?

The Graphic User Interface

4) Object Explorer

5) Query Window

6) Results Grid

7) Options

The Code

8) Basic Clauses

9) Field and Table Aliases

10) Creative use of Aliases

11) Inner Table Joins

12) Aggregations

13) Distinct Records

14) Text Criteria & Operators

15) Wildcard Filters

16) Numeric Criteria & Operators

Student Labs

Prerequisites: This is a beginner course and requires no prior coding experience.

You will receive a training manual created by our experts for course review. 

Available Delivery Methods For This Class