Video of the course materials. XAMPP is a development platform for the operating systems Linux, Windows, MacOS X and Solaris that includes Apache, MySQL, PHP and Perl. This course is an introduction to the management of relational databases oriented exploitation on the web. Begins with a brief description of the steps to follow to install Xampp server environment: Apache, Php and MySQL, with a few brief notes on configuration of the database server and the client phpMyAdmin tool. Then, after showing the context in which are relational databases, a guide about the most common operations performed in phpMyAdmin to manage MySQL databases.
Published materials
files
teaching resources
web resources
PDF
doc
HTML
PPT
AVI/mpeg/swf
MP3
topics
practices
exercises
exams
articles
site
docuwiki
blog
Moodle
other
Objectives
Learn to install the Xampp package.
Know the behavior of MySQL and phpMyAdmin configuration method.
The main features of the relational data model to understand intuitively.
Know how to perform the basic operations of creating databases and tables in MySQL through phpMyAdmin.
Contents
XAMPP 1 Xampp 2. Common problems in the installation of Xampp MySQL 3. Brief history of MySQL 4 Xampp-MySQL configuration examples (a) the 'root'@'localhost' account settings (b) change of the phpMyAdmin authentication protocol (c) two MySQL instances on one machine PhpMyAdmin 5. The interface 6. Create tables, insert and delete rows, see tables. 7. Referential integrity and relationships; the "designer" of phpMyAdmin. 8. Modify the structure of the tables. 9. Supports phpMyAdmin when insert and modify data, offering. 10. Other functions of phpMyAdmin.