README.md 1.64 KB
Newer Older
Sorrel Harriet's avatar
Sorrel Harriet committed
1
2
3
4
5
6
7
8
# Lab Exercises

Welcome to the lab exercises repo! 

Here you'll find all the example code which accompanies weeks 1-10 of **Data, Networks & the Web**. The example code is for a music store app, so you will need to adapt it for whatever app you're developing. Remember to comment the code to show your understanding.

## Topic finder

Sorrel Harriet's avatar
Sorrel Harriet committed
9
10
11
12
13
14
15
16
17
18
19
20
21
22
Here's a reminder of the topics covered in each lab session. Please note, topics may be subject to change if a lab has not yet occurred.

### Lab 1: Setting up your development environment (6/7 Oct)
- creating a project repo
- cloning your repo to IGOR and/or locally
- mounting IGOR (if applicable)

### Lab 2: Introduction to relational databases and SQL (13/14 Oct)
- Designing a schema
- Defining a schema in SQL (TABLE CREATE)
- Inserting data (INSERT INTO)
- Basic querying (SELECT)

### Lab 3: SQL sequel! (Advanced querying) (20/21 Oct)
Sorrel Harriet's avatar
Sorrel Harriet committed
23
- Sorting (ORDER BY)
Sorrel Harriet's avatar
Sorrel Harriet committed
24
25
- Table joins
- Aggregate functions
Sorrel Harriet's avatar
Sorrel Harriet committed
26
- Comparison operators
Sorrel Harriet's avatar
Sorrel Harriet committed
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45

### Lab 4: Security and integrity! (27/28 Oct)
- Data normalisation
- Backup/restore

### Lab 5: Using PHP to interact with a MySQL database (10/11 Nov)
- mysqli API
- Displaying data

### Lab 6: Basic Application Design (17/18 Nov)
- Code organisation ('separation of concerns')
- Single Point of Entry (SPOE)
- Creating and changing 'views'
- Passing parameters in GET

### Lab 7: Form handling and data manipulation (24/25 Nov)
- POST method
- Basic data sanitization methods

Sorrel Harriet's avatar
Sorrel Harriet committed
46
47
### Lab 8: Implementing transactions & read locking in PHP (1/2 Dec)
- Transaction & read locking examples
Sorrel Harriet's avatar
Sorrel Harriet committed
48
49
50
51

### Lab 9: Introduction to MongoDB (non-assessed) (8/9 Dec)
- Document structure
- Creating a collection
Sorrel Harriet's avatar
Sorrel Harriet committed
52
- MongoDB CRUD operations