SQL vs NoSQL | What's the Difference?

I'm sure you've heard of SQL, but have you heard of NoSQL? In this video we talk about the differences between the two.
____________________________________________

SUBSCRIBE!
Do you want to become a Data Analyst? That's what this channel is all about! My goal is to help you learn everything you need in order to start your career or even switch your career into Data Analytics. Be sure to subscribe to not miss out on any content!
____________________________________________

RESOURCES:

Coursera Courses:

Udemy Courses:

*Please note I may earn a small commission for any purchase through these links - Thanks for supporting the channel!*
____________________________________________

SUPPORT MY CHANNEL - PATREON/MERCH

____________________________________________

Websites:
Instagram: @Alex_The_Analyst
____________________________________________

*All opinions or statements in this video are my own and do not reflect the opinion of the company I work for or have ever worked for*

[MH-zmgo]

Alex, your videos helped me land a position as a Fraud Data Analyst right out of undergrad. I was offered the position in October 2021, graduted in December 2021, began my role in January 2022. Thanks for being such a great resource!!!

[shaws]

Thank you for creating such a succinct video about this distinction! Also, the analogy with picking up a heavy couch using 2 different methods, was superb!

[andregaspar]

Thanks a lot once again, Alex! Your channel is the first place where I look for something related to Data Analytics. If someone asked me for a single channel about DA, I would recomend yours. Don't get me wrong, I do enjoy other channels, but I think the way you organize ideas and concepts is the most comprehensive for me.

[fy]

I use SQL for things like storing integer, decimal and boolean values and email addresses and password hashes. I always keep the sql table size relatively small. For large datas such as long text, image address et cetera, I use mongodb and I store the Id of the row from the SQL in the mongodb docs. I first select the values from the sql database then by the Id of that row, I select the mongodb doc's data. This way I reduce the select query load time significantly because when the sql memory size is kept small, it's much easier to select the id and then instantly find the document you're looking for from the mongodb. Also one more keynote to take here is that It's always good to make sure you overclock the memory and manually adjust the memory timings. For example if your tRFC timing is ridiculously high by default, drop it to something like 400-500, also If your tREFI timing is low like 9000, increase it to like 32000 or even more if you're not on an hedt platform. This way it'll take much less time to refresh the memory and you'll have more cycles to access to the memory. But you gotta run linpack xtreme and memtest and if you can, plug a gpu in and run a time spy loop in order to validate stability.

[rowaceodronia]

I am a Cloud Engineer and most of the time I'm dealing with the VM Instances and on the infrastructure side. SQL or Database is not my thing or I would say, I don't have a huge idea but because of this video, I am able to understand the differences between SQL and NoSQL as well as the benefits of the two. Thank you for this video bud! New subscriber here!

[mmac]

Thank you! This has been one concept that I was having a hard time finding an explanation for.

[adultingwithclo]

This is REALLY informative, would love for more similar short videos like this! You explained it really well, thanks Alex.

[kurosakishusuke]

Thank you for explaining the concept in such brief and concise way.

[eightyjournal]

Alex, this video is short and to the point esp coming from someone who is just starting out.

[sseulreal]

thank you for this vid! i was recently wondering what's the difference between the two and then you uploaded a vid about it haha love how your explanation is short & simple to understand 😃👍🏼

[diving_bernhard]

Thanks for this Video! There is NoSQL DBs with SQL query engines avaliable as well. For example CrateDB. Here you can use normal SQL grammar instead of learning a new like with Mongo.

[supersoniq]

Finally I can say database is easy to learn. Thanks Alex

[farazahmed]

Thank you for special video on a special day Eid Mubarak Mr. Alex.

[TheManubarcafan]

i had to decrease the speed of the video to the half, but I got the points sound and clear....thanks

[erickgomez]

Great source of knowledge about SQL and NoSQL but not good on steroids use and effect.

[WaliSayed]

Thanks, it is useful however what I realised is that No SQL databases store data in an unstructured way with low latency of data retrieval and a new field can be added without a major issue.

[azad]

thanks for such an informative video. Very well explained.

[soldout]

Can you do a video about freelancing with Data Analysis, I think lots of us are curious about it

[rodolforincon]

Just putting this out there, the reason why SQL doesnt handle big/large transactions well, is cause of the ACID properties, specially the i, which is isolation, meaning transactions happen wihtout interrupting or affecting others, thanks to that, many sql databases lock the rows or columns being used, so in the case of receiving large and many queries, its easy tor each the point where you are trying to access data thats been locked thanks to a previous query, so its kinda like a bottleneck

[leonardoaragaopimentel]

Nice video Alex! One question... Is a data lake one type of NoSQL database?