Querying Data with Transact-SQL (761) COMP 9691 New Continuous Intake Online Email to a Friend Our introductory Querying Data with Transact-SQL (761) course teaches you how to retrieve, insert and delete data from a relational database using Transact-SQL. Learn to query data from single and joined tables, use query filters to retrieve specific data, create insert statements for placing data from multiple tables into a single table and update table data. Develop the ability to maintain data integrity when removing or deleting records from a database. Explore the concepts of creating and using stored procedures. This course can be used as part of your study material for the Microsoft Certified Solutions Associate (MCSA) SQL 2016 database certifications. Also check out our in-class Querying Data with Transact-SQL (761) course. Note(s) This is an online course, and registration is offered through continuous intake (meaning registration is open 24 hours a day, 7 days a week throughout the year). Register in the section (CRN) with the Date(s) range that includes the date on which you plan to start the course (keeping in mind that you will receive your course details approximately a week after you register). You have 120 calendar days from the day you receive the course details to complete the course. Please ensure you are familiar with the basic technology requirements specific for online courses. You will be required to obtain Microsoft SQL Server 2016 Express Edition for this course (which can be downloaded free from Microsoft). This software requires a Windows 64-bit operating system. Contact Information 416-415-5000, ext. 4861 firstname.lastname@example.org Web registration is temporarily unavailable due to a scheduled upgrade starting Friday, June 30, 2017, at 3:30 p.m. We apologize for the inconvenience. Please check back at a later time. Course Section(s) Available CRN: F16965 Date(s) 28 Aug 2017 – 15 Dec 2017 Hours: 42 Fee: $429 (includes $100 in [non-refundable] materials [online access]) Register Now CRN: W52239 Date(s) 08 Jan 2018 – 29 Apr 2018 Hours: 42 Fee: $429 (includes $100 in [non-refundable] materials [online access]) Register Now CRN: S83119 Date(s) 30 Apr 2018 – 26 Aug 2018 Hours: 42 Fee: $429 (includes $100 in [non-refundable] materials [online access]) Register Now Some courses require you to purchase a textbook. The cost of the textbook is not included in the course fee unless otherwise indicated. If there is a textbook assigned for this course, it will be listed on the bookstore website.