CartConfirm registration and payPersonal FileQuit
Mia Registration Portal
Courses
Computer & Technology
Courses

Data Analytics
Courses

Emploi Quebec
Emploi Quebec (Online registration only)

Languages
English
French
German
Italian
Japanese
Spanish
Korean
Russian
Arabic

Confucius Institute in Quebec
Chinese Language Courses

Photography
Courses

General & Professional Interests
Courses

Testing Center
TEF/TEFAQ

SQL (Environnement Microsoft) - Intermediate 
Cost 563.76$
Age from 16 years
Duration 27 hours


Online registration is closed.


SQL (Environnement Microsoft) - Intermediate
(132075)
From Feb 15th to Apr 11th, 2024
Thursday 18:00 to 21:00, room 2F.20 Laboratory - Computer - Business Admin
Group number W24-132075-1


Prerequisites : SQL Beginner, or equivalent knowledge

Required Material: 2 GB (or higher) Flash (USB) Drive

Take note that if this course is online , you will need a computer with Windows 10 or MacOS X or higher, a headset with a microphone and high-speed internet connection.

The course focuses on teaching individuals how to use SQL Server product features and tools related to implementing a database server. It is designed for students who already possess the technical skills required to write basic Transact-SQL queries.

This course serves as the foundation for all SQL Server-related disciplines, including Database Administration, Database Development, and Business Intelligence

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



Back