CST 363 - Week 1

 Hey everyone, I am back after a long break!

    This week was the first week of  a new course, Database designs. We came across a new language, SQL, and I must say, it was so much fun! Through Zybooks, we learned the basics. Professor's orientation video really helped to understand the concepts. 


Key Differences Between Databases and Spreadsheets

    To answer the questions, when starting to delve into data management, you might notice that relational database tables and spreadsheets look quite similar at first glance. Both structures organize data into rows and columns, which can make it easy to assume that they function in the same way. However, as you explore further, you'll discover that there are significant differences between the two.

    While spreadsheets are great for simple data tracking and analysis, they lack robust mechanisms for maintaining data integrity. Relational databases, on the other hand, are designed to handle complex relationships between different data sets through the use of keys and constraints.

    Spreadsheets are generally more suitable for smaller volumes of data. As data grows, performance can become sluggish, and managing large datasets can become cumbersome. They are also prone to errors, particularly when multiple users are involved in making updates. Databases are built to handle much larger volumes of data efficiently. They are optimized for performance, enabling quick data retrieval and manipulation even with extensive datasets.

    Searching and analyzing data in spreadsheets often require manual effort and can be limited in functionality. Relational databases use Structured Query Language (SQL) to perform complex queries and data operations.

Why Investing Time in Learning Databases is Worthwhile

- Whether you're dealing with increasing data volume or more complex data structures, relational databases can scale to meet these demands more effectively than spreadsheets.

- Databases offer advanced features for ensuring data integrity and security.

- Databases streamline data management tasks, making it easier to handle large datasets, perform complex queries, and generate reports efficiently.

What I Want to Learn in this Course

    I want to gain proficiency in SQL. This will help me interact and manipulate databases. I also want to gain problem-solving skills. It will help me in optimizing data queries and designing effective data structures. Lastly, I want to learn more about databases, which can help me in data analysis, database administration, and software development.


That was all for this week. See you next week!





Comments

Post a Comment

Popular posts from this blog

CST 334 - Week 6

 Hey everyone!      This week we submitted our research collab project. It was quite interesting and fun. I learned a lot and our team bonded more as well. We also learned many new things through our lectures and labs.       Concurrency is a critical concept in computer systems, enabling multiple processes to execute simultaneously. However, with great power comes great complexity.       A semaphore is a synchronization primitive that helps manage access to shared resources in a concurrent environment. Semaphores can be thought of as counters that control the number of processes allowed to access a resource. They come in two main types :             - Counting Semaphores : These can have values greater than one and are often used to manage a   pool of resources, such as threads or connections.           - Binary Semaphores : These function like locks and c...
Read more

CST 334 - Week 4

Hey everyone!       This week, I learned about how operating systems manage memory, which is one of their most important jobs. One topic was free space management , where the system keeps track of memory or storage that isn’t being used. Two common methods are bitmaps (using bits to mark if memory is free or taken) and linked lists (connecting free memory blocks together). Each method has its pros and cons, like how much space they use or how fast they work.      I also studied paging , which splits memory into small chunks called pages. These pages are mapped to physical memory, keeping processes separate and organized. However, this mapping can slow things down because the computer has to translate addresses often. To make it faster, Translation Lookaside Buffers (TLBs) store recent translations in a small, quick cache. I also learned about advanced page tables , which are smarter ways of organizing these mappings to save memory.    ...
Read more

CST 370 - Week 1

 Hey everyone, This week, we learned several important topics that form the foundation of computer science and programming. We started with GitHub and practiced using manual commands like git init, git add, git commit, and git push to manage our code. This helped us understand version control and how to keep track of changes when working on projects, especially when collaborating with others. We were also introduced to algorithms and learned what they are—step-by-step methods for solving problems. One example we focused on was Euclid’s Algorithm for finding the greatest common divisor (GCD) of two numbers. It uses a simple but powerful idea: repeatedly replace the numbers with GCD(b, a % b) until the second number becomes zero. We also practiced writing pseudocode, which helped us plan out algorithms in plain language before coding. We also had a homework assignment to help us further understand GitHub commands. Later in the week, we learned about graphs, both weighted and unweight...
Read more