EQ SQL (Microsoft Environment) – Intermediate

Registration: Please contact CTD at eqctd@dawsoncollege.qc.ca to request the form.

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

Price: $48.00

Fall 2019

Day Sessions

Jan 25 - Mar 14Sat

Saturday, Jan 25 - Saturday, Mar 14

DayTimeRoom Number
Saturday09:30 - 12:302F.20
Register Now

Additional Information

Teacher: TBA
Course Number: 922071
Registration Start Date: Monday, Jul 01, 2019
Maximum Class Size: 12
Total Hours: 24
Status: Registration in progress

Evening Sessions

Sep 07 - Nov 02Sat

Saturday, Sep 07 - Saturday, Nov 02

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

Additional Information

Teacher: TBA
Course Number: 922071
Registration Start Date: Monday, Jul 01, 2019
Group Schedule Info: No Class Oct 12
Maximum Class Size: 12
Total Hours: 24
Status: Cancelled

Sep 03 - Oct 22Tue

Tuesday, Sep 03 - Tuesday, Oct 22

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

Additional Information

Teacher: Jonathan Perlman
Course Number: 922071
Registration Start Date: Monday, Jul 01, 2019
Maximum Class Size: 12
Total Hours: 24
Status: Activity in Progress
Consult the complete course offering at montezdeniveau.ca

Return to all Emploi Quebec courses


Other Categories

Last Modified: September 17, 2019