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 2016 - Online/Distance (CRN - 4858)
- CRN: 4858
- Instructor: Berry, Glenn
- Credits: 4
- Delivery: Online/Distance
- Location: ONLINE
Textbooks and/or materials information for your course may be found at: ttp://www.bkstr.com/denverstore/shop/textbooks-and-course-materials
Required Textbook(s):Microsoft SQL Server 2012 T-SQL Fundamentals; Itzik Ben-Gan; Microsoft Press, 2012; ISBN13: 978-0735658141
Pre-Class Assignment:Read the first two chapters in the text book.
Please check Canvas one week before class begins for any pre-class assignments; https://canvas.du.edu