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!!!
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!
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 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.
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!
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 😃👍🏼
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.
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.
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!
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.]
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
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 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.)
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.
@@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
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!
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!
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.
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 explaining the concept in such brief and concise way.
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 😃👍🏼
Alex, this video is short and to the point esp coming from someone who is just starting out.
You're a blessing bro
You’re my hero 🦸♂️
You're my hero too
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.
Thank you for special video on a special day Eid Mubarak Mr. Alex.
i had to decrease the speed of the video to the half, but I got the points sound and clear....thanks
Nice Job Alex - Good Explanation
Finally I can say database is easy to learn. Thanks Alex
thanks for such an informative video. Very well explained.
Great Video!
Great source of knowledge about SQL and NoSQL but not good on steroids use and effect.
Can you do a video about freelancing with Data Analysis, I think lots of us are curious about it
I will!
very clear, thanks
Thank you for sharing
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.
Very helpful ! Thank you !
great video thank you!
Intresting, tnx
Really helpful
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!
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.
Nice video Alex! One question... Is a data lake one type of NoSQL database?
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 :)
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?
Bravo!
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.
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.)
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.
Hi Alex can you tell me how to accept meeting invite automatically using ms graph api in outlook
Hi alex
What is the best source to practice nosql?
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
Is that means there are chances for the sql to be no longer wanted in the few next years?
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
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.
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 :)