MySQL Database 2016 - part 4

How to start MySQL Database revealed!!!
Lecture 4 : Installation demo - part 2

Most interactive websites nowadays require data to be presented dynamically and interactively based on input from the user. For example, a customer may need to log into a retail website to check his purchasing history. In this instance, the website would have stored two types of data in order for the customer to perform the check - the customer's personal login details; and the customer's purchased items. This data can be stored in two types of storage - flat files or databases.

Flat files are only feasible in very low to low volume websites as flat files have 3 inherent weaknesses:

The inability to index the data. This makes it necessary to potentially read ALL the data sequentially. This is a major problem if there are a lot of records in the flat file because the time required to read the flat file is proportionate to the number of records in the flat file.
The inability to efficiently control access by users to the data
The inefficient storage of the data. In most cases, the data would not be encrypted or compressed as this would exacerbate the problem no. 1 above

The alternative which is, in my opinion, the only feasible method, is to store the data in a database. One of the most prevalent databases in use is MySQL. Data that is stored in a database can easily be indexed, managed and stored efficiently. Besides that, most databases also provide a suite of accompanying utilities that allow the database administrator to maintain the database - for example, backup and restore, etc.

Article Source: http://EzineArticles.com/21960

Resources:
http://www.mysql.com/
http://dev.mysql.com/doc/refman/5.6/en/database-use.html
http://dev.mysql.com/doc/refman/5.6/en/create-database.html
http://en.wikipedia.org/wiki/MySQL
http://www.oracle.com/us/products/mysql/overview/index.html
http://www.w3schools.com/php/php_mysql_intro.asp
http://www.thesitewizard.com/faqs/what-is-mysql-database.shtml
http://www.phpmyadmin.net/home_page/index.php

Disclaimer : This video does not represent "MySQL Database 2016" officially. This video tutorial is solely for educational purpose only.

Credits to Udemy

Related Searches :
mysql database download, mysql database pdf, mysql database tutorial, mysql database commands, create mysql database, mysql
database sample, mysql database download for windows, restore mysql database