mysql tutorial for beginners (1/8) : Introduction to MySQL database @SafaaAlaa
mysql tutorial for beginners (1/8) : Introduction to MySQL database  @SafaaAlaa
Uploaded January 2016 | Updated November 2026, 53 minutes ago
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:
----------------------------------------------------------------------------
youtube.com/subscription_center?add_user=saf3al2a

SWE.Safaa Al-Hayali - saf3al2a
mysql tutorial for beginners (1/8) : Introduction to MySQL databaseFirebase Android Tutorial [2/5] : Reading Data From Realtime Databasejdbc : apache tomcat & mysql : java.lang.ClassNotFoundException: com.mysql.jdbc.DriverFix missing Connect app in Windows 10How To Fix Unable to save permission changes - Access is denied[SOLVED] How To Delete troublesome Files or Folders That Wont Delete In Windows 7, 8 & 8.1Windows 10 – How to enable built-in Administrator accountHow to Delete Gmail Account PermanentlyHow To Build and Deploy Free Google AppHow to Make Subtitle for a Video or Audio with Free Subtitle EditAndroid Tutorial #4 - Passing Data Between Child And Parent ActivitiesHow to claim a custom YouTube URL without 100 subscribers
Safaa Al-Hayali (Safaa Alaa) |

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

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER