Querying Data with Transact-SQL: 761 COMP 9691 Continuous Intake Online Email to a Friend Our Querying Data with Transact-SQL: 761 course teaches you how to retrieve, insert and delete data from a relational database using Transact-SQL. Learn how 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, and explore the concepts of creating and using stored procedures. This introductory database administration 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) Course Delivery Method: This is an online course with continuous intake registration. That means this course does not have traditional start/end dates. You can register at any time throughout the year (24 hours a day, 7 days a week), and you will have 120 calendar days from the day you receive the course details to complete the course. 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). Make sure you are familiar with the basic technology requirements for online courses. Course Essentials: You will be required to have your own Microsoft SQL Server 2016 Express Edition software (which can be downloaded for free from Microsoft). This software requires a computer with 2 GHz processor or greater, 8 GB RAM or greater and a Microsoft Windows 8 (64-bit) operating system or higher. (You can complete this course using a 32-bit operating system but, if you wish to move on from this course, you will need a 64-bit operating system.) Contact Information 416-415-5000, ext. 4861 firstname.lastname@example.org Course Section(s) Available CRN: S83119 Date(s) 30 Apr 2018 – 26 Aug 2018 Hours: 42 Fee: $429 (includes $100 in [non-refundable] materials [online access]) Register Now CRN: F17426 Date(s) 27 Aug 2018 – 31 Dec 2018 Hours: 42 Fee: $438 (includes $100 in [non-refundable] materials [online access]) Register Now CRN: W52667 Date(s) 01 Jan 2019 – 28 Apr 2019 Hours: 42 Fee: $438 (includes $100 in [non-refundable] materials [online access]) Register Now CRN: S83419 Date(s) 29 Apr 2019 – 25 Aug 2019 Hours: 42 Fee: $438 (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.