EQ SQL (Microsoft Environment) – Intermediate

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

Winter 2020

Day Sessions

Jan 25 - Mar 14Sat

Saturday, Jan 25 - Saturday, Mar 14

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

Additional Information

Teacher: Sebastiano Vacirca
Course Number: 922071
Registration Start Date: Monday, Nov 04, 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: February 16, 2020