Introducción a Xampp y MySQL. OpenCourseWare UA

• HOME
• Arts and Humanities (48)
• Health Sciences (10)
• Experimental Sciences (2)
• Social and legal sciences (94)
• Engineering and architecture (61)

Description

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.