|
San Francisco Bay Area
Class Info for:
|
$1950 for 24 evenings, 6pm-9pm
Held at
AcademyX
601 Montgomery St. #409 (map)
San Francisco Bay Area |
No dates scheduled
call 415-392-8024 for info |
24 Evening Apache/PHP/MySQL Program - San Francisco
This three month training course offers an extended study in open source web programming technologies: the Apache web server, the MySQL database, and the PHP programming language. This training course meets twice a week, on Tuesday and Thursday evenings.
Would you like to visit a current evening program class? We encourage students to visit our facilities and
see the quality of the training. AcademyX periodically offers a free seminar from 6-8pm,
entitled "Web Careers".
It addresses ways to earn money in this industry as an employee, contractor, or entrepreneur, and how this web developer
program would enable you to do this.
Call 415-392-8024 to RSVP.
At the end of the training course, students should be able to write the code for a database-driven web site with:
- a contact us form that sends email programmatically
- a product catalog drill-down search
- a registration/login form that authenticates users
- a guestbook
- a bulletin board
- a shopping cart
Evenings |
Topic |
Description |
1-2 |
The Big Picture |
In this section we will give you an overview of how the Web works: where web pages are kept,
what they are made of, how they are sent back and forth, and how they are displayed by web
browsers. We will register some domain names and set up an account with a real web hosting
company. In this training class we'll define and and explain domain registrars, web hosting companies,
and the term 'client-server interaction'.
We'll also cover the nitty-gritty issues involved in hosting your own web site. We'll show you how each computer has an Internet Protocol (IP) address like a telephone number that allows you to contact it. We'll illustrate how you go about getting such a number and how to configure your computer or router to assign them to computers. If your office or home uses a firewall, we'll show you how to forward requests for web pages to the right computer. We'll also show you nameservers work; these are the software applications that resolve web URLs to IP addresses. |
3-6 |
Apache |
Apache is the most popular web server in the world. It is free, open-source software and runs on all
major operting systems. Configuring it can be difficult,
but after this training class you will have a good understanding of how to install it, get it running, and look up documentation on various configuration items.
After installing and configuring Apache, we will show you how browsers submit requests for web pages and how Apache handles those requests. The most important part of any web server is the ability to have multiple web sites and map domain names to folders. We'll show you how to do this using "Virtual Hosts". You'll learn how to set up directory listings and enable home pages.
You'll also learn how to keep track of visits in log files, creating aliases to directories outside the web root, and forbid or allowing external and internal visitors to your site. We'll cover the various modules included with Apache that give you more control over its feature set. |
7-12 |
MySQL |
MySQL is a freely downloadable database server that is commonly used in web applications. In this introductory training class we'll explain:
- basic concepts: servers, databases, tables, rows, fields, and Structured Query Language (SQL)
- the MySQL server
- the MySQL Query Browser
- the MySQL Administrator
- creating tables with different field data types
- granting privileges to users
- tools: mysqldump, mysqlshow, mysql.exe
- connecting to MySQL from Microsoft Access using a data source
In the lab sections for this topic we'll ask you to convert raw product, customer, and company information from several raw text files into a working relational MySQL database. You'll have to set up users with privileges to access parts of the data. |
13 |
PHP Basics |
PHP Hypertext Preprocessor (PHP) is one of the fastest-growing languages on the Web. PHP is freely downloadable and works well with the Apache web server and MySQL database under both Windows and Unix. It is very similar to Perl and has much the same syntax. In this section we will cover:
- downloading and installing php
- configuring your web server for php
- syntax rules
- variables, operators and output
- string, math, and date functions
|
14 |
PHP for Getting Stuff Done |
By this time the basic constructs of programming in PHP should be familiar to you. In this section we will cover:
- conditionals and loops
- retrieving <form> data
- miscellaneous useful stuff
- sending email programmatically
|
15 |
Lab Time |
In this section we'll sit down and practice. Our goal will be to produce a "Contact Us" form that validates form data and sends off an email using PHP.
|
16 |
PHP Arrays |
In this section we'll cover the use of variables that contain multiple values. This includes:
- arrays
- associative arrays
- iteration with foreach loops
|
17 |
PHP and Database Integration |
Once you have an understanding of MySQL, the next step is to get one of your PHPs to connect to it and run
some SQL commands against the database. We will show you the PHP instructions for connecting to the
database, conveying SQL commands to it, as well as capturing any errors. By the end of the training class, you'll know how to use PHP to connect to, update, and select data from MySQL. We'll also show you how to connect to any ODBC database, include SQL Server and MS Access.
|
18 |
Lab Time |
Now that you can connect to a database from PHP and execute SQL commands, it's time to put this into practice. We will try to build a data-driven web site that displays the contents of a product catalog.
|
19 |
PHP Functions, File I/O, Sessions, and Cookies |
In this section we will cover other useful PHP topics such as defining functions, opening/updating text files on the server, and handling session/cookie data.
|
20 |
PHP Pattern-Matching |
Pattern matching is the process of searching for character patterns in text. For example, your code could open a text file and sift through it to identify all the character patterns that match email addresses. We'll show you how to express patterns, perform substitutions, and capture pattern matches.
|
21 |
Lab Time |
In this section we'll sit down and practice. Our goal will be to create a content management system using PHP and MySQL. Pattern-matching will be used to identify text placeholders and to strip user-inputted HTML.
|
22 |
Object-Oriented Code |
Writing object-oriented code produces software that is easier to manage. We'll explain the basics of object oriented coding. This includes:
- classes, methods and properties
- inheritance and polymorphism
|
23 |
Object-Oriented PHP and PEAR |
In this section we'll implement object-oriented programming in PHP. We'll show you:
- how to use other people's classes
- how to create your own classes with methods and properties
- how to install and use PEAR modules
|
24 |
Lab Time |
In this final lab we'll put everything together by producing a shopping cart checkout that uses object-oriented PHP for the shopping cart.
|
|
