Developing SQL Databases (762) COMP 9696 New Email to a Friend Our Developing SQL Databases (762) course teaches you how to create a database that will be able to grow with changing data storage needs. Learn the different data types available within SQL and how to create efficient tables within a database. Explore database normalization and the creation of related tables; how to partition large tables; how to create and manage constraints in order to ensure data integrity; how to optimize tables through indexes; and how to create views in order to simplify data retrieval. Investigate advanced stored procedures, functions, triggers and transactions. Also learn how to employ SQL maintenance to track data concurrency and performance. 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 online Developing SQL Databases (762) course. Prerequisite(s) You must have completed our COMP 9690 Querying Data with Transact-SQL (761)/COMP 9691 Querying Data with Transact-SQL (761) course or an approved equivalent. Contact Information 416-415-5000, ext. 4861 email@example.com Course Section(s) Available Class dates and registration for the upcoming year (September 2018 to August 2019) will be available on this website on Wednesday, July 4, 2018. Please visit this page again on that date. 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.