|Course Title||SQL – Intermediate (Section 2)
|Emploi-Québec fee (taxes incl.)
|General Public fee (taxes incl.)
|Schedule||Monday and Wednesday 6:00 p.m. to 10:00 p.m.
Lunch 30 mins.
|Dates||November 27, 29; December 4, 6, 11, 13|
|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-214|
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