Description:
Through this course you will gain a foundational understanding with scripting languages and databases in general. You'll also learn some fundamental programming concepts and techniques which will help you better communicate with developers. Through PHP and MySQL we'll write a basic blogging application in which you'll see just how information is written to and retrieved from a database, and then displayed on the page. After this course you'll have a more in depth understanding of dynamic web content, and a foundation upon which to expand your knowledge and skills.

1. Welcome to PHP
• What is PHP?
• Top down processing
• Learning and troubleshooing resources
2. Writing PHP
• PHP code blocks
• Our first page phpinfo()
• Variables
• Functions
• Using includes
• Processing forms
3. Welcome to MySQL
• Introduction to relational databases
• What is MySQL and why use it?
• Tables, fields and keys
• Writing SQL select statements (retrieve blog post entries as list, and entry and single record)
• Writing SQL insert statements (add post entry)
• Writing SQL update statement (update post entry)

If this is your first time working with a programming language you might find that you will have a difficult time troubleshooting your code in the class. Realistically some people take longer to grasp the sometimes abstract concepts used in programming. For this reason we keep our class sizes very small (maximum 6 people) so the instructor has the flexibility to help you along as much as possible. However there may be cases where slower learners will need more help than we can provide in order to ensure the quality of the class for the rest of the participants.

Presented as a Hands-On Intensive:
These in-depth one or two-day classes are designed for students to follow along with the instructor on BDA-provided Macintosh computers. For maximum impact and the best student experience all intensives are limited to seven participants. Hands-on intensives are usually during the day from 9am - 5pm. Our Hands-On Intensives are the perfect way to gain in-depth knowledge!

Who Should Take This:
Participants should be familiar building static websites including HTML, CSS and comfortable with development tools.

Instructor:
Richard Jones began programming with Basic at age 10, and was highly active in the pre-internet social networking systems during the early 90s. He then moved on to Visual Studio while serving with the US Army during the late 1990s. In 2003 he finished his degree in Digital Media, specializing in Internet and Web Technologies. Having taught himself PHP and Javascript, he founded a development outsourcing company, Tenth Street Studios, which he ran successfully until moving to Boulder in late 2007. Formerly a Web Developer with Slice of Lime, a leading web design and development firm located in downtown Boulder, Richard is now the Chief Technology Officer and Senior Developer for Callisto.fm. Richard is also fluent in HTML,CSS, SQL and JavaScript, and has taught college courses at Santa Fe Community College in Gainesville, Florida. In his spare time he enjoys woodworking, photography, and snowboarding. You can contact Richard at the@talentedmrjones.com.

BDA Member Cost: $239.00
Non Member Cost: $279.00
Become a member to save $40.00