SQL – Intermediate


Return to schedule


Course Title SQL – Intermediate
Course Number 900-006-EQ-02
Platform Windows
Duration 24 hours
Gouvernement du Québec fee (taxes incl.)
General Public fee (taxes incl.)
Schedule Monday & Wednesday; 6 p.m. – 10 p.m.
Dates January 27, 29; February 3, 5, 10, 12
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 Kattar Daou
Location BH-407

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

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