CERTIFICATES
SQL Programming with Transact-SQL
OVERVIEW
This certificate is intended for SQL Server programmers or database administrators, system engineers, and developers with or without prior experience who are seeking to validate their skills and knowledge in writing queries and extracting data for reporting purposes. Our certificate helps you learn how to use SQL to store, query, and manipulate data. SQL is a special-purpose programming language designed to manage data in a relational database and is used by many apps and organizations across the globe.
- 6th February 2023
- 36 hours
- Contact the Advisor
- Talk to an Advisor
Instructor led
KEY FEATURES
Get trained by industry Experts
Official Certifcation curriculam
Tax Credit
Claim up to 25% of tuition fees and education tax credit.
Discount on Certification Voucher
24/7 Lab access
COURSE OUTLINE
SQL Programming with Transact-SQL
This module introduces SQL Server and its different versions, including cloud versions. It also explains how to connect to SQL Server using SQL Server Management Studio, in addition to describing the elements of T-SQL and their role in writing queries.
This modules examines the fundamentals of the SELECT statement, writing queries that combine data from multiple sources in Microsoft SQL Server, implementing sorting and filtering, and usage of aggregate functions.
This module is designed to introduce students to the various data types SQL Server uses to store data. They also learn about DML queries and some of the many built-in functions in SQL Server.
The focus of this module is to explain several types of subquery and describe how to use the set operators UNION, INTERSECT, and EXCEPT to compare rows between two sets and executing stored procedures. This module also covers programming with SQL and error handling.
SKILLS ACQUIRED
WHO SHOULD APPLY?
While we encourage all interested applicants to apply, to gain acceptance into our Bootcamp you must:
Have a High School Diploma or equivalent, Complete an interview with a member of our Admissions Team, Commit to program and job search requirements.
SQL Programming with Transact-SQL Certification.
Upon completing this course, you will receive an industry-recognized certificate from MCIT.
- Receive an industry-recognized certificate from MCIT.
- Be prepared to take the official SQl programming with Transact SQL Certification.
INSTRUCTOR SPOTLIGHT
Gregory Shinder
Greg is keen on working with SQL Server, solving performance issues. troubleshoot poor-performing queries, design and implement high availability and disaster recovery solutions. Greg also like to interact with new tech talent and mentor them through his experience. currently assigned at Gentec as a senior Business Intelligence tech lead. Also loves teaching.
