Instructor: Sharon Denning
Intro to Databases - PGTE 5044 A
CRN: 2627
Duration: Jan 23, 2006 - May 15, 2006
T 6:00 pm - 8:40 pm
Arnhold Hall 55 W13th 908
About this Class:
This class is designed to give you an overview of how databases are used and how to construct a database driven, or dynamic, web site. We’ll be working with PHP and MySQL, which are open-source applications, commonly used on the web.
This class will not make you an expert on either PHP or MySQL – both PHP and SQL are complex languages, but it will give you the tools to understand and build dynamic sites, and the foundations to dig deeper.
This class is made up of 2 parts – the first is practical – how to design, create and use databases. The second is more theoretical, looking at how databases are used in practical and artistic applications, and how they affect how we work.
The first 2 weeks of the class are devoted to working with PHP. This is the tool we’ll be using to get in and out of our database and to display the results, so it’s important that we’re all comfortable with it. The next 3 weeks we’ll be looking at the SQL language and MySQL in particular. After that we’ll look at authentication and sessions, and how to develop your own database driven program.
NOTE: This class assumes you have a working knowledge of html.
Your Responsibilities:
1- Completing all homework assignments – both readings and programming assignments.
2- Handing in print copies of your homework and maintaining a website with links to all your assignments
3- Alerting me if you feel you don’t understand a concept, or you feel lost in the class.
[8] 3/27/2006
Concept presentations
Designing your own program
- data spec
- database design
more...
