Diseño de Sistemas de información gerencial para Internet con MySQL / PHP y Joomla

Description

In this course, you will learn:

• WAMP can be used to set up a localhost test server (Windows, Apache, MySQL, PHP).
• With a Joomla Content Management System, you may set up and maintain a web-based content management (CMS).
• In MySQL, create and link tables, subtables, and encoding tables (Relational Database).
• In the Joomla configuration interface, you may create dynamic pages and manage users.
• Using PHP/MySQL computer code, automate procedures.
• Create queries that process and/or calculate interrelated data and then export the results.

Syllabus:

1. Installation, configuration, and introduction to the programs.

• Install the Localhost test server
• Introduction to WAMP
• Introduction to MySQL
• Introduction to Joomla-like CMS.
• Configure the site in Joomla.

2. Relational Database Design in MySQL

• Design of a relational model
• Relate tables and subtables.
• Create a relational model
• Data import.

3. Design of Queries and reports

• Queries in MySQL
• Add components to the Joomla CMS
• Configure a CRM in Joomla.
• Reports based on inquiries

4. Solution design and deployment

• Design of forms, subforms, and CRM.
• Website customization and design.
• Migration to an internet server.

Show more