Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.What is a Database? | 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?

bookWhat is a Database?

A Database is a digital storage space for some data. Imagine it as an organized file that contains related data in neatly organized sections. It makes it easy to store and retrieve data.

We typically access and modify databases using a Database Management System (DBMS), which is appropriate for that kind of database.

A Database combined with a Database Management System is sometimes referred to as a Database System.

There are many types of database systems. Some databases store data in the form of rows, columns, and tables - such databases are called Relational Databases. Other types of databases are commonly known as Non-Relational or NoSQL Databases, which may store data in the form of documents, key-value pairs, or some other format.

Most of the applications we use in everyday lives, like websites, social media, etc, make use of relational databases as it is the most popular and robust form of database. Therefore, in this section, we will be using a MySQL Server, which is a powerful database management system that uses SQL.

SQL stands for Structured Query Language, which is a language for interacting with a Relational Database, for example, storing and retrieving information. A MySQL database uses SQL for database operations.

What kind of database is MySQL ?

What kind of database is MySQL ?

Select the correct answer

Everything was clear?

How can we improve it?

Thanks for your feedback!

Section 3. Chapter 1
some-alt