Getting Started

Contact Us

Courses & Schedule

Go to Course/Schedule Search

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.


Sections

Autumn 2014 - Online/Distance (CRN - 5312)

Schedule Information

  • CRN: 5312
  • Instructor: Berry, Glenn
  • Credits: 4
  • Date/Time:
  • Delivery: Online/Distance
  • Location: ONLINE

Required Textbook(s):

Microsoft SQL Server 2012 T-SQL Fundamentals; Itzik Ben-Gan; Microsoft Press, 2012.

Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions; Itzik Ben-Gan; Microsoft Press, 2012.

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.

bachelor's of arts completion student experience video

Student Experience

From start to finish, the Bachelor of Arts Completion Program provides an unparalleled experience that helps you do more for your career, family, and community.

university of denver university college online course

See How Our Online Course Works

Online classes are designed and delivered for busy adults seeking a convenient option to pursue education.

university of denver, university college non-credit

Lifelong Learning

Non-credit classes offer diverse, interesting topics from politics to the arts, nature to technology. Stimulate your mind and reawaken your curiosity−all for the love of learning!