Graduation Day: Relational Databases

So back in October I had described my journey to earn a shiny new Certificate in Relational Databases. With all the craziness that has occurred in Calgary in the last few days, I didn’t get around to this post, but on Wednesday, the day before the flood, I had my graduation ceremony.

Truth be told, I wasn’t sure I was going to go. But after discussing with Sony, she made me realize that I had to go. Of course, for the occasion itself and the celebration of completing the courses, but we actually thought that the fact I was graduating would be entertaining. Anyone who knew about this certificate would remember that it wasn’t the most fun undertaking. I was happy to be doing the courses, and the first few were great (fundamentals of relational databases and SQL querying 1 and 2). But administration wasn’t quite my thing, and business intelligence turned out to be one of the most poorly delivered classes I’ve ever taken. After the disaster that was BI (i.e. it received the worst feedback ever for the ICT department of continuing education), the certificate in relational databases was discontinued and replace by a certificate in database administration. And I completed the certificate using tuition support from the university, and because of the availability of the credits and the timing of the courses, the certificate took over a year to complete! In any case, there was a certain hilarity to all of it. Also, since my friend Paul graduated recently with a PhD, I thought I could ‘one up’ him with my certificate. In order to do so, I had to attend the ceremony 🙂

So I wasn’t sure what to expect. Sony and I arrived at the Red & White Club at the Olympic Volunteer Centre and we were surprised by what we saw. A lovely banquet area with chairs set up for a ceremony; refreshments with space for a full reception afterwards; and the number of people in attendance. There were so many families there- individuals with proud significant others and spouses; mothers and fathers who had worked hard while raising a family to get a leg up in their industry; recent immigrants to Canada upgrading or developing skills in order to successfully enter the workforce; and business leaders gaining extra credentials to help them in their careers. Looking around I felt proud to be among the graduates. Even though there’s a certain hilarity in my own path to getting the certificate, it was amazing to see many proud individuals around me, all celebrating lifelong learning and continuing advancement. Dr. Elizabeth Cannon, president of the University of Calgary, was there to shake hands, as well as Scott McLean, Director of Continuing Education. I guess it was nerves, but apparently I ran across the stage in lightning speed! That’s okay, I went back afterward for a photo with the two.

All in all, it was a wonderful evening. The ceremony was great, and the selection of food, drinks and snacks at the reception did not disappoint. Maybe it’s time to restart my journey for the Spanish language certificate! Let’s just say it didn’t go so well the first time…

ContedGraduation-1

UofC: I’m a Graduate!!

UofCGradLo and behold! I returned home after work on Friday to find a large envelope in the mail. What could it be?? I opened it up and received this:

I’m a graduate!! Yatta! Which means, I’m officially a University of Calgary Continuing Education Alumni! 🙂 Yay! UofC Continuing Education offers great courses in many different interest areas, certificates, and professional designations. As part of my current work, it is most fortunate that I am allowed to take 4 free continuing education classes a year. So when I was deciding on what to do, I chose the funnest topic out there: Databases! I have completed all four of the required courses for the Certificate in Relational Databases:

ICT128: Relational Databases Fundamentals (this was extra!)

ICT448: Microsoft SQL Server Introduction

ICT449: Microsoft SQL Server Intermediate

ICT450: Microsoft SQL Server Administration

ICT451: Microsoft SQL Server Business Intelligence

I even earned a shiny new certificate. Apparently, I now know something about how to use Microsoft SQL Server. And something about databases. Apparently. At the very least, I have proof that I learned something!

SQL Database What?

This may or may not depict how I feel right now.

I’m sitting in my database class right now. That’s right. I’m in class. I will attempt to focus for the next 3 hours (6 pm – 9 pm), but I make no promises. Actually, as I write this, my instructor is discussing something about how SQL server uses FILESTREAM, which stores data in a shared folder outside of the database, but SQL stores the location pointer in the database. Awesome! (Actually, I bet that description is completely wrong. That’s what happens when you don’t pay attention, ha!). 



SQL Server Administration class. Coffee is neccesary.

You see, the class I’m taking is Microsoft SQL Server Administration, which is part of my Certificate in Relational Databases through the University of Calgary. I’m all about learning and stuff. The first two courses in the certificate were related to SQL programming. At work, my statistical and database programming is done using SAS, and I can use the SQL procedure for my data manipulation. It makes life easier. So the first two courses were very helpful. However, SQL Server Administration? Say what? Exciting topics include installation and configuration, database management, SQL security, backup and restoring, automation, server monitoring, and high availability. Basically, I’m learning things that I probably won’t ever use, but I think they’re good to know. You never know when or what information will come in handy! For example, apparently it’s not a great idea to put your database on the C: drive. Makes sense I guess :). And a question was just asked- What are the important reasons for a transaction log? My answer: [Umm…. thinking… thinking… nothing]. Correct answer: backup, restore, and performance. Well then… *shrugs*… close enough. Obviously, I need to pay more attention.
Wrong answer. Close enough.