DMA MYPH - MYSQL and PHP Developing Dynamic Web Applications

OBIETTIVI:

• Describe the LAMP architecture
• Use the basic components of PHP to build a foundation for more complex web applications
• Understand the basic components of MySQL
• Use SQL query commands to retrieve data from the MYSQL database
• Change table data using the SQL Data Manipulation Language (DML) commands
• Copyright © 2013, Oracle. All rights reserved. Page 1
• Retrieve data from multiple MySQL tables using Joins
• Create web based forms that interact with the end user and the data within MySQL
• Use session handling to authenticate and monitor user identities
• Describe the purpose of template systems

PROGRAMMA:

• MySQL Overview
• MySQL Products
• MySQL Services
• MySQL Enterprise Services
• Supported Operating Systems
• MySQL Certification Program
• Training Curriculum Paths
• MySQL Website
• LAMP
• LAMP Architecture
• Apache Server
• The MySQL Database
• PHP
• Installing XAMPP
• PHP Foundations
• Delimit PHP code within HTML
• Comment PHP code
• Construct Feedback
• Use the Data Types available in PHP
• Use Key Control Statements
• Develop Reusable Code with user defined functions
• MySQL Foundations
• General Architecture
• MySQL client
• Tables
• Storage Engines
• SELECT statement
• Aggregate queries
• PHP Connecting to MySQL
• Establish and close a connection to the MySQL server from PHP
• Retrieve and display data from the MySQL server
• Linking Between Tables
• Define and create an HTML link
• Create the ability to pass information between web pages
• Link dynamic pages to other pages
• SQL DML
• Use the INSERT statement
• Use the UPDATE statement
• Use the REPLACE statement
• Use the DELETE statement
• Forms
• Create and design HTML web forms
• Update data in a MySQL database using a web form
• Delete MySQL data with PHP
• Insert new records in MySQL using web forms
• Joins
• Describe the concept of a Join
• Connect Data from Multiple Tables using Joins
• Resolve Name Clashes when Joining Tables
• Session Handling
• Describe Session Handling
• Use Session Handling Tasks
• Database Authentication
• Common Techniques
• Template Systems
• Smarty Template System

ESERCITAZIONI E SUPERAMENTO:

All’interno di ogni modulo vi sono dei momenti di autovalutazione non vincolati che consentono all’utente di interagire con l’animazione verificando l’apprendimento dei concetti presentati. Il corso viene considerato concluso una volta fruiti tutti i contenuti.

DESTINATARI:

Developers who use PHP and MySQL to build and maintain their websites.
Developers who want to learn how PHP and MySQL can be used to rapidly prototype and deploy dynamic websites.

PREREQUISITI:

• Some experience with relational databases
• Understand how HTML files are assembled
• Understand fundamental PHP syntax
• Have some programming experience (preferably PHP)

ATTESTATO:

Attestato di frequenza