SQL -Intermediate

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.

Course Price: $563.00

Winter 2023

Evening Sessions

Jan 26 - Mar 23Thu

Thursday, Jan 26 - Thursday, Mar 23

DayTimeRoom Number
Thursday18:00 - 21:002F.20

Additional Information

Teacher: Jonathan Perlman
Course Number: 132075
Registration Start Date: Monday, Jul 04, 2022
Group Schedule Info: This course takes place entirey on campus.
Maximum Class Size: 3
Total Hours: 27
Status: Activity in Progress

Return to all Computer & Technology courses

Other Categories

Last Modified: February 8, 2023