PHP & MySQL Video Tutorial Course

CareerVision Training
Distancia

£70 - ($59.719)
IVA inc.

Información importante

  • Training
  • Beginner
  • A distancia
  • Duración:
    Flexible
  • Cuándo:
    A definir
  • Envío de materiales de aprendizaje
Descripción

COURSE INCLUDES
• Format: DVD-ROM
• Duration: 15.75 Hours (155 lessons)
• Instructor: Doug Bierer
• Platform: Windows PC or Mac


COURSE INTRODUCTION

In this video training title from Doug Bierer, you will learn the fundamentals of PHP and MySQL. These two platforms have been virtually inseparable for many years, and major groundbreaking websites such as WordPress, Wikipedia, and Facebook use PHP and MySQL technologies.

This computer software training is designed for the beginner; no previous programming or database experience is required. Your training begins with the absolute basics, covering topics such as creating variables, working with data types and outputting them to a webpage. You will learn how to work with arrays, how to use loops and control structures such as foreach, while and if.

Información importante

Requisitos: This is a DVD Video Tutorial Course which is shipped to you. Work through the video tutorials at your own pace. If you have the software you can practice along with the instructor using the same exercise files as the instructor which are included on the DVD. The narrated training videos demonstrate the key tools and professional techniques helping you to work faster and smarter. All the concepts of each application are explained clearly and precisely. The DVD works on PC and Mac. You can jump to and from lessons and work at your own pace.

Instalaciones

¿Dónde se da y en qué fecha?

comienzo Ubicación
A definir
Distance Learning

¿Qué aprendes en este curso?

PHP
MySQL
Email
SQL Functions
Building Web Forums

Temario

01. Getting Started
0101 What The Course Covers
0102 Course Setup Using XAMPP
0103 Installing XAMPP On Windows
0104 Installing MAMP On The Mac
0105 Installing XAMPP On Linux
0106 Configuring PHP And MySQL
0107 Configuring Apache
0108 Using Editors And IDEs
0109 Saving Your Code
0110 Searching PHP And MySQL Documentation
0111 Getting Help And Verifying XAMPP Status
0112 Setup And Finding Course Files
0113 Lab: Building A New Website
0114 Solution: Building A New Website
02. Understanding The Basics
0201 Creating Variables In PHP
0202 Assigning Different Data Types
0203 Performing Arithmetic Operations
0204 Adding Comments To The Code
0205 Assigning Constant Values
0206 Using The printf Command To Format A String
0207 Understanding The substr Command
0208 Working With Strings
0209 Debugging An Application
0210 Lab: Mixing HTML And PHP
0211 Solution: Mixing HTML And PHP
03. Working With Arrays
0301 Working With Numeric Keys
0302 Working With Associative Arrays
0303 Assigning Values To Arrays
0304 Creating A Multidimensional Array
0305 Searching Arrays
0306 Sorting Arrays
0307 Removing Values From Arrays
0308 Measuring Array Differences
0309 Merging Arrays
0310 Lab: Using An Array To Generate A Drop Down Menu
0311 Solution: Using An Array To Generate A Drop Down Menu
04. Creating Control Structures: Looping And Branching
0401 Comparing Values
0402 Using if, else, And elseif
0403 Using switch
0404 Setting Up A for Loop
0405 Configuring while And do while Loops
0406 Using A foreach Loop
0407 Branching With continue, break, And goto
0408 Lab: Using Loops To Display Rows Of Data On A Web Page
0409 Solution: Using Loops To Display Rows Of Data On A Web Page
05. Managing The Code: Functions
0501 Using Built-In Functions
0502 Creating Your Own Functions
0503 Returning Values
0504 Defining Mandatory And Optional Parameters
0505 Using Parameters By Reference
0506 Handling A Variable Number Of Parameters
0507 Understanding Global Variables
0508 Lab: Creating A Function Which Paginates Rows Of Data
0509 Solution: Creating A Function Which Paginates Rows Of Data
06. Managing The Code: Object-Oriented Programming
0601 Defining Classes
0602 Adding Properties
0603 Creating Methods
0604 Determining The Visibility Level
0605 Building Classes By Inheritance
0606 Handling Exceptions
0607 Introducing The MVC (Model-View-Controller) Design Pattern
0608 Lab: Building An MVC Website Using OOP
0609 Solution: Building An MVC Website Using OOP
07. Managing The Code: External Libraries
0701 Loading Code With include
0702 Loading Code With require
0703 Loading Code Once Only
0704 PHP Extensions And PECL
0705 PHP Libraries And PEAR
0706 Lab: Downloading An External Library
0707 Solution: Downloading An External Library
08. Managing Files
0801 Using The f* Family
0802 Using The *file* Family
0803 Understanding Streams
0804 Updating The Error_Log
0805 Parsing Directory Structures
0806 Lab: Reading A CSV File
0807 Solution: Reading A CSV File
09. Managing A MySQL Database
0901 Understanding RDBMS Terminology
0902 Command Line Access
0903 Using phpMyAdmin
0904 Configuration
0905 Creating A Database
0906 Managing Tables - Part 1
0907 Managing Tables - Part 2
0908 Understanding Indexes And Relationships
0909 Establishing Relationships And Constraints
0910 Lab: Defining Tables And Relationships For A Website
0911 Solution: Defining Tables And Relationships For A Website
10. Understanding Structured Query Language (SQL)
1001 Retrieving Data Using SELECT
1002 Adding Data Using INSERT
1003 Editing Data Using UPDATE
1004 Removing Data Using DELETE
1005 Performing Advanced Queries Using JOIN
1006 Lab: Creating Select, Insert, Update, And Delete SQL Statements
1007 Solution: Creating Select, Insert, Update, And Delete SQL Statements
11. Using PHP To Interact With A MySQL Database
1101 Understanding The Different MySQL Database Extensions
1102 Reading Data From A Table
1103 Writing Data To A Table
1104 Updating Data In A Table
1105 Deleting Data From A Table
1106 Reading Data From Multiple Tables
1107 Lab: Display Products And Members Using PHP And MySQL
1108 Solution: Display Products And Members Using PHP And MySQL
12. Using Regular Expressions
1201 Understanding The Three Regular Expression Command Sets
1202 Defining Basic Patterns
1203 Using preg_match For Form Validation
1204 Finding All Matches With preg_match_all
1205 Using preg_replace For Intelligent Search And Replace
1206 Lab: Using Regular Expressions To Validate Form Data
1207 Solution: Using Regular Expressions To Validate Form Data
13. Managing Email
1301 Sending Mail Using mail
1302 Using External Mail Libraries
1303 Adding An Attachment To Email
1304 Sending Email Using SMTP
1305 Lab: Using PHP To Send A Confirmation Email
1306 Solution: Using PHP To Send A Confirmation Email
14. Working With Date And Time
1401 Understanding Timestamps
1402 Using The date Command
1403 Using The DateTime Class
1404 Performing Date Arithmetic
1405 Lab: Capturing Date Of Birth Using DateTime
1406 Solution: Capturing Date Of Birth Using DateTime
15. Managing Web Operations
1501 Reading Inbound Information From Built-In Global Variables
1502 Handling Cookies
1503 Managing Sessions
1504 Setting Headers And Performing Redirection
1505 Reading Incoming Header Information
1506 Using Output Buffering
1507 Deploying An Application To A Website
1508 Lab: Using Cookies And Sessions To Implement A Shopping Cart
1509 Solution: Using Cookies And Sessions To Implement A Shopping Cart
16. Building Web Forms
1601 Capturing Form Data
1602 Understanding Form Input Elements
1603 Working With Select Tags
1604 Defining Checkboxes And Radio Buttons
1605 Handling File Uploads
1606 Securing Form Data: Inbound Filtering
1607 Securing Form Data: Form Data Validation
1608 Securing Form Data: Output Escaping
1609 Lab: Integrating Form Data With The Database
1610 Solution: Integrating Form Data With The Database
17. About The Author
1701 About The Author