Developing SQL Databases: 762 COMP 9697 Continuous Intake Distance Learning Online 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 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 Developing SQL Databases: 762 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. Make sure to 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). Also refer to the basic technology requirements for online courses, but note you will be required to obtain your own Microsoft SQL Server 2016 Express Edition (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.) Prerequisite(s) You must have completed our COMP 9690 Querying Data with Transact-SQL: 761 course or our COMP 9691 Querying Data with Transact-SQL: 761 course. (An approved equivalent is also acceptable.) Contact Information 416-415-5000, ext. 4861 firstname.lastname@example.org Course Section(s) Available CRN: S83420 Date(s) 29 Apr 2019 – 25 Aug 2019 Hours: 48 Fee: $523 (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.