Skip to main content

Completed a course at BCIT: Relational Database and SQL

Back in December 2011, I just completed a 12-week evening course COMP 1630 at BCIT in downtown Vancouver. This was a great course worth 5 credits, and delved into database design, architecture, a little systems analysis, and a lot of SQL syntax. We learned about Crow’s Foot Notation in building an initial requirements design before translating that into actual tables, columns, indices, contraints, etc. It helped strengthen what I already knew of database systems and look forward to taking database administrator-type courses this year.
Labels:

Comments

Post a Comment

Thank you for your feedback.

Popular posts from this blog

Logitech Circle 2 Security Webcam has gone Offline (SOLVED)

In November 2022, I realized that my webcam had stopped working. I took it down from above my door mount in order to troubleshoot closely. The unit would power on with a steady white lighting around the front but I was used to seeing green. When I press the button to reset it, it would reboot and start flashing different coloured lights but when I release the button, all lighting would stop.     I looked at Logitech’s support site to find out how to properly reset it. It was simply to hold the button a few seconds until lights start blinking, which is what I have been doing. I had the wired model so I plugged in the unit via USB to my Windows computer to attempt to connect to it. I had a hunch that there was a firmware update that it automatically tried to download and run, and that update caused this. I was right. A few other users on the Logitech forums reported the same symptoms I was experiencing with my Circle 2 webcam. Here was one specific post that I responded to:...
Post a Comment
Read more

What to do when Settings will not open on your iPhone?

My daughter complained about not being to launch the Settings menu from her iPhone11. She has restarted multiple times already. I looked at the obvious like resetting making sure screentime is disabled on her account and tried ways to reset without losing her photos and videos. Everything I tried required access to the Settings menu. I was sure it wasn’t a hardware issue but a software configuration issue. The second part of my troubleshooting involved wiping the phone and restoring from backup in order to rule out the hardware issue theory. To do this, I used iTunes on my Windows computer and connected the iPhone to my computer using usb cable. In order to perform backup, the local storage on your C drive has to have sufficient disk storage to accommodate the total size of photos and videos on the iPhone. This is where most of my problem was. The backups are stored on these paths: \Users\(your username)\Apple\MobileSync\Backup\  or \Users\(your username)\AppData\Roaming\Apple Comp...
Post a Comment
Read more

How I passed the AZ-104 Microsoft Certified: Azure Administrator Associate Exam

I had been planning to take the Microsoft Certified Solutions Architect track back when the prerequisite was AZ-303 and AZ-304. Life got in the way and now these two prerequisites have been deprecated and replaced by AZ-305. However, in order to take this exam, I needed to get through AZ-104 first. Here are resources that I used to prepare for it: * GlobalKnowledge/Skillsoft 4-day BootCamp. I have been using this training company for a while now but it has steadily just gotten worse. The trainers are outsourced and not very professional in my opinion. I do not recommend GlobalKnowledge at all. I didn’t really learn much from the lesson material but the lesson/challenge labs were very helpful. This bootcamp comes with an Azurepass subscription and a free exam voucher. I actually racked up to $90 out of the $100 credit provided on this subscription which expires in 12 days so I better delete all the resources before then to avoid incurring more. I initially booked the exam the end of Dec...
Post a Comment
Read more