Coronavirus (COVID-19) information: All courses at all locations are running as live online classes. Our offices remain open with limited staff. Learn more.

×

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. 

 

Please call 800-851-9237 to schedule this training 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

CLASSROOM
LIVE ONLINE
PRIVATE
MY LOCATION