Posts in current category

MySQL Getting Started tutorial

May 15, 2021 19:00 MySQL

Table of contents

MySQL Getting Started tutorial

MySQL Getting Started tutorial

MySQL is the most popular relational database management system, and MySQL is one of the best RDBMS (Relational Database Management System: Relational Database Management System) applications for WEB applications.

In this tutorial, you'll get a quick grasp of the basics of MySQL and make it easy to use the MySQL database.

What is a database?

A database is a repository that organizes, stores, and manages data in a data structure.

Each database has one or more different APIs for creating, accessing, managing, searching, and copying saved data.

We can also store data in a file, but it is relatively slow to read and write data in the file.

So now we use a relationship database management system (RDBMS) to store and manage the amount of big data. T he so-called relationship database is a database based on the relationship model, with the help of mathematical concepts and methods such as collection alge while processing the data in the database.

Features of RDBMS, or Relational Database Management System:

  • 1. The data appears as a table
  • 2. Various record names for each behavior
  • 3. The data domain corresponding to each listed record name
  • 4. Many rows and columns make up a form
  • 5. Several forms make up database

RDBMS terminology

Before we get started with the MySQL database, let's look at some of the terms for RDBMS:

  • Database: A database is a collection of associated tables.
  • Data table: A table is a matrix of data. Tables in a database look like a simple spreadsheet.
  • Column: A column (data element) contains the same data, such as postal code data.
  • Row: A row ( or a record) is a set of related data, such as data that a user subscribes to.
  • Redundancy: Stores twice as much data, and redundancy can make the system faster.
  • Primary key: Primary key is unique. A data table can contain only one primary key. You can use the primary key to query the data.
  • Foreign keys: Foreign keys are used to associate two tables.
  • Composite keys: Composite keys (combination keys) use multiple columns as an index key, typically used for composite indexes.
  • Index: Use indexes to quickly access specific information in database tables. A n index is a structure that sorts the values of one or more columns in a database table. A catalog similar to a book.
  • Reference integrity: Reference integrity requires that non-existent entities are not allowed to be referenced in the relationship. Integrity with entities is an integrity constraint that the relationship model must meet in order to ensure data consistency.

MySQL database

MySQL is a related database management system developed by MySQL AB of Sweden and currently owned by Oracle. M ySQL is an associated database management system that saves data in different tables instead of putting all the data in a large warehouse, which increases speed and flexibility.

  • MySQL is open source, so you don't have to pay extra.
  • MySQL supports large databases. You can work with large databases with tens of millions of records.
  • MySQL uses standard SQL data language.
  • MySQL can be allowed on multiple systems and supports multiple languages. These programming languages include C, C, Python, Java, Perl, PHP, Eiffel, Ruby, and Tcl.
  • MySQL has good support for PHP, which is the most popular Web development language.
  • MySQL supports large databases, 50 million recorded data warehouses, 32-bit system table files up to 4GB, and 64-bit systems support up to 8TB.
  • MySQL is customizable, with the GPL protocol, and you can modify the source code to develop your own MySQL system.

What should you know before you start this tutorial?

Before you start this tutorial, you should know the basics of PHP and HTML and be able to apply it simply.

Many of the examples in this tutorial are related to the PHP language, and our examples are basically presented in PHP.

If you don't know PHP yet, you can learn about the language through the PHP tutorial on this site.