Downloading...

Welcome!

My name is Pranav Gowtam, but I'm also known as Incerah. I am a first-year student at Penn State, currently majoring in Cybersecurity Analytics & Operations. This post marks one of my first steps into the professional world.

During my time in high school, I spent a lot of my time involved in extracurricular activities. However, one that has influenced was Penn State Berks' Computer and Cybersecurity Camp in the summer of 2018, which introduced me to the security field. While my overall knowledge may not be as deep as some of my peers, I am motivated to continue learning and become a more well-rounded student.

For the foreseeable future, I plan to use this site to document my adventures in the professional world. I hope you stick around as well.

Alongside this blog, I will also be uploading videos onto my YouTube channel as I continue to develop my skills in the IT field. For my first video, I'll be talking about the differences between SQL and NoSQL.

For those who would like a bit of a TL;DW, here is some of the notes I made while researching for this video. You can find the full notes in the Pastebin link in the video's description.

• Both are types of databases. As a result, they have the same goal of storing data. The differences come in the way that they accomplish this task.
• SQL databases are relational while NoSQL databases are not. Relational databases define relationships using tables. NoSQL utilizes more a column system.
• SQL databases are vertically scalable (can increase load on server by adding things such as CPU or RAM), NoSQL is horizontally scalable (increase load by adding more servers). Imagine building more floors on a singular apartment complex versus making more houses in a large-spanning neighborhood.
• SQL uses a predefined schema, NoSQL uses dynamic schemas. For SQL, a lot of preplanning has to be in place because if there comes a time where a structural change is required, it is a large hassle to do so as all of the data within the database needs to have this change applied. Contrastingly, for NoSQL, it allows for a flexible schema that allows the user to change data structure more efficiently than SQL.

I hope I didn't stutter or pause too much; I haven't made videos like these in years, so I'm still a bit rusty. As time goes on, I'm sure that I will become more eloquent regarding my explanations. I also avoided doing too many jump-cuts just so I could see how I would do naturally.

While this may be just something I'll be doing for class for this semester, I plan to turn this into something beyond just an assignment page. In the future, when I start getting my feet wet with personal projects, I plan to keep a solid log of my development here alongside other topics. So, please consider subscribing to my YouTube channel and following here!

Thanks for reading!
Pranav/Incerah