Alright folks, all of the pieces are in place, so we're going to start our Free PHP & MySQL course. Please read all of the following completely, to make sure you have all of the details.
Here is the course information:
Learning HTML & CSS with O'Reilly's "Head First PHP & MySQL" book.
Course Discussion Forum: At our meetup Site
Minimum Students per Course:
Maximum Students per Course:
21139 Lorain Road Suite 11, Fairview Park, Ohio 44126.
Dates and Times:
Sundays at 1pm and Thursdays at 1pm.
(Note: We're running the same course twice, so there's no need to RSVP for both Sunday and Thursday, because each week they cover the same material)
Each Class will run about 2 hours. Classes will start and end promptly on time. We will have one 15 minute break.
The course is divided up into 16 classes, with an extra 2 (or 4) Bonus Sessions for qualifying participants:
Every course has a lot of material to get under your belt to really understand this stuff. Thus the many classes. Typically I expect classes might run once or twice a week. Also some groups may progress faster than others (especially if they do their homework), so one period of classroom time might cover two classes worth of material in their case. See information below on donations to find out about the Bonus Sessions.
We will be taking the classes in order. Which means setting up the environment is at the end. This might seem counter-intuitive. But our goal here is not to teach you how to install a LAMP (Linux Apache MySQL Php) or WAMP (Windows) or MAMP (Mac) server. Rather, it is to teach you how to code and debug PHP and MySQL. So we start, as the Head First book does, digging right into it. Then those that wish to create their own setup can stick around for the later classes.
In order to make sure though, that you are able to hit the ground running, you will be given your own user account, sub-domain and MySQL database. So installing all of these will not be an issue, it's taken care of for you.
have to know how to use your computer with the operating system of your choice. I'm an Ubuntu nut and I'm not going to be spending class time troubleshooting Windows or Mac issues. So you have to know how your system works, and how to:
- Run your Operating Systems File Browser
- Use a text editor.
- Visit websites and bookmark them.
- Fill out web forms.
- Create accounts on Websites (Examples: Gmail, Twitter, etc).
- Essentially you have to know how to get yourself around on your computer and on the web.
In addition you absolutely
If you don't know these things, you cannot take this course right now
. But don't despair, I'll be running this course often in the future. Just give me a call and we can point you in the direction to get you started learning these. If you don't know HTML, see our calendar
to find a date for our HTML & CSS course. You can also check out the information on our HTML & CSS Course
for more information.
- O'Reilly's "Head First PHP & MySQL" by Lynn Beighley and Michael Morrison.
This is REQUIRED from the moment you step foot into the first class. The entire course is based around this book and you NEED to have it. You're going to be studying it outside of class time, so "looking over another's shoulder" won't be an option. Did I emphasize that enough? :D
You can pick one up from any of the following places:
Note: Be sure to check pricing. Some charge more but offer a discount (as much as half) for your second copy. So you might want to consider buying as a group. Also be aware, if you already own the book you can sign up at O'Reilly and add it to your "Registered Books" section and buy the Ebook in PDF format for only $5.00 bucks. Having the PDF might be a convenience for some. Also some of these stores have locations in our area, and if they don't have the books you need in stock, can often get store delivery, which saves you on shipping.
Unavailable for Kindle or other Ebook readers as far as I can tell. Though if you own the PDF, the Kindle will read it, but VERY clunky (not sure about the DX).
- O'Reilly's PHP Pocket Reference
- O'Reilly's HTML Pocket Reference
Trust me on the MySQL Pocket Reference. I won't forbid you from attending the class or anything if you don't have it. But you will find it exceedingly
useful. It was one of the major tools that I used when first learning MySQL.
The PHP Pocket Reference was only marginally helpful to me personally. But it does list PHP functions and that WILL come in handy when you're without a net connection. (If you have a net connection simply go to http://php.net/function_name
You will also want to bookmark O'Reilly's Head First Labs
. It has the code samples we will be using, some great forums, and other materials you might dig. If you don't dig it then poo poo on you :D.
The TOC of "Head First PHP & MySQL" is essentially our syllabus. It is as follows:
- It���s Alive: Add Life to Your Static Pages
- How It Fits Together: Connecting to MySQL
- Creating Your Own Data: Create and Populate a Database
- Your Application on the Web: Realistic and Practical Applications
- When a Database Just Isn���t Enough: Working With Data Stored in Files
- Assume They���re All Out to Get You: Securing Your Application
- Remember Me?: Building Personalized Web Apps
- Sharing is Caring: Eliminate Duplicate Code
- Harvesting Data: Control Your Data, Control Your World
- Better Living Through Functions: String and Custom Functions
- Rules for Replacement: Regular Expressions
- Drawing Dynamic Graphics: Visualizing Your Data... and More!
- Interfacing to the World: Syndication and Web Services
- The Top Ten Topics (We Didn���t Cover): Leftovers
- A Place to Play: Set Up a Development Environment
- Get Even More: Extend Your PHP
By the time you are finished with this course, you will have a firm
understanding of PHP & MySQL, done proper. You'll understand hand coding, and its benefits. You'll be able to read the code written by others, and with time, be able to correct their mistakes. You will also understand proper code formatting, how to choose a code editor, tricks to save you time and increase your productivity. You are going to understand the basics of security, and how to avoid common pitfalls of new developers. (Note: This is by no means however a course on PHP or MySQL security. We will be offering an entirely separate course geared entirely towards security in the near future.) In short, you are going to be able to write your own data-based applications for the web.
Alright, so if you're still reading and your interested in the course a couple final details. First, RSVPs are a MUST for all attendees. If you're going to miss a class, I need a "no" RSVP so that I can plan my schedule if all of the sudden most cannot make it that class period.
As well, for the first class, I need a phone RSVP. Space is limited (and I mean physically limited in this case, because I have a small space), so I need to know how many are coming. My number is 440.521.7214.
Now for this stuff on the Bonus Sessions. The course is free, but I am asking for donations. Donations will help me cover the rent for the facility I am using, and other costs. A suggested donation range is between $15 to $30 per class. If you find the material, class time, help and suggestions you receive valuable, a donation is greatly appreciated. I will have a box available at each class, labeled donations, for those that are able and willing to donate.
Anyone that donates $20 or more per class will be entitled to attend 2 Bonus Sessions. In order to make effective use of these sessions you will need your own Dreamhost account (or other hosting account). But for the session time, you will use the space and account provided to you during the course. Bonus Sessions are limited to 4 participants at a time, scheduled between me and the students. This will be a hands on session to give your project extra attention and are in 2 hour increments. Anyone that donates $50 or more per class will be entitled to attend 4 one on one sessions. Contact me for details.
If anyone has any questions feel free to respond to this email, or call me. Looking forward to seeing yall at the classes!
Please Note: If you hit "REPLY
", your message will be sent to everyone
on this mailing list ([address removed])
This message was sent by Aoirthoir An Broc ([address removed]) from Cleveland Web Design and Development Meetup
To learn more about Aoirthoir An Broc, visit his/her member profile
To unsubscribe or to update your mailing list settings, click here
Meetup, PO Box 4668 #37895 New York, New York[masked] | [address removed]