*Data management, data retrieval and data export (import & export), the bulk insert command, data transfer services, advanced query techniques, inner join and outer join, subqueries, derived tables. *Cursor to use T-SQL cursors, cursor record, edit, triggers, event triggers that fire. *The trigger types, create a trigger, the INSERT command, trigger management, to do trigger active / passive, ALTER, and DROP commands *View to create restrictions and permissions, use of tables, indexing, cluster and non-cluster indexes, composite and composite indexes, index changes
10985A: Introduction to SQL Databases 20768A: Developing SQL Data Models 20761A: Querying Data with Transact-SQL 20762A: Developing SQL Databases Course 20765A: Provisioning SQL Databases Course 10987A: Performance Tuning and Optimizing SQL Databases