Today started with multiple review videos on the CLI Gem Project. I also was able to schedule my project review for Wednesday night. I’m looking forward to some one-on-one time with an instructor talking through my code. The project states:
BE PREPARED TO:
1. Explain your code from execution point to exit point. We’re making sure you wrote it and understand how it works, nothing else. 10-20 minutes
2. Refactor code. 10-20 minutes
If necessary, after the assessment, be prepared to:
1. Extend the application with a new feature, more data, a different domain etc. 20-30 minutes
2. Submit an improved version.
However, until then I’m pushing on.
Today I got through most of the SQL (Structured Query Language) section of the curriculum, 89% to be exact and I’m committed to finishing it up tomorrow. In this section I’m learning:
– How to create SQLite3 databases.
– How to create, update, select, and delete data from database tables.
– How to relate data within a given database.
– How to write SQL code in both my command line and my text editor and execute the code against a database.
– How to write Ruby programs that talk to and save data to my databases.
I have to say it’s more interesting that I thought it would be. In addition, I can see perfectly how databases fit into the whole web app ecosystem. It’s also fairly easy to pick up the SQL DSL (domain specific language) because it’s pretty much just procedural coding. I also have done a couple intro SQL Server courses in the Microsoft Virtual Academy so the vocabulary wasn’t new to me and I understand the 30,000 ft view of databases and relational databases.
Time spent today: 6:00
Time spent total: 124:21
Lessons completed today: 17
Lessons completed total: 307