inflearn logo
inflearn logo

C# ADO.NET Database Programming

This course is mainly about ADO.NET and will be practiced with WinForms programs using the C# language. In addition, it will explain various fields such as database design, SQL writing, stored procedure writing, and libraries and transactions created with ADO.NET through practical programming through sample projects.

(4.6) 14 reviews

184 learners

Level Intermediate

Course period Unlimited

ADO.NET
ADO.NET
ADO.NET
ADO.NET
날개 달린 동전

Recommend Course to grow and earn commission!

날개 달린 동전

Marketing Partners

Recommend Course to grow and earn commission!

Reviews from Early Learners

Reviews from Early Learners

4.6

5.0

david kim

100% enrolled

Thank you for the very helpful lecture

5.0

luckyctj

100% enrolled

As a beginner who just started learning C#, I was looking for a course to advance to an intermediate level. I think this was the course I took. I think it will be a great help in improving my skills. Thank you for the great course.

5.0

Callahan Park

31% enrolled

Very good

What you will gain after the course

  • Learn how to use the database project provided in Visual Studio.

  • Database Programming

  • Dapper

To develop an actual DB linkage program
You will learn advanced ADO.NET techniques.

Database Programming with C#

This course comprehensively covers the essentials for developing database-linked programs, whether you're an experienced programmer or have completed prerequisite courses. Because it uses an approach that involves developing actual projects, beginners can quickly learn a significant number of advanced techniques. While some parts may be confusing, please feel free to ask questions using the Q&A board, and I'll be happy to answer them.

The main focus of the course is ADO.NET. It also covers database design, stored procedure writing, and other topics. It also covers using ADO.NET in C# programs to connect to database servers, as well as developing the database connection library we'll use. Because we chose to use Windows Forms to verify the results of our development, we won't cover a complete Windows Forms program from start to finish.

📕 Course Introduction

This course is designed for those who have taken or are familiar with courses on database SQL, database design, and C# programming fundamentals. Since the aforementioned courses cover only specific areas, it's crucial to have a comprehensive understanding of how databases work, how SQL is created and expressed in programs, and how programs communicate with database servers. Therefore, this project is structured around selecting a practical project and developing it yourself. However, due to time constraints, we won't cover every single fundamental topic in detail. For these topics, please refer to the prerequisite courses.

📚 Previous lecture

C# Programming Fundamentals
Tips for writing practical programs
Database - SQL
Learning DB from scratch
RDBMS Modeling
Understanding relational database concepts

🙌 Tools covered here

  • VisualStudio 2017 or VisualStudio 2019
  • Microsoft SQL Server 2017

🙋🏻‍♂️ Expected questions related to the lecture

Q. Can non-majors also take the course?
A. Anyone who understands the prerequisite subjects can listen to it sufficiently.

Q. Why should I learn ADO.NET?
A. ADO.NET is a framework for database integration. These days, almost every program doesn't handle databases. It's a necessity, and because ADO.NET provides a standard interface that works with all types of databases, not just SQL Server, its scope of application is broad.

Q. Please tell us what prompted you to start this course.
A. This course is a continuation of the database-related courses we've offered so far and the fundamentals of C# programming. We plan to continue developing a series of C#-related courses in the future.

Recommended for
these people

Who is this course right for?

  • For those who need database programming

  • For those who want to take a database course and apply it in practice

  • For those who want to do full-fledged database programming as a freelancer or developer

Need to know before starting?

  • Database SQL

  • Database Design

Hello
This is kjlee

5,154

Learners

366

Reviews

150

Answers

4.8

Rating

8

Courses

I will provide a brief overview of my educational background and professional experience.

Education

February 1987 Graduated from Inha University, Department of Computer Science and Engineering

February 1989, graduated from the Graduate School of Computer Science and Engineering at Inha University

August 2009 Completed Doctoral Coursework in Applied Software, Department of Computer Engineering, Korea Aerospace University

Key Experience

January 1989 – December 1992 Trigem Computer R&D Center

January 1993 ~ May 1995 Samsung Electronics Workstation Development Team

January 1998 – December 2005 CEO of ITA Co., Ltd. (Software development, database design and construction)

January 2006 – December 2017 National Archives Database Construction Project (PM)

May 2018 – March 2019 Korea IT Academy Instructor (C#, JAVA, Database)

March 2019 – Present: ERP and MES Database Design

More

Reviews

All

14 reviews

4.6

14 reviews

  • rlaehrms74895님의 프로필 이미지
    rlaehrms74895

    Reviews 4

    Average Rating 5.0

    5

    100% enrolled

    Thank you for the very helpful lecture

    • conscious20402636님의 프로필 이미지
      conscious20402636

      Reviews 3

      Average Rating 5.0

      5

      31% enrolled

      Very good

      • marvel님의 프로필 이미지
        marvel

        Reviews 1

        Average Rating 5.0

        5

        100% enrolled

        It was a helpful lecture~

        • changyongchoi7209님의 프로필 이미지
          changyongchoi7209

          Reviews 3

          Average Rating 4.7

          4

          31% enrolled

          Thank you for the good content

          • luckyctj4427님의 프로필 이미지
            luckyctj4427

            Reviews 7

            Average Rating 4.6

            5

            100% enrolled

            As a beginner who just started learning C#, I was looking for a course to advance to an intermediate level. I think this was the course I took. I think it will be a great help in improving my skills. Thank you for the great course.

            kjlee's other courses

            Check out other courses by the instructor!

            $42.90