These courses can either be offered Online or In-Person. See course information at registration for more information.

Prerequisites:SQL Beginner, or equivalent knowledge

The course focuses on teaching individuals how to use SQL Server product features and tools related to implementing a database server. Students with the technical skills required to write basic Transact-SQL queries. This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence.

Prerequisite: SQL – Beginner

Topics Covered in this Course:
• Introduction to SQL Server and its Toolset
• Introduction to T-SQL Querying
• Creating Databases and Database Files
• Designing and Implementing Tables
• Working with SQL Server Data Types
• Writing SELECT Queries
• Querying Multiple Tables
• Sorting and Filtering Data
• Using Built-In Functions
• Grouping and Aggregating Data
• Using Subqueries
• Designing and Implementing Views

Required Material: 2GB (or higher) Flash (USB) Drive
Online courses require, Computer with Windows 10 or MacOS X or higher, microphone & headset, high speed internet connection.