Skip to Content
Course

Database Programming in .NET

CSE-41197

An essential part of most .NET applications, especially line of business software, is the ability to interact with relational databases.

Two principal frameworks that are available to .NET developers: ADO.NET and Entity Framework will be introduced in this course. The first is a set of classes that allow database programming at a low level, while the latter is a fully-featured Object-Relational Mapping (ORM) framework.  Participants will obtain practical knowledge on data manipulation in those frameworks while reviewing T-SQL language and discussing the data binding in various .NET UI architectures (ASP .NET and WPF).

Developers with working knowledge of .NET Framework, C# and basic understanding of SQL language will also benefit from this course.

Course Highlights:

  • Relational Databases review and basics of SQL
  • Query-based database programming with ADO.NET
  • Object-oriented database programming with Entity Framework
  • Data binding in Windows and Web applications

 Course Benefits:

  • Understand the relation between relational databases and .NET applications
  • Ability to retrieve data from queries or stored procedures and display them with Windows Presentation Foundation Graphics
  • Add, modify, and delete data from any .NET application
  • Build visual models that auto-generate data access code

 Software:

  • Windows 10 Pro or Enterprise recommended.  While Windows 10 Home will work for C# I, the more advanced C# courses will require Pro or higher.
  • Visual Studio Community Edition 2017 or later which is freely available on Microsoft's website: https://www.visualstudio.com/

 Hardware:

  • Intel/AMD multi-core processor (i3 or better processor)
  • 8GB RAM minimum, 16GB preferred
  • 50GB free hard drive space for Visual Studio and project files

Course Typically Offered: Online during Winter and Summer quarter

Prerequisites:  Working knowledge of Visual Studio, basic understanding of relational databases and SQL language.

Next steps:  Upon completion of this course, consider taking other courses in the C# Programming Certificate.

More information: Contact infotech@ucsd.edu to learn more about C# Programming and course offerings.

Course Information

Online
3.00 units
$745.00

Course sessions

Add To Cart

Section ID:

185697

Class type:

Online Asynchronous.

This course is entirely web-based and to be completed asynchronously between the published course start and end dates. Synchronous attendance is NOT required.
You will have access to your online course on the published start date OR 1 business day after your enrollment is confirmed if you enroll on or after the published start date.

Textbooks:

No textbook required.

Policies:

  • No refunds after: 1/13/2025

Schedule:

No information available at this time.
Add To Cart

Instructor: Riyad Mammadov, Ph.D.

Riyad Mammadov, Ph.D.

Director of Applications Development, XDimensional Technologies

Riyad Mammadov is a seasoned IS professional with a track record of successful delivery of large-scale enterprise level distributed systems. With experience in energy, automotive and financial services sectors, he is currently working as director of applications development at XDimensional Technologies.

Full Bio