Home > Courses > SQL Querying - Advanced Querying Level 2
Upcoming Classes| Start Date | Time | Duration | Location | Cost | Purchase |
|---|
| 10/21/2010 | 8:30 am -
4:30 pm | 1 Day | Syracuse | $299 | | | 11/18/2010 | 8:30 am -
4:30 pm | 1 Day | Rochester | $299 | | | 01/05/2011 | 8:30 am -
4:30 pm | 1 Day | Syracuse | $299 | | | 01/26/2011 | 8:30 am -
4:30 pm | 1 Day | Rochester | $299 | |
Don't see dates for this class? Please contact us or request that we add it to our schedule. Methods of DeliveryThis course can be delivered via the following learning methods:OverviewIn this course, students create advanced SQL queries, and manipulate and index tables.At Course CompletionUpon successful completion of this course, students will be able to: - Use subqueries to generate query output. - Manipulate table data by inserting, updating, and deleting records in a table. - Manipulate the table structure. - Create views, manipulate data through views, modify the view structure, and drop views. - Create indices on table columns and drop inefficient indices. - Mark the beginning of a transaction, create a savepoint within a transaction, rollback a transaction, and commit a transaction.Pre-RequisitesSQL Querying - Fundamentals of Querying Level 1
Previous Page
New Search |
