01 MySQL Tutorial for Beginners: Introduction
MySQL is a computer software which allows one user to connect and work with databases.
In more details a software like MySQL allows the definition, creation, querying, update, and administration of databases.
The correct term for a software like MySQL is "database management system" or DBMS.
MySQL is not the only "database management system" available.
Well-known "database management systems" include:
MySQL, PostgreSQL, Microsoft SQL Server, Oracle, SAP, IBM DB2.
However, MySQL is the world's most widely used open-source one and is a popular choice of database for use in web applications.
Applications which use MySQL databases include: Joomla, WordPress, and Drupal.
MySQL is also used in many large-scale websites, including Google, Facebook, Twitter and YouTube.
When you access a MySQL database, that system is a "client/server system".
In a "client/server system", there is a server and arbitrarily many clients, which are connected to the server and communicate with it. The Databases and the "database management system" (in our case MySQL) are stored on the server.
The clients communicate with it through a standard language called "SQL".
In other words, the client sends a "SQL query" to the DBMS on the server, the DBMS interprets the query and sends the results back to the client.
SQL is a standard programming language used to communicate with a database.
Although SQL is a standard programming language,there are many different versions of it.
Each DBMS has its own SQL “dialect” that may include extensions or variations to the standards. However, the most basic SQL statements are the same for all SQL dialects.
As a result, once you have learned one of those dialect (for instance MySQL), you can easily learn the other ones.
A database is a collection of data or informations that is organized so that it can easily be accessed, managed, and updated.
In 1970, Edgar Frank Codd developed a model for a new type of database called a "relational database".
By using the "relational model", you can view and manipulate data in a way that is both intuitive and efficient.
Today, "relational databases" are the "standard" for database applications.
The model for a relational database states that data is stored in one or more TABLES.
Each table consists of ROWS and COLUMNS.
EXERCISES for your SELF-TRAINING:
SCRIPT FOR THE EXAMPLES:
SUBSCRIBE!
FACEBOOK
GOOGLE+
Смотрите видео 01 MySQL Tutorial for Beginners: Introduction онлайн без регистрации, длительностью 07 минут 20 секунд в хорошем hd качестве. Это видео добавил пользователь golearnfast 02 Ноябрь 2015, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 10 тысяч раз и оно понравилось 7 людям.