DEV Community

Andrew Maier
Andrew Maier

Posted on

3...2...1... Liftoff

What's up everyone, my name is Andrew Maier and I'm a freshman at Penn State University studying Cybersecurity Analytics and Operations. This fall I'm beginning my journey to become an Information Security professional.

In high school, I learned through my extra- curricular interests that I loved problem solving and I craved efficiency. Not too much later, I found myself in an air gap lab observing a cybersecurity club. Thats when I knew that I wanted to work in InfoSec.

In my eyes, cybersecurity brings together the perfect marriage of hardware and software knowledge to serve the public through risk mitigation strategies. I'm a bit of a tech gear head, so the infrastructure and networking background that I will have as an IT professional is exciting.

At the moment, I'm looking toward a career either cyber defense or penetration testing. I have a lot of work to do to get there, so follow along with me as I gain more skills that I will seed as an InfoSec professional.

Take a look at what I'm doing to build my online presence as an InfoSec professional in the 21st century.

This video will contain many resources for up and coming IT students who are looking to start their own journeys to becoming a professional. Additionally, it discusses my first topic: the differences between SQL and NoSQL and their ideal use cases.

In Summary:

  • SQL databased are relational, while NoSQL databases are non relational.
  • SQL Databases have a predefined dataset schema, while NoSQL databases have a dynamic schema. This provides structure, organization, and quick deployment times to datasets in a SQL database, while NoSQL databases allow for flexible organization.
  • SQL Databases are primarily table based while NoSQL databases can have many formats that are dependent on the use case (Table, Document, Graph, etc.)
  • SQL Databases allow for flexible queries due to their relational nature, while NoSQL databases
  • SQL Databases typically have one node and no partitions, and are managed by one machine that is 'vertically scalable' to manage traffic. NoSQL databases usually have a number of nodes and a hashing formula that determines what node a particular dataset exists on. So, NoSQL databases are 'horizontally scalable, meaning that they can be expanded by adding more machines (nodes) to the system.

I plan to utilize this space to write about different projects that I'm working on to sharpen my skills and I also plan to use GitHub to manage the large projects that I work on, and also as a backup for my work.

As I begin to learn more about the InfoSec space, I will document my findings and failures as I grow into this new and complex space.

Top comments (0)