Skip to main content

CST 363 - Final Week

This week concludes CST 363.

Overall, the class was an interesting insight into database design, programming, and how to integrate databases into different programs and web applications.

Being my first class ever on databases (not counting the very brief encounter I had with SQLite in an Android development class a few years ago), I was initially overwhelmed with learning MySQL, a completely new dev environment (Workbench), and how to integrate my existing, yet still somewhat elementary, Python knowledge with SQL and HTML in order to create a working application.

My favorite part of course was designing the databases and writing the associated Python statements for the group project. The subject we decided to tackle was something I've wanted to do as a personal project as a long time, and it was great to see it come into fruition, at least on a smaller scale.

I believe the most important thing I've learned in this class is how to think about and analyze moving large amounts of data efficiently while preserving integrity and supporting multiple users. Before this class, I only thought about programming at a "low-level", involving small amounts of fixed data used by a single user on one machine. With my newfound knowledge of MySQL and database design, I can integrate these concepts into future projects or assignments and ensure my work can scale down or up with variable amounts of data. 

In terms of technical skill, I still have a lot to learn about MySQL and how to integrate a database into a program. I'm interested in seeing how I can use databases in something like embedded systems, or revisiting an older project and implementing an SQL database into it.

Comments

Post a Comment

Popular posts from this blog

CST 300 - Week 4

Educational Goals My current educational goals are to finish my bachelor's degree in computer science while also gaining a deep understanding of the fundamentals along the way. I have always believed that a solid understanding of the fundamentals goes a long way in any skill since you always refer back to them. When I have gotten stuck on a problem or some skill in the past, I have always taken a step back, broken down things into smaller pieces and remembered my fundamentals, and doing so has helped me through a lot of academic and professional work so far. Although I already know basic programming and data structures, I want to learn more about them and discover new ways of thinking in order to solve complex problems.  Career Goals I started a career as a full-time software test analyst about two months ago. Even though my job doesn't involve a lot of programming, getting a degree in computer science would be really helpful in all aspects of my career, such as identif...
3 comments
Read more

CST 300 - Week 2

Introduction This was a busy week for class! I started writing the first draft of my paper and got it done in a few days. It took a lot of thinking and research to get it done, but I'm glad I didn't procrastinate. Revising the first draft might take quite and effort as well. In the past when I would write geological reports, I found revising them was the hardest part. Part I. Speaking of hardest part, time management is something I am still getting used to, especially with this week's workload. Out of the items in the time management article, the top 3 things I feel like I am best at are: Creating a good study space Taking notes Reading  However, I could use some work on: Sticking to a schedule Revising lecture notes (on time) Studying within 30 min. of going to sleep Part II. Here's the activity log I filled out. It documented one of my Mondays at work. Part III. Project management skills are something I feel like I don't have enoug...
2 comments
Read more

CST 300 - Week 3

This week, we learned about ethics, ethical frameworks, and held a discussion about an infamous contemporary ethical scenario. After reading through this week's material I feel as if I have a much better understanding of ethics in society, and the motives behind people's decisions whether good or bad.  I'll admit I didn't pay much as much in depth discussion to Edward Snowden when he originally leaked all that information back in 2013, but after this week's discussion it really got me thinking about proper ethical behaviors in society and made me question much privacy I actually have as a US citizen.  Note: NSA, if you're reading this, say hi to my friend Chris for me. He's around the DC area somewhere and I'm sure you've run into him a couple of times. I swear he's a nice guy and doesn't bite.  Time Management and Studying I am getting much better at concentrating while working on papers and studying material. Unfortunately, I shoul...
2 comments
Read more