Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.CREATE - Part I | CRUD Operations with MySQL
course content

Contenido del Curso

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#

CREATE - Part ICREATE - Part I

CREATE Statement:

Table Creation Syntax:

Basic SQL Datatypes:

The CREATE operation is a Non-Query operation, so we execute these statements as non-queries.

What of the following is a correct SQL statement?

Selecciona la respuesta correcta

¿Todo estuvo claro?

Sección 4. Capítulo 3
course content

Contenido del Curso

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#

CREATE - Part ICREATE - Part I

CREATE Statement:

Table Creation Syntax:

Basic SQL Datatypes:

The CREATE operation is a Non-Query operation, so we execute these statements as non-queries.

What of the following is a correct SQL statement?

Selecciona la respuesta correcta

¿Todo estuvo claro?

Sección 4. Capítulo 3
some-alt