Database Driven Web Applications
Crash Course

Links

Source Code Control

Tutorials

Quick References

Lecture 1: Project management

Download the first lecture powerpoint

  1. Project management for software projects using Trac
  2. How to work with others in a team project using Subversion source control.

I decided to hold this course to help members of TIES to better understand the applications their teams revolved around developing. I wanted to bring people together and show them how databases and web servers are not things to be afraid of, but tools for all to exploit.

  • Trac-Hacks
  • Lecture 2: Development Environment

    download the second lecture powerpoint

    We set up an apache/php/mysql server, and learn to use the eclipse development environment along with an assortment of plugins.

    Lecture 3: Relational Database

    Download the third lecture powerpoint

    We will see how easy it is to create a database using the MySQL admin tools. We will review database design principles of Normalization and Lookup tables. We will go over some basic SQL queries to Select, Insert, and Update data.

    Lecture 4: Application Design

    download the fourth lecture powerpoint

    1. XAMPP INSTALLER xampp-win32-1.6.4-installer.exe
    2. connect.inc
    3. index.php.txt

    The culmination of this quarter's crash course, we will write a PHP web page that accesses a MySQL database, displaying results


    Enter your name and e-mail address here if you are interested in attending: (I will not give your email to anyone!)


    About me: Im a transfer student with a decade of experience working with web applications.

    Why am I doing this? To help fellow members of TIES, and anybody else become familiarized with web application design. Also: good karma!

    See you Friday!

    Henry Koren [hkoren@ucsd.edu]
    4th Year Computer Science Undergrad