Introduction to .NET with C#

Course Content

Introduction to .NET with C#

Introduction to .NET with C#

1. Introduction

What is the .NET Platform exactly?Creating a Console Application Taking input from the User Task - Building a Simple Calculator Dealing with Exceptions caused by User Input Task - Improving the Calculator Reading Files Writing Files Task - File Based Calculator

2. Asynchronous Programming and Introduction to Web Services

What is Asynchronous Programming?Implementing an Asynchronous Method Task - Asynchronously Reading Files Introduction to APIs Making a GET Request Task - Using an API Handling Exceptions caused by HTTP Request Task - Exception Handling for API Response

3. Introduction to Databases with .NET

What is a Database?Structure of a Relational Database Setting Up A MySQL Server Connecting to the MySQL Server Task - Writing Connection Strings Executing Commands Task - Executing MySQL Commands MySqlCommand Methods Task - Connecting to a MySQL Database and Executing Commands

4. CRUD Operations with MySQL

Introduction to CRUD Operations Installing & Using MySQL Workbench CREATE - Part I Task - Using CREATE CREATE - Part II Task - Using INSERT Read Task - Using SELECT Update Task - Using UPDATE Delete - Part I Delete - Part II Task - Using DELETE

5. Optimizing Database Operations

Stored Procedures Task - Executing Stored Procedures DataReader vs DataSet DataAdapter & DataSet Task - Reading Tables using MySqlDataAdapter What's Next?

Connecting to the MySQL Server

Summary:

Import the MySqlClient from MySql.Data;
Create a connection string using the server details;
Use the MySqlConnection class to connect to the server using your connection string.

Everything was clear?

Thanks for your feedback!

Section 3. Chapter 4

Ask AI

Ask anything or try one of the suggested questions to begin our chat

Course Content

Introduction to .NET with C#

Introduction to .NET with C#

1. Introduction

What is the .NET Platform exactly?Creating a Console Application Taking input from the User Task - Building a Simple Calculator Dealing with Exceptions caused by User Input Task - Improving the Calculator Reading Files Writing Files Task - File Based Calculator

2. Asynchronous Programming and Introduction to Web Services

What is Asynchronous Programming?Implementing an Asynchronous Method Task - Asynchronously Reading Files Introduction to APIs Making a GET Request Task - Using an API Handling Exceptions caused by HTTP Request Task - Exception Handling for API Response

3. Introduction to Databases with .NET

What is a Database?Structure of a Relational Database Setting Up A MySQL Server Connecting to the MySQL Server Task - Writing Connection Strings Executing Commands Task - Executing MySQL Commands MySqlCommand Methods Task - Connecting to a MySQL Database and Executing Commands

4. CRUD Operations with MySQL

Introduction to CRUD Operations Installing & Using MySQL Workbench CREATE - Part I Task - Using CREATE CREATE - Part II Task - Using INSERT Read Task - Using SELECT Update Task - Using UPDATE Delete - Part I Delete - Part II Task - Using DELETE

5. Optimizing Database Operations

Stored Procedures Task - Executing Stored Procedures DataReader vs DataSet DataAdapter & DataSet Task - Reading Tables using MySqlDataAdapter What's Next?

Connecting to the MySQL Server

Summary:

Import the MySqlClient from MySql.Data;
Create a connection string using the server details;
Use the MySqlConnection class to connect to the server using your connection string.

Everything was clear?

Thanks for your feedback!

Section 3. Chapter 4

some-alt