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

Not offered this semester. Please let us know if you're interested in the course Consult the complete course offering at montezdeniveau.ca

Return to all Emploi Quebec courses


Other Categories

Last Modified: July 18, 2019