Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.Read | CRUD Operations with MySQL
Introduction to .NET with C#

ReadRead

General Syntax

Important Points

  • The OR and AND keywords can be used for joining conditional statements;
  • The * character can be used for selecting all the columns in a SELECT statement.

question-icon

Which of the following are correct ways of writing a SELECT statement?

Select a few correct answers

Everything was clear?

Section 4. Chapter 7
course content

Course Content

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?

Introduction to .NET with C#

ReadRead

General Syntax

Important Points

  • The OR and AND keywords can be used for joining conditional statements;
  • The * character can be used for selecting all the columns in a SELECT statement.

question-icon

Which of the following are correct ways of writing a SELECT statement?

Select a few correct answers

Everything was clear?

Section 4. Chapter 7
some-alt