SQL – Intermediate (Section 2)

register-button24

Return to schedule

 

Course Title SQL – Intermediate (Section 2)
Course Number 900-006-EQ
Platform Windows
Duration 24 hours
Emploi-Québec fee (taxes incl.)
$48
General Public fee (taxes incl.)
$541.39
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
Instructor Khattar Daou
Location Brittain Hall – BH-214

NB. This is a non-credit course. Certificate provided for all participants who have completed 80% of course hours

Course Description:

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
TOP