This is our first week using Reclaimhosting for its hosting and web capabilities.
Create full data model you diagrammed in Physical lab
Try your best at data types and matching what you had
Populate the tuples with data (via insert statements)
Add at least 3 records per table
Using PHPMyAdmin and your database as a backdrop, create a video demonstrating CRUD operations
Use your database to perform a Create (INSERT) statement both using MySQL as well as manually to show the parallel
Read (SELECT) to select data, attempt a JOIN to present data from two tables mashed together
Update (UPDATE) to update a piece of data
Delete (DELETE) to drop a record from the database
Show your data model / database as your navigating
No written portion this week only technique demo
I want to see a full database matching your model
I want to see multiple tuples populated in examples
Prepare statements ahead of recording (like 4 that you know work) that way when your doing them in the recording you know they already are valid
Complete the 52 practice exercises
https://www.w3schools.com/sql/exercise.asp
Create explained and demonstrated effectively (2 pts)
Read explained and demonstrated effectively (2 pts)
Update explained and demonstrated effectively (2 pts)
Delete explained and demonstrated effectively (2 pts)
8 point lab
Submit your screencast to slack channel
Submit link to video in #lab4-sql-basics channel on Slack
This is due by Sunday at 11:59pm