SQL vs NoSQL | What's the Difference?

Подписаться 829 тыс.

Просмотров 59 тыс.

50% 1

Take my Full MySQL Course Here: bit.ly/3tqOipr
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:
Google Data Analyst Certification: coursera.pxf.io/5bBd62
Data Analysis with Python - coursera.pxf.io/BXY3Wy
IBM Data Analysis Specialization - coursera.pxf.io/AoYOdR
Tableau Data Visualization - coursera.pxf.io/MXYqaN
Udemy Courses:
Python for Data Analysis and Visualization- bit.ly/3hhX4LX
Statistics for Data Science - bit.ly/37jqDbq
SQL for Data Analysts (SSMS) - bit.ly/3fkqEij
Tableau A-Z - bit.ly/385lYvN
Please note I may earn a small commission for any purchase through these links - Thanks for supporting the channel!
____________________________________________
SUPPORT MY CHANNEL - PATREON/MERCH
Patreon Page - / alextheanalyst
Alex The Analyst Shop - teespring.com/stores/alex-the...
____________________________________________
Websites:
Website: AlexTheAnalyst.com
GitHub: github.com/AlexTheAnalyst
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

Опубликовано:

30 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 67

@MH-zm8go 2 года назад

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!!!

@AlexTheAnalyst 2 года назад

Congratulations!! That's huge! So awesome to hear! :D

@andregaspar382 2 года назад

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.

@AlexTheAnalyst 2 года назад

I'm so honored to hear that - so glad my channel has been helpful!

@shaws1249 2 года назад

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!

@AlexTheAnalyst 2 года назад

Thank you! And thanks for watching!

@mmac8359 2 года назад

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

@adultingwithcheryl 2 года назад

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

@AlexTheAnalyst 2 года назад

Thank you! I plan on it - I just finished recording MySQL vs Postgresql vs SQL Server in a similar style. Trying to inform the masses! :D

@sseulreal 2 года назад

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 😃👍🏼

@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!

@kurosakishusuke1748 2 года назад

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

@fy7589 2 года назад

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.

@azad5932 2 года назад

thanks for such an informative video. Very well explained.

@diving_bernhard 2 года назад

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.

@charlesmiller2341 27 дней назад

Nice Job Alex - Good Explanation

@E_Gaks 2 года назад

Very helpful ! Thank you !

@farazahmed1668 2 года назад

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

@eighty7journal Год назад

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

@Fotini0018 2 года назад

Hey Alex! Thank you so much for giving us your knowledge and sharing your experiences! I feel so greatful for finding you! I am a future data analyst (I took the Google Data Analytics course from coursera) and I have an issue. I want to practice on SQL and I cannot find a software to do data entry (my laptop has windows 7 operating system) could you please help me? I desperately want to practice on that!

@ericvt 2 года назад

Great Video!

@anavasquez6917 Год назад

very clear, thanks

@TheManubarcafan 2 года назад

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

@leonardoaragaopimentel6090 2 года назад

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

@chaoukimachreki6422 Год назад

You're a blessing bro

@johnjung-studywithme Год назад

great video thank you!

@mengyushen7684 2 года назад

Thank you for sharing

@danielihenacho 2 года назад

Really helpful

@supersoniq4102 Год назад

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

@DonHrvato 2 года назад

Intresting, tnx

@tobaplays321 2 года назад

Hi Alex, thank you for this wonderful video. I was wondering if you could do a video on how to fix the error message “role does not exist” in popsql.

@samfelix4385 2 года назад

You’re my hero 🦸‍♂️

@AlexTheAnalyst 2 года назад

You're my hero too

@channelino24 2 года назад

Bravo!

@erickgomez7775 2 года назад

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

@WaliSayed 8 месяцев назад

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.

@Quashieyute 2 года назад

Quick question, How does one break into the healthcare industry as a data analyst with no experience in that industry. All I have is a project about analyzing covid vaccination rates which I did research on. I want to work with clinical data or data where I can have an influence in policies or effectiveness of a treatment program.

@soldout9625 2 года назад

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

@AlexTheAnalyst 2 года назад

I will!

@rodolforincon8431 2 года назад

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

@AlexTheAnalyst 2 года назад

You're absolutely right :)

@PeterCorless 2 года назад

A NoSQL database may or may not store data in a table with rows and columns. Definitely a wide-column database will be a row-oriented store with columns. [Cassandra or ScyllaDB, for example.]

@PeterCorless 2 года назад

NoSQL just won't use tables with JOINs. No foreign keys.

@Javerto 2 года назад

Hey how you change excel to be white and no green? Your theme looks so cool in other videos.

@AlexTheAnalyst 2 года назад

Super glad to hear that :) I'm honestly not sure lol I think it may be the newest version of Excel?

@jazzcat969 2 года назад

Great video! Somewhy the mic sound felt a bit off in this vid, is it just me? It sounded a bit unnatural/robotic sometimes.

@AlexTheAnalyst 2 года назад

Yeah I've had some issues with my mic lately. Been trying to fix it, but may need a new mic soon.

@bazoo513 2 года назад

Not a word about access methods? _Why_ is retrieval latency and scalability of NoSQL DBs supposedly better then that of relational databases? what makes search of unstructured (or semi-structured) data fast? Also, not a word on possibility of horizontal scaling of relational databases via table partitioning over many cluster members?

@AlexTheAnalyst 2 года назад

I could have if I wanted to make a 30 minute video, but this is meant to be a general overview :)

@bazoo513 2 года назад

@@AlexTheAnalyst Fair enough, but like this it sounds like "it's better, trust me". Perhaps not half an hour, but another five minutes? BTW, you are not alone in this. I am yet to find a decent beginner's intro that is more than handwaving (on YT or elsewhere on Interwebs.)

@iitian2012 2 года назад

Hi alex What is the best source to practice nosql?

@PavanKumar-tr9by 2 года назад

Hi Alex can you tell me how to accept meeting invite automatically using ms graph api in outlook

@lody33100 2 года назад

Is that means there are chances for the sql to be no longer wanted in the few next years?

@piggyraccoon5464 2 года назад

Your camera overlaps some of the fields you showed in the presentation which I found disturbing, but thank you for vodeo

@AlexTheAnalyst 2 года назад

Yeah editing is not my best skill lol

@tsw-z9g 2 года назад

Will you also teach us the R programming language ?

@AlexTheAnalyst 2 года назад

Probably not for a while - that's a video series I don't plan on doing for a while.

@sravanganta4843 2 года назад

Can you suggest best online source to learn sql

@AlexTheAnalyst 2 года назад

I like Udemy for beginners - or youtube if you don't want to pay

@sravanganta4843 2 года назад

Thanks for the reply do have any in particular in udemy

@muhammadzeeshanali53 2 года назад

Without degree can I be called data analyst if I go for Google data analyst professional certificate?

@AlexTheAnalyst 2 года назад

I think you can and you can work toward landing your first job as a DA.

@muhammadzeeshanali53 2 года назад

@@AlexTheAnalyst need one more advise please ... What will you recommend once I learned and start job as a data analyst should I go for machine learning engineer domain ( so called AI ENGINEER) or for Data Engineer / science