SQL vs NoSQL | What's the Difference?
HTML-код
- Опубликовано: 20 авг 2024
- 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.i...
Data Analysis with Python - coursera.pxf.i...
IBM Data Analysis Specialization - coursera.pxf.i...
Tableau Data Visualization - coursera.pxf.i...
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/...
____________________________________________
Websites:
Website: AlexTheAnalyst.com
GitHub: github.com/Ale...
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
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!!!
Congratulations!! That's huge! So awesome to hear! :D
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!
Thank you! And thanks for watching!
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.
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.
I'm so honored to hear that - so glad my channel has been helpful!
Thank you! This has been one concept that I was having a hard time finding an explanation for.
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!
This is REALLY informative, would love for more similar short videos like this! You explained it really well, thanks Alex.
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
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 😃👍🏼
Thank you for explaining the concept in such brief and concise way.
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.
Nice Job Alex - Good Explanation
You’re my hero 🦸♂️
You're my hero too
Alex, this video is short and to the point esp coming from someone who is just starting out.
Can you do a video about freelancing with Data Analysis, I think lots of us are curious about it
I will!
Finally I can say database is easy to learn. Thanks Alex
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.
Thank you for special video on a special day Eid Mubarak Mr. Alex.
You're a blessing bro
i had to decrease the speed of the video to the half, but I got the points sound and clear....thanks
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
You're absolutely right :)
thanks for such an informative video. Very well explained.
Great source of knowledge about SQL and NoSQL but not good on steroids use and effect.
Great Video!
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.]
NoSQL just won't use tables with JOINs. No foreign keys.
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?
I could have if I wanted to make a 30 minute video, but this is meant to be a general overview :)
@@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.)
Very helpful ! Thank you !
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!
Thank you for sharing
Great video! Somewhy the mic sound felt a bit off in this vid, is it just me? It sounded a bit unnatural/robotic sometimes.
Yeah I've had some issues with my mic lately. Been trying to fix it, but may need a new mic soon.
Hey how you change excel to be white and no green? Your theme looks so cool in other videos.
Super glad to hear that :) I'm honestly not sure lol I think it may be the newest version of Excel?
Really helpful
very clear, thanks
great video thank you!
Nice video Alex! One question... Is a data lake one type of NoSQL database?
Intresting, tnx
Bravo!
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.
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.
Your camera overlaps some of the fields you showed in the presentation which I found disturbing, but thank you for vodeo
Yeah editing is not my best skill lol
Hi Alex can you tell me how to accept meeting invite automatically using ms graph api in outlook
Is that means there are chances for the sql to be no longer wanted in the few next years?
Hi alex
What is the best source to practice nosql?
Will you also teach us the R programming language ?
Probably not for a while - that's a video series I don't plan on doing for a while.
Can you suggest best online source to learn sql
I like Udemy for beginners - or youtube if you don't want to pay
Thanks for the reply do have any in particular in udemy
Without degree can I be called data analyst if I go for Google data analyst professional certificate?
I think you can and you can work toward landing your first job as a DA.
@@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
@@muhammadzeeshanali53 go for barber
Just stumbled upon your channel. I love it. So you have a sub from me.
Welcome! Glad to have you my friend :)