Diplomas
Certificates
Courses

MISSION

supervised and delivers only the official training programs for more than 3000 Courses and 480 Certificates, through 30 dedicated Learning Centers in Egypt, Kuwait, and UAE.....

Read more   

learning process

partner of the most world's technology leaders such as: Microsoft, Cisco, Math-Works, CompTia, WiMax, CWNP, Oracle, EC-Council, CIW, Symantec, ETS, Parametric, PearsonVUE, and more ...

Read more   

Warm welcome

WE aimed to improve and develop the human resources to be qualified for job Opportunities. By assure quality through the four basic elements of learning process (Official curriculum, Expert Teaching Staff, Hand-ON labs, Suitable Environment)...

Read more   

Quality assurance

our quality control and montoring system is added value, allow our customers watching the secure cams 24/7, performance and evaluate the training progress. ...

Read more   
Call our Sales
   Clients Testimonials
Nada Youssef
Date: 2012-11-10
nice site... More...
Ahmed Ali
Date: 2012-11-10
I like the site design, it's sweet .. simple ... well organized. Hope to see next projects... More...
Maha el Said
Date: 2012-11-11
Very Helpful and very organized company...it opens its doors for people who are willing to learn and develop their designing abilities.... More...
mohamed saad
Date: 2012-11-28
it\'s very nice website go ahead..... More...

  • Category: Microsoft Office
    Date: 2012-11-12
                                    Play

  • Category: Adobe
    Date: 2012-11-12
                                    Play

  • Category: Adobe
    Date: 2012-11-12
                                    Play

  • Category: Entercaps Traning Center
    Date: 2012-11-11
                                    Play
  • Photoshop CS5-The Missing Manual
    Photoshop CS5-The Missing Manual
    DOWNLOAD
  • Photoshop CS6 For Dummies
    A dobe Photoshop is one of the most impo
    DOWNLOAD
  • Pro .NET Best Practices
    Pro .NET Best Practices
    DOWNLOAD
  • Hardening Cisco Routers
    Hardening Cisco Routers
    DOWNLOAD
   Mastering PHP & MySQL

Admission

This course designed for new trainees, web designers or graphic designers who want to building web application with easy-to-use tools such as PHP and MySQL.


Mastering PHP & MySQL
Exam # Duration Language Level Type Classroom Code Fees
-- 48 English Mastering Course Classroom Cs290 1500 LE
Description :

PHP and MySQL are quickly becoming the de facto standard for rapid development of dynamic, database-driven web sites. This course explains everything from fundamental concepts to the nuts and bolts of performing specific tasks. It's a launching pad for future learning, providing with a solid foundation for more advanced development.



Objectives :
  • PHP basics such as strings and arrays, and pattern matching.
  • A detailed discussion of the variances in different PHP versions.
  • MySQL data fundamentals like tables and statements.
  • Information on SQL data access for language.
  • A new chapter on XHTML.
  • Error handling, security, HTTP authentication, and more.


Topics :

Dynamic Content and the Web

  • HTTP and the Internet
  • PHP and MySQL's Place in Web Development
  • The Components of a PHP Application
  • Integrating Many Sources of Information
  • Requesting Data from a Web Page
  • Questions

Installation

  • Developing Locally
  • Working Remotely
  • Questions

Exploring PHP

  • PHP and HTML Text
  • Coding Building Blocks
  • Questions

PHP Decision-Making

  • Expressions
  • Operator Concepts
  • Conditionals
  • Looping
  • Questions

Functions

  • Calling Functions
  • Defining Functions
  • Object-Oriented Programming
  • Questions

Arrays

  • Array Fundamentals
  • Questions

Working with MySQL

  • MySQL Database
  • Managing the Database
  • Using phpMyAdmin
  • Database Concepts
  • Structured Query Language
  • Questions

Database Best Practices

  • Database Design
  • Backing Up and Restoring Data
  • Advanced SQL
  • Questions

Getting PHP to Talk to MySQL

  • The Process
  • Querying the Database with PHP Functions
  • Using PEAR
  • Questions

Working with Forms

  • Building a Form
  • Templates
  • Questions

Practical PHP

  • String Functions
  • Date and Time Functions
  • File Manipulation
  • Calling System Calls
  • Questions

XHTML

  • Why XHTML?
  • XHTML and XML Namespaces
  • XHTML Versions
  • Generating XHTML with PHP
  • Questions

Modifying MySQL Objects and PHP Data

  • Changing Database Objects from PHP
  • Manipulating Table Data
  • Displaying Results with Embedded Links
  • Presenting a Form to Add and Process in One File
  • Updating Data
  • Deleting Data
  • Performing a Subquery
  • Questions

Cookies, Sessions, and Access Control

  • Cookies
  • PHP and HTTP Authentication
  • Sessions
  • Using Auth_HTTP to Authenticate
  • Questions

Security

  • Session Security
  • Questions

Validation and Error Handling

  • Validating User Input with JavaScript
  • Pattern Matching
  • Redisplaying a Form After PHP Validation Fails
  • Questions

Sample Application

  • Configuration File
  • Page Framework
  • Database
  • Displaying a Postings Summary
  • Displaying a Posting and Its Comments
  • Adding and Changing Posts
  • Adding and Changing Comments
  • Questions

Finishing Your Journey

  • PHP Coding Standards
  • PEAR
  • Frameworks
  • Ajax
  • Wikis
  • Finding Help on the Web
  • Questions




Recommended Knowledge :

Trainees should familiar with general internet applications and have a overview of web concepts . Web designing with HTML and Javascript also recommended to be found for trainees.

Recommended Course(s) :

 JavaScript

 XHTML & CSS


Training Materials :

Learning PHP & MySQL, 2nd Edition, Publisher: O'Reilly Media


Labs :

This course includes several labs to ensure you will gain the targeted skills and experience.


Credential :

Upon completion the trainee will acquire EnterCaps Certificate of Achievement

Category :
Programming


The Instructor:
Copyright © 2008-2012 - EnterCaps for Design and Development - All rights reserved.