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.

1. Install the Localhost test server
2. Introduction to WAMP
3. Introduction to MySQL
4. Introduction to Joomla-like CMS.
5. Configure the site in Joomla.
    

2. Relational Database Design in MySQL

1. Design of a relational model
2. Relate tables and subtables.
3. Create a relational model
4. Data import.
    

3. Design of Queries and reports

1. Queries in MySQL

• Of selection
• Upgrade
• Of elimination
• Filter criteria
• Calculated fields

2. Add components to the Joomla CMS
3.Configure a CRM in Joomla.
4. Reports based on inquiries
 

4. Solution design and deployment

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

 

Show more