Today I spent most of the day looking at two pretty good SQL tutorials and doing all of the exercises at the bottom of the pages. It helped me get acquainted with SQL queries. Bjoern helped me download SQL Lite and a Stack Overflow dataset, and I ran queries on the data through the terminal. It was pretty cool, however... I had a moment of frustration before realizing I missed a semicolon.

Also, I went to lunch today and got extremely lost on campus. The enormous hills don't help. I must have climbed up and down a million staircases. I also swirled around the building I needed because I wasn't used to seeing it from the front. So I saw my building, thought to myself 'where am I ?!' because I didn't recognize it, and then went up a massive flight of steps to the top of some hill...looked down and thought..I should have really been back by now. Luckily, I figured it out after going in several circles. The people on campus also have no idea where buildings are. It seems most of them are tourists, visiting students, or just not familiar with building names.
My first long practice query from an exercise on the tutorial: select customers.customerid, customers.firstname, customers.lastname, items_ordered.order_date, items_ordered.item, items_ordered.price FROM items_ordered, customers WHERE customers.customerid = items_ordered.customerid;
No comments:
Post a Comment