mysql tutorial for beginners (1/8) : Introduction to MySQL database

Описание к видео mysql tutorial for beginners (1/8) : Introduction to MySQL database

mysql tutorial for beginners (1/8) : Introduction to MySQL database
Introduction to MySQL database

Database, As the word indicates, a database is basically a base of data, or, if you prefer, a set of data with a structure that is similar to real-life situations stored in a computer system, and organized in such a way that it can be quickly searched and information can be rapidly retrieved.

It allows you to store any type of information you need, and it can be accessed by any user with the proper rights.
MySQL is probably the most popular database management system for web servers. Developed in the mid-1990s,

One reason for its success must be the fact that, like PHP, it’s free to use. But it’s also extremely powerful and exceptionally fast—it can run on even the most basic of hardware,

MySQL is also highly scalable, which means that it can grow with your website
The SQL in MySQL stands for Structured Query Language.
This language is loosely based on English and also used in other databases such as Oracle and Microsoft SQL Server.

It is designed to allow simple requests from a database via commands such as:
SELECT surname FROM students WHERE name = 'Safaa';

A MySQL database contains one or more tables,
Each of table contains records or rows.
Within these rows are various columns or fields that contain the data itself.

The Entity Relationship Model
An entity is a real-life object, such as, for example, Me, You, we are belongs to the same entity type “Humans”
An entity type defines a group of entities with the same characteristics like "students", “workers”

Entities can be related through relationships usually named as actions.

Each entity type has a set of attributes that help define different entities at the same time.

For example, first name and email would be attributes of the entity type “students."

Relationships between entities have a complexity of either 1:1, l:n
(or n:1), or n:m.

If you have a 1:1 relationship between an Entity1 and Entity2, this means that for each entity of the type Entity1 there will be a
single entity of type Entity2 related to it and vice versa.

A relationship of 1:n would mean that an entity of type Entity1 can have n (a number of) associated entities of type Entity2, but a single element of Entity2 can be associated with only a single item of Entity1.

The relationship n:1 is the reverse of 1:n.
Finally, a relationship n:m means that an item of Entity1 can be related to many items of Entity2, and an item of Entity2 can be related to many items of Entity1.

To make these relationships more clear and simple to understand, let’s take More Practical Example on the next tutorial.


Subscribe for more:
----------------------------------------------------------------------------
https://www.youtube.com/subscription_...

SWE.Safaa Al-Hayali - saf3al2a

Комментарии

Информация по комментариям в разработке