Database Systems - Week 4

Here are five of the things I have learned in this course so far.  One is that databases are very useful for organizing data effeciently as well as finding and formatting data quickly.  Two is that you can join tables together to pull data together and see much more data concurrently.  Three is that you can create temporary tables called Views that you can use to pull pertinent data more easily.  Four is that you can select data from other sub select statements which allows you to do things otherwise unavailable.  Five is that you can alter tables and change them in the future if needed.

Here are three of the thing I would like to learn about.  First is I would like to learn about Big Data databases as I have heard a lot of references to them and I am not really sure about how they differ and what they are useful for.  Second is I would like to learn more in depth about how to do complex data pulls as I still struggle sometimes to figure out how to get the data I want.  Third I would like to learn about using Microsoft SQL Server and .NET for web apps using the database.

Comments

Post a Comment

Popular posts from this blog

Learning Journal Final Entry...

     Well, this is the toughest journal entry I've had to write so far as I am excited to be moving forward but sad to finish this journey I have been on for so many years. I am 39 years old and have wanted to be a Software Developer since I was a kid. I had big plans while attending Jr College but life had a different plan in mind where I started a family at the age of 19 and I decided to put my goals of software development on hold. 17 years later, I was married to my wife raising 3 children, and working at the High School I graduated from while also coaching Football and Wrestling. I loved what I was doing but I felt like I missed out on my goals.      Covid hit and everything shut down. No more coaching and most of my job duties were diminished. It was at that time that I decided I would go back and finish my degree and make my career in Software Development a priority. Now here I am 4 years later and I'm finally finishing what I started out to do. I fi...
Read more

Software Engineering - Week 8

This is the final week of my Software Engineering class and I thoroughly enjoyed working on the projects I was presented with.  The five most important things I learned in the class are Selenium automated testing, Spring Boot Framework, Authentication, Stories and Epics, and React. I chose these because they have the most real-world applications and interest me. I have seen these things listed in job descriptions and knew they were used in many applications. Using Selenium to automate testing is a nice skill to have as it allows you to automate web browser interactions, making it easier to test web applications and have repeatable tests when updates are released. Spring Boot framework allows you to build web applications more quickly and with less code and is fairly simple to implement. Learning Authentication using JWT (JSON Web Tokens) is a very good skill because so many web applications use authentication. Learning about the Agile methodology and how it works with epics and sto...
Read more

Computer Networks - Week 8

This is the final week of my computer networking class, and it's been a journey of learning and discovery. This week, we focused on some security implementation, learning about firewalls and intrusion detection systems. I learned about the fundamentals of firewalls, which act as a protective barrier between internal networks and the outside world. Firewalls help with filtering network traffic and preventing unauthorized access. We also learned about intrusion detection systems (IDS), which are designed to detect and respond to potential threats or attacks within a network.  At the link layer, we focused on wireless security, recognizing the importance of protecting wireless networks from unauthorized access. I learned about encryption methods, authentication mechanisms, and best practices for securing wireless networks. Lastly, we have been working on finishing our team project and it has been a great learning experience.  This class has been an enlightening experience learnin...
Read more