CS Learning Journal

  WELCOME TO WEEK 1 Learning Journal This week I learned a lot of new things and revisited some old concepts that I needed practice with again. We reviewed how to convert number bases, which has been a while since I last did it. I actually find it pretty fun. Some of the new things I learned this week included the basic concept of an OS. Some of the things an OS does are virtualization, providing abstraction, and acting as a resource manager. I also learned about bash basics, file commands, and directory commands. I have already memorized a few. Hopefully, I will get to memorize more as I continue to practice. 

  WELCOME TO WEEK 8 Learning Journal - Final thoughts The three most important things I learned in this course are:  Database Design and Management SQL vs. NoSQL querying Data Integrity and Transactions.  Understanding the principles of design, indexing, and use of primary keys and foreign keys is important in order to create and maintain databases. Gaining experience in querying databases like CRUD operations and complex joins is important to know as well as understanding the differences between each query language. As mentioned, data integrity is very important. For example, transactions in MySQL and ATOMIC operations in MongoDB ensure data consistency and reliability in the different database systems. These fundamental areas give students a solid grounding in database skills, preparing them to design, query, and manage data effectively across various environments. I enjoyed this class and can't wait to apply what I’ve learned in the future. I'm excited to practice and fu

   WELCOME TO WEEK 7 Learning Journal - MySQL vs MongoDB Both MongoDB and MySQL have query projection, unique keys, and indexes. Relational databases support unique keys and auto-incremented primary keys. In MongoDB, all documents have a unique _id attribute that can also be autogenerated when there is no value set at insert time. Both use a query language to interact with data. MySQL uses SQL, while MongoDB uses its own query language based on JSON-like documents. Another similarity is that both systems support indexing to enhance query performance. MongoDB and MySQL also both support replication, which allows data to be copied for redundancy and high availability. Some differences between the two databases are that MySQL supports query joins, while MongoDB does not. MySQL is a relational database that uses tables, columns, and rows, which enforces a strict schema. MongoDB, on the other hand, is a document database that stores data in flexible, JSON-like documents, allowing easy chang

  WELCOME TO WEEK 6 Learning Journal - SQL Web App  This week, I learned a lot about database programming, programming languages, and database programming techniques. Techniques such as:  1. Embedded SQL: this involves coding SQL statements directly in a program written in another language. The keywords EXEL SQL precede all SQL statements.  2. Procedural SQL: this extends SQL Language with control flow statements, creating a new programming language.   3. Application Programming Interface(API): this refers to a library of procedures or classes. that link an application programming language to a computer service, such as database, email, or web service.  For this week's project, we implemented an API using MySQL Workbench for our database. I also learned about the Connection, Statement, ResultSet, PreparedStatement, and CallableStatement interfaces, along with their functionalities and functions.