Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.Setting Up A MySQL Server | Introduction to Databases with .NET
Introduction to .NET with C#
course content

Course Content

Introduction to .NET with C#

Introduction to .NET with C#

1. Introduction
What is the .NET Platform exactly?Creating a Console ApplicationTaking input from the UserTask - Building a Simple CalculatorDealing with Exceptions caused by User InputTask - Improving the CalculatorReading FilesWriting FilesTask - File Based Calculator
2. Asynchronous Programming and Introduction to Web Services
What is Asynchronous Programming?Implementing an Asynchronous MethodTask - Asynchronously Reading FilesIntroduction to APIsMaking a GET RequestTask - Using an APIHandling Exceptions caused by HTTP RequestTask - Exception Handling for API Response
3. Introduction to Databases with .NET
What is a Database?Structure of a Relational DatabaseSetting Up A MySQL ServerConnecting to the MySQL ServerTask - Writing Connection StringsExecuting CommandsTask - Executing MySQL CommandsMySqlCommand MethodsTask - Connecting to a MySQL Database and Executing Commands
4. CRUD Operations with MySQL
Introduction to CRUD OperationsInstalling & Using MySQL WorkbenchCREATE - Part ITask - Using CREATECREATE - Part IITask - Using INSERTReadTask - Using SELECTUpdateTask - Using UPDATEDelete - Part IDelete - Part IITask - Using DELETE
5. Optimizing Database Operations
Stored ProceduresTask - Executing Stored ProceduresDataReader vs DataSetDataAdapter & DataSetTask - Reading Tables using MySqlDataAdapterWhat's Next?

bookSetting Up A MySQL Server

The name of the NuGet Package is MySql.Data by Oracle.

Summary:

  • Install the MySQL Community Server and configure it;
  • During configuration, set the root password;
  • Create a new .NET Console App project;
  • Install MySql.Data Package.

Everything was clear?

How can we improve it?

Thanks for your feedback!

Section 3. Chapter 3
some-alt