SQL – Intermediate


Return to schedule


Course Title SQL – Intermediate
Course Number 900-006-EQ
Platform Windows
Duration 24 hours
Emploi-Québec fee (taxes incl.)
General Public fee (taxes incl.)
Schedule Wednesday

6:00 p.m. to 10 p.m. (One hour for lunch)

Dates May 24, 31; June 7, 14, 21, 28
Prerequisites SQL – Beginner, or working knowledge of relational databases (database design skills)
Target Audience Participants interested in acquiring the  knowledge and skills needed to implement a Microsoft SQL Server database
Instructor Khattar Daou
Location Brittain Hall – BH-214

NB. This is a non-credit course. Certificate provided for all participants who have completed 80% of course hours

*Textbook: SQL Server 2014 Development Essentials | Basit A. Masood-Al-Farooq | ISBN 978-1-78217-255-0 © 2014 Packt Publishing

Course Description:

The course focuses on teaching individuals how to use SQL Server product features and tools related to implementing a database server.  This training provides 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.

Topics to be covered:

  • 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