Computer Science BS Journal (CST363) : Week 4

    This week marks the halfway point for our class. There is so much I've learned in this class so far and I'm excited to keep moving forward. 

Briefly summarize 5 things what you have learned in the course so far.  

  1. SQL - I've learned that SQL (Structured Query Language) is used to manage and interact with relational databases. It lets you define data structures(tables), insert data, and query information using commands like SELECT, INSERT, UPDATE, and DELETE.
  2. Java Tuples - In Java, I learned that tuples are fixed-size collections of elements, used to group related values without creating a class.
  3. Java Predicates - A Java Predicate is a functional interface that represents a condition or boolean-valued function. I learned that it's commonly used in filtering operations with streams or collections, and takes one argument to return true or false.
  4. Bitmaps - I learned that a bitmap is a data structure that represents a set of bits (0s and 1s), often used to track presence or absence efficiently. In databases or indexing, bitmaps can be used to quickly perform operations like AND, OR, and NOT for filtering data.
  5. Java Ordered Index - An ordered index in Java refers to an indexing structure (like TreeMap or NavigableSet) that keeps keys in sorted order. I learned that it's useful for range queries and ordered traversal, and is often used in database-like structures for efficient lookups and sorting.

List at least 3 questions you still have about databases.

  1. When should I denormalize a database, and what are the risks?
  2. How do databases handle concurrent users or large volumes of data?
  3. What are common security practices in database design?

Comments

Post a Comment

Popular posts from this blog

Computer Science BS Journal: Week 4

  Part One: Set Your Educational Goals  Something I want to achieve by the end of this CS program at Monterey Bay is to have a portfolio full of projects. We learned in the recent weeks that a portfolio is more important than a resume for a programmer and I stand by that. I would like to have several large scale projects completed with my group and perhaps a few solo projects in said portfolio so I may display all that I have learned. My goal? Port-Fillio (Fill out my portfolio). Part Two: Set Your Career Goals      It may not seem like much but my career goals are sort of simple. I want to be a full-stack developer, the company I work for does not matter to me so much as the work-life balance. Traveling is very important to me so a remote job that gives me the freedom to move around is a must. I envision myself with my significant other putting in our hours and then going out to explore a new country we just landed in. This lifestyle has already been attained b...
Read more

Computer Science BS Journal: Week 2

Image
                                               Part 1: Review and Reflect Learning Strategy The Effective Study Skills google document goes into detail that every person is different when it comes to studying and retaining knowledge. Key tips and tricks that are proven to help with your studies are highlighted throughout the document which bring insight into how you should prepare yourself for a study session and how you should conduct your studies. Poor study skills are wasted time, and wasted time leads to frustration and low grades. From the document I can say that the top 3 things highlighted that I am already good at are scheduling, extracting important details, and reviewing and revising. On the other hand the top 3 things I feel that I need to work on are taking notes, taking examinations and gathering materials when I write. I tend to review...
Read more

Computer Science BS Journal: Week 5

Image
Post Interview Reflection Report Introduction : Who you interview and why. The expert’s name, title, and organization. A brief background on why you selected this person. I interviewed Joshua Brackett, he's been a close friend of mine for going on 8 years and he works in the same industry I'm looking to transition into. Joshua is a Customer Success Engineer working at Zipline. I decided to interview Joshua because as I mentioned, he's a close friend of mine and I felt it would be a more meaningful interview asking him directly. During the interview I felt like the information and tips I was getting was directed at me and not just a broad overview of his industry/job. Summary : Key takeaways from the conversation (e.g., career advice, insights into industry trends, technical challenges). Some key takeaways I got from the conversation was that a) your portfolio means a lot when you're looking for a job, technical knowledge is important for the interview process but they a...
Read more