PHP/MySQL Bootcamp 5 Days Hands-On Training

, Antharia University: more than just the web

Want to learn how to implement a dynamic database-driven Web site? Need to learn it fast and within a structured, real-world environment? Antharia's 5-day PHP/MySQL Bootcamp arms you with the power to effectively implement today's most popular open-source scripting language and database on your website, intranet, or extranet. You will learn how to take advantage of the power of PHP and MySQL with hands-on, real-world examples.

This class takes students from concept to completion. From Intro to PHP & MySQL to understanding databases, you will learn how to take advantage of PHP and MySQL, and create and implement a database-driven website through hands-on exercises. We will give you the knowledge you need to build any database-driven application. The last hour of each day of class is set aside for individual practice on the lessons learned during the day. The instructor is available to answer questions and assist students during this practice period.

At the completion of this class, students will be able to implement a database-driven website with basic content management system, use PHP to call to and store information in a database, and much, much more. You will learn how to formally use PHP & MySQL to create the end product.

Students are welcome to arrive as early as 10:15 and stay as late as 6:00 pm Monday - Thursday for open non-instructor led lab time.

Outline & Materials

Class includes PHP and MySQL for Dynamic Websites, course workbook, and class files. Students will also have 90 days of access to their instructor (via email) for questions and answers.

Lesson 1: Introduction

  • What do PHP and MySQL Do?
  • A Brief History of PHP and MySQL
  • The Sample Application


Lesson 2: PHP Basics

  • Embedding PHP in Web Pages
  • Language Structure
  • Testing & Debugging While You Work
  • Data Types
  • Variables
  • Expressions and Operators
  • Using Functions


Lesson 3: Arrays

  • Creating Arrays
  • Indexed vs. Associative Arrays
  • Multidimensional Arrays
  • Sorting Arrays


Lesson 4: MySQL and SQL

  • Relational Database Basics
  • Designing a Database
  • Accessing MySQL
  • MySQL Users
  • Creating a Databases & Tables
  • Inserting, Updating, and Deleting Data
  • Selecting Data


Lesson 5: Displaying MySQL Data

  • MySQL Functions
  • Connection to a MySQL Database with PHP
  • Querying the Database
  • Displaying the Results
  • Using HTTP GET variables
  • Displaying Record Details


Lesson 6: Control Statements

  • if, else, elseif
  • switch
  • while
  • for
  • foreach


Lesson 7: Functions

  • Defining a Function
  • Variable Scope
  • Returning a Value
  • Using Parameters


Lesson 8: Writing to the Database

  • Using HTTP POST Variables
  • Inserting Data
  • Updating Data
  • Deleting Data


Lesson 9: Validation on the Server and Client

  • Server-side Validation
  • Client-side Validation
  • Sessions
  • Keeping State with Sessions
  • When to Use Sessions
  • Starting a Session
  • Using Session Variables
  • Destroying and Unsetting Sessions
  • EXTRAS: Installation & Additional Resources

Objectives

Students in this class will take away the following key elements:

  1. Students will learn the fundamentals of the PHP programming language, such as variables, control structures, functions, and built in variables and autoglobals.
  2. Students will learn about data access in SQL and the fundamentals of database design. Students will be able to set up a database in MySQL, add users who can access it, and build and populate tables in the database.
  3. Students will be able to connect to a MySQL database from PHP scripts, and retrieve, delete, and store values.
  4. Students will be able to create a templating system using PHP, and be able to manage content stored in a database.
  5. Students will learn about form validation, both server-side with PHP and client-side with JavaScript.
  6. Students will learn about sessions, and how to use sessions to implement user log-in and maintain state data between page loads.
  7. Students will gain experience using a variety of different database patterns to store information, and practice working with dates, text, integers, and other data field types.

 

Additional Details can be found at https://www.antharia.com/onevent/details.php?id=43 but to qualify for this special pricing you must register through Skill Share.

Prerequisites
Due to the nature of the materials covered in this class, students should be comfortable with basic HTML. Any previous PHP experience will be helpful to the student, but is not necessary. If you already know PHP, you will learn how to take full advantage
Schedule
  • Day 1

    Antharia

    9470 Annapolis Road, Ste. 406
    Lanham, MD

    This is a hands-on course.  Students should arrive by 10:30.  Lunch will be provided.

    May
    21
    Mon, May 21st, 2012

    10:30 am - 5:00 pm EDT

    Add to Cal
  • Day 2

    Antharia

    9470 Annapolis Road, Ste. 406
    Lanham, MD

    This is a hands-on course.  Students should arrive by 10:30.  Lunch will be provided.

    May
    22
    Tue, May 22nd, 2012

    10:30 am - 5:00 pm EDT

    Add to Cal
  • Day 3

    Antharia

    9470 Annapolis Road, Ste. 406
    Lanham, MD

    This is a hands-on course.  Students should arrive by 10:30.  Lunch will be provided.

    May
    23
    Wed, May 23rd, 2012

    7:00 pm - 8:30 pm EDT

    Add to Cal
  • Day 4

    Antharia

    9470 Annapolis Road, Ste. 406
    Lanham, MD

    This is a hands-on course.  Students should arrive by 10:30.  Lunch will be provided.

    May
    24
    Thu, May 24th, 2012

    10:30 am - 5:00 pm EDT

    Add to Cal
  • Day 5

    Antharia

    9470 Annapolis Road, Ste. 406
    Lanham, MD

    This is a hands-on course.  Students should arrive by 10:30.  No lunch will be provided on Friday.  Students are welcome to bring their own lunch this day.

    May
    25
    Fri, May 25th, 2012

    10:30 am - 4:00 pm EDT

    Add to Cal

Jordan Dossett

Antharia University: more than just the web

This hands-on class is taught by real world developers who eat, breath and sleep CSS.  This specific class will be taght by Ben Matics Sr. Developer @antharia.

View Full Profile

--% Positive Reviews (0 Reviews)

This class hasn't been reviewed yet.

Antharia

9470 Annapolis Road...

Lanham, MD

0 / 8 Students

  • 1

    Classes

  • 0

    Students

  • 19

    Watchlist