Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
3 Hour(s) 59 Minute(s)
Language
English
Taught by
Peder Thornstrom
Rating
Course Overview
How to create a CRDU application using MySQL Server and Stored Procedures
This course (part 1) will have in total 11 sections.
The course will give you the knowledge of how to use C# to build a full CRUD application using Windows Forms. We will be using Visual Studio 2019 Community edition and create this CRUD application with MySQL Server as the database. We will also be using Stored Procedures that will be executed by a specially defined user.
The course will expand to three parts where we will add another database in part 2. In part 3 we will add capability to use images/photos/logos that we will stored in the database itself. When all parts are complete it’ll extend to another approx. 10-12 sections.
You will find a number of downloads in some of the section /lectures that will help you with some details and definitions. At the end of the course you will also find the source code itself for download.
Tools and development environment can be downloaded for free – full instructions inside this course regards to installation and configuration. You can find more detailed information on my BLOG. See my instructor page for the link.
At the end of this course, you will be confident of writing your own CRUD applications using C# and MySQL Server.
You can also contact me in different ways to have some support, if needed.
Course Content
- 11 section(s)
- 28 lecture(s)
- Section 1 Introduction to PART 1
- Section 2 Download and Install Software
- Section 3 Creation of Database and a Stored Procedure (SP)
- Section 4 Creation of Our Project (Visual Studio)
- Section 5 Read Records from the Database
- Section 6 DataGridView double-click event
- Section 7 Save Or Update Record in the Database
- Section 8 Delete a record from the Database
- Section 9 Helper methods and more...
- Section 10 Search functionality
- Section 11 Wrap-up of this course (part 1)
What You’ll Learn
- C# programming using Windows Forms and MySQL Server as the database and where we will create an Application that can Create, Read, Update and Delete records., Keep the code to a minimum and as simple as possible, You will gain skills using MySQL Server and MySQL Workbench to create, manage the databases, create Stored Procedures and also create users and Privileges.., You will feel more confident using C#, Windows Forms as well as handle MySQL Server in many ways.
Skills covered in this course
Reviews
-
MMike Bartlett
overall ok. Screen resolution needs to be improved. Course is still incomplete as set out initially.
-
MMichał Świerczyński
it's good for beginners like I am.
-
RRolando Roque Kuan
Very good course, instructor explains very well
-
KKrzysztof Dudziec
Everything is great. It's just difficult to read the code from the screen as it's zoomed out too much. But it's still a big, big 5.
