Enrollments are continuing and the students are completing their programs online and getting ready for the employment.
CIMT College is accepting international students applications for upcoming intakes and in person classes starting from August 2020.

info@cimtcollege.com
905-671-9999

Querying Microsoft SQL Server

Microsoft Course - 20461

This instructor led course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2014. This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. The main purpose of the course is to prepare people for the exam "70-461: Writing Queries Using Microsoft® SQL Server® 2014 Transact-SQL." This exam will be the underlying exam for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence.

Microsoft Imagine Academy - Querying Microsoft SQL Server Exam Courses Certification Training in Mississauga, Brampton, Toronto, Scarborough

NEXT COURSE START DATES

Call for Online Schedule

Select Campus/Location

START DATE	END DATE	DAY	TIMING	CAMPUS	STATUS	REGISTER

View All Schedules

Contact us directly for other start dates

Seats Available

Limited Seats

Class Full

PRE-REQUISITES:

Working knowledge of relational databases.
Basic knowledge of the Microsoft Windows operating

COURSE OUTLINE

Introduction to Microsoft SQL Server 2014
Introduction to T-SQL Querying
Writing SELECT Queries
Querying Multiple Tables
Sorting and Filtering Data
Working with SQL Server 2014 Data Types
Using DML to Modify Data
Using Built-In Functions
Grouping and Aggregating Data
Using Subqueries
Using Table Expressions
Using Set Operators
Using Window Ranking, Offset, and Aggregate Functions
Pivoting and Grouping Sets
Querying data with Stored Procedures
Programming with T-SQL
Implementing Error Handling
Implementing Transactions
Improving Query Performance
Querying SQL Server Metadata

This course prepares students for

EXAM 70-461

Ask about our diploma programs for job oriented studies

Duration	40 Hours
Course Fees	Contact Us
Faculty	IT
Course Level	Beginner
Features	In Class, Lab, Hands-on Training
Language	English

Quick Application Form

First Name

Last Name

Phone Number

E-mail

Applying For

Campus

Message

Attend a FREE CLASS for any diploma program

Call Now

CIMT College - Mississauga, Brampton, Toronto, Scarborough - Celebrating 20 Years

International Students Click Here

INTERNATIONAL STUDENTS

Promotions from Cimt College Mississauga

OUR PROMOTIONS

Second Career Ontario cimt college

SECOND CAREER

become an agent for cimt college

BECOME OUR AGENT

Download Student Handbook of Cimt College

Download Course Calendar of Cimt College

Careers Start At Cimt College - Mississauga, Brampton, Toronto

AFFILIATED PARTNERS

Our Affiliated Partners