Learning PHP MySQL Training Video

Courses For Success
Online

AU$ 189 - ($ 2.202)
+ IVA

Información importante

  • Curso
  • Online
  • Cuándo:
    A definir
Descripción

Learning PHP MySQL Training Video A Practical PHP and MySQL Training Course That Teaches Real World Skills In this project-based Learning PHP MySQL video tutorial series, you'll quickly have relevant skills for real-world applications. Follow along with our expert instructor in this Learning PHP MySQL Training Video course to get: Concise, informative and broadcast-quality PHP and MySQL  training videos delivered to your desktop The ability to learn at your own pace with our intuitive, easy-to-use interface A quick grasp of even the most complex PHP and MySQL  subjects because they're broken into simple, easy to follow tutorial videos Practical working files further enhance the learning process and provide a degree of retention that is unmatched by any other form of PHP and MySQL  tutorial, online or offline... so you'll know the exact steps for your own projects. Course Fast Facts: Only 9.5 hours to complete this course 95 tutorial videos Expert instructors lead each course Download to any Windows PC or Mac and save for viewing off line Course is accessible 24/7 from any computer once downloaded You can study from home or at work at your own pace in your own time Course Description In this Learning PHP MySQL Training Video 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. You will learn about functions and...

Información importante

Requisitos: System Requirements - Digital Download Digital Download: Microsoft Windows XP or higher, Mac OS X 10.4 or higher. Minimum screen resolution of 1024x768 Digital Download specific requirements: Between 1GB and 6GB of available hard drive space (depending on the training course) An Internet connection with sufficient bandwidth. You must have at least a 56K modem connection (Broadband recommended). Most modern ADSL and Cable internet solutions will be sufficient. Do I need...

Sedes

Dónde se enseña y en qué fechas

inicio Ubicación
A definir
Online

¿Qué aprendés en este curso?

Windows
PHP
MySQL
Email
Database
SQL
Database training
Web
Programming
Mac
Skills and Training

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 - Part 1
    • 1510 Solution: Using Cookies And Sessions To Implement A Shopping Cart - Part 2
  • 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

Información adicional

Digital Download FAQs

Q: What is a digital download?

A digital download is training that you download from the internet using your web browser instead of us shipping you a physical CD.

Q: How instant is the "Instant Purchase"?

If you complete your purchase, you are emailed your access key within minutes of the transaction completing.

Q: How do I access my digital download...