EduMaster, s.r.o., skoleni database/ SQL-4405

Školení: SQL-4405

MySQL and PHP - Developing Dynamic Web Applications

  • kurz Oracle
  • délka kurzu: 4 dny
  • cena: 46000 CZK
  • kategorie: Database/MySQL

Nejbližší termíny:

Kurz není v nejbližší době naplánován. Kontaktujte nás a pokusíme se Vám vyjít vstříc.


This MySQL and PHP - Developing Dynamic Web Applications will teach you how to develop applications in PHP and use MySQL efficiently for those applications. Through a hands-on approach, this instructor-led course will help you improve your PHP skills and combine them with time-proven database management techniques to create best-of-breed web applications that are efficient, solid and secure.Students Who Can Benefit from this Course: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.


  • Database Administrators
  • Database Designers


  • Understand how HTML files are assembled
  • Have some knowledge of Object-Oriented Programming
  • Understand fundamental PHP syntax
  • Have some programming experience (preferably PHP)
  • Some experience with relational databases


  • 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
  • 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



  • MySQL Overview
  • MySQL Products
  • MySQL Services
  • MySQL Enterprise Services
  • Supported Operating Systems
  • MySQL Certification Program
  • Training Curriculum Paths
  • MySQL Website


  • 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


  • Use the INSERT statement
  • Use the UPDATE statement
  • Use the REPLACE statement
  • Use the DELETE statement


  • 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


  • 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


  • Course Overview
  • Training and Certification Website
  • Course Evaluation
  • Thank You!
  • QA Session
Získané autorizace:

Ostatní partnerské organizace: