ICT 714 - Building Database Applications with Microsoft ADO.NET and C#

Delivery Options Online Synchronous

UCalgary Continuing Education

Course Description

This course provides students with the essential skills to build database applications using modern development technologies and practices.

Course Details

Database applications are critical technologies in any organization. These applications enable retrieving and updating of data in a database, while providing an easy and intuitive interface to the users. A well-designed application separates code into three layers of presentation, business logic, and data access which allows for easy maintenance, scalability and modifications.

Using Microsoft .NET technology, C# programming language and Visual Studio IDE, this course covers creating database applications, both windows and web-based, using Entity Framework Core, Language Integrated Queries (LINQ), ADO.NET objects, and database-stored procedures and functions. Advanced topics like transaction procession and handling concurrency conflicts are included.

The database used in this course is Microsoft SQL Server, but the same techniques can be applied to work with any database management system like Oracle, MySQL or PostgreSQL.

Database programming concepts covered in this course are transferable to other programming environments, like Java and Ruby.

Course Level Learning Outcomes

By completion of this course, successful students will be able to:

Create three-layer windows and web applications capable of processing and manipulating data from a database

Topics of Instruction

Introduction to database processing in .NETCore
Three-layer application design
Introduction to Entity Framework Core
Language Integrated Queries (LINQ)
Binding Controls
Handling concurrency conflicts
Using ADO.NET to write data access code
Working with database-stored code objects: procedures and functions
Processing transactions
Using Entity Framework in ASP.NET Core MVC Web Applications

Notes

For the best experience, your computer and internet connection should meet certain requirements. See the recommended requirements...

Prerequisites

ICT 710 Computer Programming Level 1 (completed before course start)
ICT 128 Relational Databases Fundamentals (completed before course start)

A minimum of 6 months experience working with C# and relational databases (SQL)
Familiarity with object-oriented programming concepts

Applies Towards the Following Program(s)

Certificate in .NET Application Development : Optional Courses

Enrol Now - Select a section to enrol in

ICT 714 - 012

Sep 25, 2025

Online Synchronous

Available

Online Synchronous

6:00PM to 9:00PM

Sep 25, 2025 to Nov 27, 2025

Schedule and Location

View Details

30.0

Online Synchronous

Flat Fee non-credit

$879.00

Required Software

Visual Studio 2019

Reading List / Textbook

Murach’s C# (7th Edition) 2016
Anne Boehm and Joel Murach; 7th Edition, ISBN 978-1-943872-53-4

Please note: ICT textbooks are not available through the University of Calgary bookstore.

Section Notes

Classes are held online in real time (Mountain Time) at the specified time and dates.

You will require access to a computer with an Internet connection, a headset with speakers and microphone, webcam, and a monitor large enough to display multiple applications (or the use of two monitors).

This course uses:

Desire2Learn (D2L), an online learning management system. The instructor will post your course outline and other materials in D2L.
Zoom web conferencing software.
A virtual lab with VMware Horizon, a platform that provides access to virtual applications including the latest software for the course. You will be provided with a VMware account and login information once the course starts.

For the best experience, your computer and internet connection should meet certain requirements. See the recommended requirements...

For more information, please visit our Online Learning Resources.

Unless notified, all online courses are available at 9 am MT the day before the start date. Students who register on (or after) the start date will receive access within one day of registration.

Unless otherwise stated, notice of withdrawal or transfer from a course must be received at least seven calendar days prior to the start date of the course.