C# .NET Database and XML Applications

Name: C# .NET Database and XML Applications
Rating: 4.4 (118 reviews)

Implementing Real-World Examples

Created byRick Phillips

Last updated 1/2020

English

What you'll learn

In this course students will learn how to interface their C# programs to a relational database and external XML files.

Course content

5 sections • 15 lectures • 3h 47m total length

Introduction9:10
In this lecture the student will be introduced to the goals and purpose of the course. The lecture will include a description of what the course will cover, who should take the course and the course prerequisites.
Software Setup18:06

Relational Theory17:13
In this lecture the student will learn how information is organized within a relational database system and why that type of organization is essential to maintaining data quality.
Relational Theory Quiz
SQL Part 113:32
In this lecture the learner will be introduced to the structured query language (SQL).
SQL Quiz
SQL Part 218:49
In this lecture the learner will continue to explore the SQL programming language.
SQL Part 2 Quiz

Establishing the Connection11:16
In this lecture the learner will be shown how to establish a connection between their C# application and a SQL Server database.
Lecture 6 Quiz
Parent-Child Example13:21
In this lecture we implement a parent-child database relation within a C# application.
Lecture 7 Quiz
Updating the Database18:23
In this lecture the learner is introduced to database updates within C# via SQL.
Lecture 8 Quiz
Stored Procedures16:59
In this lecture the learning is taught how to retrieve data from a database via database stored procedures.
Lecture 9 Quiz
Parent-Child Stored Procedures14:34
In this lecture we create a parent-child GUI from stored procedures in the database.
Lecture 10 Quiz
Parent-Child Stored Procedures Part 217:29
In this lecture we continue with our parent-child stored procedure example.
Lecture 11 Quiz
Parent-Child Stored Procedure Example Part 312:18
This lecture concludes our discussion of the parent-child stored procedure example.
Lecure 12 Quiz

Requirements

The successful student will already possess basic C# programming and GUI skills and knowledge.

Description

In this course the student will learn how to interface their C# applications to a relational database and/or external XML files. The course contains five primary sections: introduction and setup, relational theory, C# to RDBMS, C# to XML and a summary.

The course is taught by Dr. Rick Phillips, Ph.D. who possess over 25 years of software design and programming experience. Rick has also taught a number of other IT courses through Udemy.

This course assumes a basic understanding of the C# programming language.

Who this course is for:

Intermediate (1-2 years of experience or my 2 prior courses) C# programming experience is required for this course.

C# .NET Database and XML Applications

What you'll learn

Explore related topics

Course content

Introduction2 lectures • 27min

Relational Database Theory3 lectures • 50min

C# to RDBMS7 lectures • 1hr 44min

C# to XML2 lectures • 32min

Course Summary1 lecture • 14min

Requirements

Description

Who this course is for: