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 2015 - On campus (CRN - 1763)
- CRN: 1763
- Instructor: Berry, Glenn
- Credits: 4
- Date/Time: M - 06/08 - 08/13, 6:00 pm to 9:00 pm
- Delivery: On campus
- Location: STURM HALL 335
Microsoft SQL Server 2012 T-SQL Fundamentals; Itzik Ben-Gan; Microsoft Press, 2012; ISBN-13: 978-0735658141
Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions; Itzik Ben-Gan; Microsoft Press, 2012; ISBN-13: 978-0735658363
Read the first two chapters of Microsoft SQL Server 2012 T-SQL Fundamentals.
Please check Canvas one week before class begins for any pre-class assignments; https://canvas.du.edu
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.