SQL - Intermediate
About the program
This instructor led course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server. 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 language
- 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
Condition of admission
The admission conditions and the inscription procedures may differ from a CEGEP to another.
You should be ready to provide legal documents such as: a birth certificate, a proof of education (high school or cegep diploma, etc), some grade sheets, a comparative evaluation or a foreign degree, a resume, etc.
As for individuals born outside of Canada, you will have to provide a proof of citizenship or permanent residency.
To receive more details about the consulted program, please visit the website of the establishment offering the training, with the help of the information below.
John Abbott College (Continuing Education)
Course Attestation and Professional Development