ICT 4462 - Transact-SQL Programming
Transact-SQL is the primary programming interface between applications and the Microsoft SQL Server database. Transact-SQL can be sent from programs or applications to the SQL Server database or can be built into reusable database stored procedures. This course focuses on Transact-SQL in a stored procedure context. Topics include: basic and advanced SQL, SQL functions, stored procedure declaration and execution, cursors, temp tables, error handling, transaction management, security, and performance issues. The course uses a combination of lecture, textbook reading assignments, and hands-on lab assignments to meet its objectives. Prerequisites: ICT 4300, ICT 4405.
Summer 2013 - On campus (CRN - 1498)
- CRN: 1498
- Instructor: Berry, Glenn
- Credits: 4
- Date/Time: W - 06/12 - 08/15, 6:00 pm to 9:00 pm
- Delivery: On campus
- Location: STURM HALL 410
Required Textbooks:Microsoft SQL Server 2012 T-SQL Fundamentals; Itzik Ben-Gan; Microsoft Press, 2012; ISBN: 978-0-7356-58141.
Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions; Itzik Ben-Gan; Microsoft Press, 2012; ISBN: 978-0-7356-58363
Pre-Class Assignment:The pre-class assignment is to read Chapter 1 in Microsoft SQL Server 2012 T-SQL Fundamentals.
Please check eCollege one week before class begins for any pre-class assignments; www.ucolonline.com
If you wish to buy your books via the DU bookstore, please check their online site at "the DU Bookstore" to make sure your books are in stock before coming to campus or ordering online.