|Course Title||SQL – Intermediate
|Emploi-Québec fee (taxes incl.)
|General Public fee (taxes incl.)
|Schedule||Saturday 9:00 a.m. to 5:30 p.m.
Lunch 30 mins.
|Dates||September 30, October 14, 21 (no class on October 7)|
|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|
|Location||Brittain Hall – BH-408|
NB. This is a non-credit course. Certificate provided for all participants who have completed 80% of course hours
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