Database Systems - Week 1

    This week we learned about how a (DBMS) Database Management System works and how to create tables, insert data, delete data, and pull data using SELECT, DELETE, CREATE, and UPDATE commands.

    Databases are different from spreadsheets because the data are stored in tables that are relational and use key values to link to other tables.  Some other differences are that spreadsheets often times have formatted data and it is harder to access and manipulate.  Databases store data without formatting.  Also there are many different ways to access the data and only pull out the data you need within databases.

    There are many reasons to store data in a database rather than just in a file system.  You can pull data more easily by querying the database and find data much more quickly.  You can join tables to pull data together and organize it the way you would like.  Databases can also handle a lot of data and access it very quickly.  Also databases can be accessed by multiple people at the same time.

    Some of the things I would like to learn in this class in order to help me in my future career would be to learn the best practices for database setup and how to best implement indirect access to databases from while doing software development.  I want to end the class having a good comprehension of databases and how to interact with them.

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