About Me
My name is Patrick Byrne and I am a Sophomore at Penn State University studying in the College of IST with a focus in Cyber Security. I am just beginning my career as an IT professional and this is almost all new to me.
I have always been interested in technology and electronics growing up. I have played video games all my life and was always truly fascinated with computers and how they work. I have taken a few coding classes through the University already and absolutely loved it. Aside from basic knowledge of the inner workings of computers and standard electronics, I have no prior IT experience. But that will change very soon. My goal with this degree in Cyber Security is to hopefully work for the NSA in their Cyber Defense division. When I look to the future and picture myself in this position, I feel nothing but excitement and passion.
This post will be the first of many. It will document my progression of becoming an IT professional. I can't wait to see my advancements from my early posts as time moves on and I hope you all will join me in this adventure. The video below marks my first steps in my adventure. I will be comparing the differences between SQL and NoSQL.
SQL vs. NoSQL
What is SQL?
SQL stands for Structured Query Language. This is a database that utilizes a relational data structure. The relational database means the data is structured vertically to recognize relations among stored items of information, like a table for instance.
What is NoSQL?
NoSQL is another type of data that uses a non-relational data structure. A non-relational database does not use the table/key model that a normal relational database would. It allows for a horizontally scalable data structure.
Popularity
SQL is much more a much more common database type given its strong data integrity through the use of ACID (Atomicity, Consistency, Isolation, Durability). While NoSQL allows for more flexibility and is usually faster than an SQL, the lack of ACID transactions make it a less appealing choice.
Top comments (0)