Help:COAP-3180/week3

Week 3 - COAP 3180

Topics Covered

Portalware configuration (continued):

• discussion of homework 2 if needed

Relational databases: Introduction to SQL (part 1):

• Relational tables (principles)
• Retrieving data
• Definition of SQL tables and use of the phpMySQL tool

Classroom activities Monday

• Define a table with SQL code
• Learn how to inject SQL code in MySQL Admin (a web application to administer web databases) in order to create databases and tables
• Create a simple 1-table MySQL database with the database administration tool
• homework 3

Classroom activities Wednesday

• Relational databases
• web hosting
• The anatomy of Wordpress

Homework X

Topic: Database definition (2-3 tables), Details to be announced on Wednesday.

Submission Dates

• This homework is due at start of wed week 4
• Students must upload an SQL file to the worldclassroom. The file must include some documentation
• Each homework counts 10% in your global evaluation. The four best homeworks will be taken into account.

Evaluation

TBA

Links and teaching materials

Online software

Teaching materials (slides and reading)

• Slides used: http://tecfa.unige.ch/guides/te/files/mysql-intro.pdf
• Lecture notes (very similar to slides): SQL and MySQL tutorial

You probably will have to complete my lecture notes with extra reading. Pick one of the following. (Unfortunatel, some of these articles are presented as multiple pages ....)

• Introduction to Structured Query Language: Version 4.11 by James Hoffman.
• Getting Started With SQL by Ted Brockwood
• What is SQL?
• Introduction to Databases for the Web: Pt. 1 by Selena Sol (most complete article)