Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.CREATE - Part II | 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 IICREATE - Part II

Important Points:

  • The general syntax of the INSERT statement is INSERT INTO table_name (column1, column2, …) VALUES (value1, value2, …);
  • We can use the PRIMARY KEY keyword to convert a column into a primary key;
  • The AUTO_INCREMENT keyword is used to make a column automatically assign incremented values to new rows. This can only be applied to columns that are INT or INT-based data types.
1. Which of the following are correct for creating a table with a primary key which auto increments?
2. What is the correct syntax for inserting new rows into an existing table?

Which of the following are correct for creating a table with a primary key which auto increments?

Selecciona la respuesta correcta

What is the correct syntax for inserting new rows into an existing table?

Selecciona la respuesta correcta

¿Todo estuvo claro?

Sección 4. Capítulo 5
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 IICREATE - Part II

Important Points:

  • The general syntax of the INSERT statement is INSERT INTO table_name (column1, column2, …) VALUES (value1, value2, …);
  • We can use the PRIMARY KEY keyword to convert a column into a primary key;
  • The AUTO_INCREMENT keyword is used to make a column automatically assign incremented values to new rows. This can only be applied to columns that are INT or INT-based data types.
1. Which of the following are correct for creating a table with a primary key which auto increments?
2. What is the correct syntax for inserting new rows into an existing table?

Which of the following are correct for creating a table with a primary key which auto increments?

Selecciona la respuesta correcta

What is the correct syntax for inserting new rows into an existing table?

Selecciona la respuesta correcta

¿Todo estuvo claro?

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