I finished recreating all the tables that were mentioned in the manga and I think they are all functional. I practiced with some statements and they are actually kind of neat. I messed around with the product table a bit and selected different data by using restrictions like unit_price<800.
I also think it's worth mentioning that my sister is taking SQL classes and she needed help making a table so I became a bit more familiar with scripts and foreign/primary keys with the help of my brother.
Excellent! You are providing a wonderful example of project based learning in action ;-) The only effective way to learn SQL is to use sql to solve problems you find "neat" as you say. I've ordered a few more good books and have a few on the shelf, which I organized for the purpose of making them available to you. Let's talk today during class.
ReplyDelete