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.
Autumn 2015 - Online/Distance (CRN - 4977)
- CRN: 4977
- Instructor: Berry, Glenn
- Credits: 4
- Delivery: Online/Distance
- Location: ONLINE
Required Textbook(s):Microsoft SQL Server 2012 T-SQL Fundamentals; Itzik Ben-Gan; Microsoft Press, 2012; ISBN: 978-0735658141
Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions; Itzik Ben-Gan; Microsoft Press, 2012; ISBN: 978-0735658363
Pre-Class Assignment:*Read Chapters 1-2 in TSQL Fundamentals
*Sign up with Microsoft Dreamspark. See syllabus for instructions.
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.