This was a fantastic overview. Clear, Concise, Accurate, and brilliantly visualized.
@marcydoes
2 жыл бұрын
I am so impressed by this. Everything from your articulations to your drawings to the video editing. And of course, your knowledge base is impressive yet you make it so consumable.
@pvergadia
2 жыл бұрын
Thanks @Marcella!
@lalala-mh6kh
2 жыл бұрын
beautiful! perfection! I was having a hard time trying to understand what the difference is, and many videos just talked about sql and nosql, but yet I couldn't understand. This video visualizes the differences and is easy for a beginner like me who has no experiences in dbms. Simple, yet very efficient!
@strengthproject
2 жыл бұрын
I hope you do more videos soon ❤
@pvergadia
2 жыл бұрын
I will surely create more soon! Thanks for the encouragement.
@nsimbaamandamawete1266
4 күн бұрын
This was the best and easiest-to-understand video on this subject. Since I just started taking database classes, it is good to know that The Cloud Girl thought about some of us: the rookies in the Database field. Thank you!!!
@DennisIvy
2 жыл бұрын
Wow this channel is a Gem! Needed a refresher on this topic and found gold. Subbed!
@sylviamohos8541
2 жыл бұрын
This is so well explained. You are so clear and informative. Thank you for your excellent delivery!
@Joshua-Gee
Жыл бұрын
This was incredible! I hope you come back to make more videos you’re a remarkable teacher
@561Aloha
Жыл бұрын
I have to take this as a class and I have been intimidated by this subject. I was recommended your video by KZitem and I’m happy to have found you.
@ankit1703
2 жыл бұрын
Great content, thanks to KZitem algorithm for suggesting this video and thanks to you as well.
@pvergadia
2 жыл бұрын
Amazing to hear, thank you!!
@hobbesnblue
Жыл бұрын
Thank you Priyanka! I was finding it surprisingly hard to find a suitable explainer in terms accessible to me. I will enjoy poking around your channel more!
@Velo1010
Жыл бұрын
You produce some of the most outstanding videos. I especially like you tone, pace, and comprehension.
@joyyou100
2 жыл бұрын
The best video on this topic I found on YT. Thank You!
@njuniorba
Жыл бұрын
I love NoSQL Databases. It's been a long time since I don't use relational database in my projects and some customer projects. Thanks for you video! Additional information: RavenDB is BASE and ACID 100% 👍
@lsdimontenegro5705
2 жыл бұрын
Absolutely wonderful, from delivery to knowledge shared to beautiful layout. I learn so much from you Ms. P!
@pvergadia
2 жыл бұрын
Thanks for sharing you feedback, glad you found it helpful.
@sarthaknikhal5540
3 жыл бұрын
That was a great explanation. And a simple person with a non CS background can understand DBs well by watching this video
@pvergadia
3 жыл бұрын
So great to hear that you found it helpful.
@fatriantobong2097
Жыл бұрын
simple explanation shows how good you are, some explain with new confusion to arise, so good job
@danielhughes5250
2 жыл бұрын
Best explanation I've seen yet. Thank you and well Done.
@nkengchrist
Жыл бұрын
Concise, chewable bytes, easy-to-digest explanation. Thanks for sharing!!!
@TheKyleHuss
Жыл бұрын
Best ever explanation on the databases I came up so far. Thank you!
@fuckingeasyprogramming9843
2 жыл бұрын
Wau! Amazing description of the topic! Thank you, it is great pleasure to watch your video - it would be nice to see practical usecases for each DB from you, maybe one case with 100000000 data items but realization by this two ways -> and there we can see practically what DB is better for
@luxxart
Жыл бұрын
Really good overview, thank you!
@narenandu
3 жыл бұрын
Clearly articulated .. Thanks for the video
@4Meghasharma
2 жыл бұрын
Big Fan ... Loved the way you explained it!!
@recursion.
10 ай бұрын
Amazing explanation. I was also hoping to see the horizontal vs vertical scaling in your words but nonetheless it's really a one stop video for SQL vs NoSQL on KZitem. :)
@muzaffarali5870
2 жыл бұрын
Beautifully explained with simple and concise examples, well done!!
@EmperorFool
Жыл бұрын
By "data changes", do you mean changes to the * of the data? It seems so from the context. SQL databases handle frequent data changes (inserts and updates) just fine, but changes to the structure of the data (altering tables) are more difficult than in NoSQL. In my experience, NoSQL is better at frequent-reads-infrequent-writes whereas SQL has no trouble with frequent writes. Thus SQL being preferred for OLTP as you said. Very good presentation, thank you!
@bornkool
2 жыл бұрын
A great presentation of SQL and non-SQL databases nicely organized presented and explained bravo! Thank you for a lesson well delivered.
@a_simpmel_life
3 жыл бұрын
Very clear. Nice clean diagramming as well as explanations of the differences at a high level. I love it!
@anuragsharma7331
2 жыл бұрын
simply awesome, loved the way you explained and quoted the examples.
@savinda3036
2 жыл бұрын
Great explanation. I understood everything perfectly.
@cedricsarigumba4370
5 ай бұрын
This is the best channel! You have a talent to simplify complicated topics. ✨✨
@pvergadia
4 ай бұрын
Thank you!
@BlaBlaBlaInDaHouse
Жыл бұрын
Fantastic video! Probably the best explanation on the topic
@khayla_matthews
2 жыл бұрын
Best explanation I have come across on these concepts. Thanks so much!
@sagarbarge6706
8 ай бұрын
Clearly explained. Thank you
@greendsnow
2 жыл бұрын
Finally! She's got her own channel!
@adamjenkins3065
Жыл бұрын
Beautifully outlined. Thanks!
@shaunrashidYT
Жыл бұрын
Thanks for this! It helped me make a decision on what kind of database to use on a side project.
@gibbslm
Жыл бұрын
Great content! thank you so much it's so clear and mindblowing video editing 😮😍
@patbhavik1
Жыл бұрын
Well explained and completely awesome!!
@cynthiaclark6157
Жыл бұрын
This was explained so well. Thank you!
@pvergadia
Жыл бұрын
Thank you!!
@coding3438
2 жыл бұрын
Yooo this is the pub sun playlist girl from google channel! Good to know she has her own channel!
@Vollidiot39
2 жыл бұрын
This tutorial is great! Thanks so much.
@Diaba_dos_compiuter
2 жыл бұрын
You are an amazing teacher, Thank you very much
@squapdoot
2 жыл бұрын
Fantastic video! Thank you so much for making this 😄
@rajalanka1563
2 жыл бұрын
Some SQL based MPP databases do offer Horizontal and elastic scaling as well. They are not limited to vertical scaling only.
@ganeshpalve266
3 жыл бұрын
That's the best explanation of sql nosql relevant to gcp
@timucinbahsi445
Жыл бұрын
Great video. thanks to everyone involved. always a blast to see someone who knows about the subject so much, she has to be mindful she doesn't introduce too many concepts. cheers. u introduced just the right amount imo. though, i still am not clear on how nosql is not just a usecase of sql. all the advantages of nosql seems to be available due to its limitations. i mean, i can just create a table on an sql db with two colomns, key and value. a primary key and a json field. then i can scale it horizontally as i don't have to worry about keeping related rows on the same node. there won't be any related nodes. it will be very flexible too as all the data is json. i mean, all the advantages of nosql are still available in sql if u give up sql advantages. obv, i'll still use nosql regardless. it's easier to just use redis than configuring postgres to hold a cache table on RAM. however, i wouldn't develop redis as a whole new system instead of a postgres plugin/extension if i were to be in that position
@polinastamenova6655
3 жыл бұрын
Thank you for this video. I really love the way how you explained it. The best one I found! :)
@pvergadia
3 жыл бұрын
Thanks Polina!!
@rebeccadejesus5256
Жыл бұрын
Great job! Your explanation was very detailed and understandable! Thank You.
@tpenn2
Жыл бұрын
Wonderfully done.
@EnglishwithTerry
2 жыл бұрын
Excellent video, excellent explanation
@ppnehe
2 жыл бұрын
Excellent video ...very short to the point and no nonsense beating around the bush .... If SQL Databases are required to be vertically scaled then how does it meets the scaling needs as vertical scaling has limits in terms of CPU / MEM / Storage ? On event day how is it possible to achieve scaling out when horizontal scaling is not possible in SQL databases and also scaling in ?
@stuti.sharma.ranchi
2 жыл бұрын
Really good explanation. I have seen this after going through a lot of material on this topic.
@pvergadia
2 жыл бұрын
So good to hear!! thank you.
@patrickchan2503
Ай бұрын
neat handwriting, thanks
@swamynyc
3 жыл бұрын
Excellent material & presentation though have to say i'm a noob & probably not the intended target demographic. Curious about any differences in how secure they are
@EugenePetrash
2 жыл бұрын
Best explanation. Thanks!
@dharmendracherukuri7530
Жыл бұрын
Good Articulation. thank you.
@bjm1100
Жыл бұрын
Informative and a fusion of art and logic. Great videos!
@sumitkothalikar
3 жыл бұрын
Nicely explained, thanks for explanation
@bhargavigoud4524
2 жыл бұрын
Very clear mam thank you very much
@upendertadewar8454
3 жыл бұрын
Nice explanation. Thank you
@LuizFelipeBom
Жыл бұрын
So clear, thank you so much.
@jimmycheong7970
2 жыл бұрын
This was very clear!
@VictorSantos-yb8ir
2 жыл бұрын
It helped me a lot, thanks!
@vineetdave7323
3 жыл бұрын
Amazing explanation. Very succinctly put.
@pvergadia
3 жыл бұрын
Thanks Vineet!
@mohammadkhalid7885
Жыл бұрын
what a beautiful explanation .
@elizabethmilonas2249
2 жыл бұрын
excellent explanation. Nicely organized and very clear. Thank you!
@AniketBankapur
Жыл бұрын
great video liked it
@anastasiakutsevolova1320
2 жыл бұрын
Great explanation!
@JoyFay
2 жыл бұрын
Very well explained
@lex8799
2 жыл бұрын
Thank you so much!!!
@AmarMishra
Жыл бұрын
Hi, I have two questions. Q1. Can non -structured database be designed into 2 parts : static(structured) and other being(dynamic) thus can imbibe both ACID and BASE. Q2.Also is no-SQL not better for API versioning improvements?
@lefteriseleftheriades7381
2 жыл бұрын
9:03: NoSQL are bad for analytical processing. I dare to say they are also bad for being queried on anything other than their primary key. They are good for allowing loose structure and keeping their one to many dependencies together.
@navaneethpk3535
2 жыл бұрын
you can index the other fields which your going to query
@pabloqp7929
Жыл бұрын
Thank you for the great video!
@lifeissnowpiece4505
2 жыл бұрын
I am very good understand and your video plz make more videos thanks
@prashanthtalla
2 жыл бұрын
Thank you for the video Priyanka. I was hoping to see if you did any video on RDBMS vs MPP and MPP vs NoSQL DBs. Can you please share? Thank you!
@powerbis.1794
2 жыл бұрын
Such a great explanation!
@lex_dojo
Жыл бұрын
Very informative video.
@вдохновись-ч5э
Жыл бұрын
Thank you for such described videos. Can you please advice, what DB to choose, in case of social media app, like facebook?
@pvergadia
Жыл бұрын
Choose a NoSQL database because you might decide to add fields as the application grows. And you will be able to easily do that in NoSQL database. On Google Cloud I would recommend Firestore.
@вдохновись-ч5э
Жыл бұрын
@@pvergadia I am always see, the answers, that SQL is better. :( I really want to use MongoDB
@вдохновись-ч5э
Жыл бұрын
And also, SQL reading data faster than MongoDB, but MongoDB handle more users at once. I am confused 🤔
@thebluefox100
Жыл бұрын
very nice explanation!
@thiru2605
Жыл бұрын
Mam what'about MySQL and mongodb
@MO-hq4iz
2 жыл бұрын
I do not agree with the scaling and big data argument in the sql vs nosql decision. Working with both for years I can guarantee its not about data sizes nor structure, sine non structured data can't be fetch until structured. It's about how and when the data is structured and scaling is about horizontal vs vertical scaling. Individual databases scales differently, so it's not about sql or not. Oracle databases can scale both ways and handle as large data amounts as any. It's about how you need your data fetched and how large a subset of the total data set you need to search through.
@mdnooruzzaman6832
3 жыл бұрын
Excellent 👌
@powerbis.1794
2 жыл бұрын
Can you make videos on data modelling, please?
@pvergadia
2 жыл бұрын
I will add it to my list, thanks for the topic idea.
@ArpadHorvathSzfvar
2 жыл бұрын
I am curious, whether the things mentioned here for NoSQL databases are true for Graph databases as well. For me it seems a database where the joins are more important and easier than in the SQL. So for me graph databases seems to be on the other side of SQL than the document based once. So is it faster too and can store that large data volume, can use horizontal scaling and can they be just eventually consistent?
@puchesjr07
3 жыл бұрын
I think it’s important to note Firestore offers acid transactions.
@streemsofwater
2 жыл бұрын
Can I use Cloud SQL with Firebase? Or if I use Firebase, am I bound to NoSQL?
@pvergadia
2 жыл бұрын
Great question, you can use Cloud SQL with Firebase if you need a relational database.
@Goody495
2 жыл бұрын
You are great 😊
@JohlBrown
2 жыл бұрын
looks like a great video, might like to add a little rim light behind you on the shadowed side to make your hair pop :) thanks for the content
@pvergadia
2 жыл бұрын
I am constantly improving my setup. Thanks for the advice on the light.
@JohlBrown
2 жыл бұрын
@@pvergadia I can tell! I really enjoyed your video it was super clear and well explained. Wish my uni teachers were half as good... Seems like you're running two front lights, I would turn the shadow side one up just a fraction too. Best of luck!
@TheBavaNeche
2 жыл бұрын
but, the DATA is usually NOT stored on the SAME SERVER....the Tables are stored Separately from the Actual Data Being Stored for Retrieval.....Example: A Letter Form needs Data put in. Hmmm....The Data has already been entered by the Data Input Person in a Document. It was entered by a Word Processor and Saved to a Letter Storage for the Word Processor. Now a person looking for the Data to Send a Letter to Customers but, there is No Data Available at the SQL Program Server -- So the Letters cannot be sent -- UNTIL -- the Location to Said Data has been Entered on a Table Sheet so that Every Person Needing to send that Letter -- or Letters -- has been told where the Data can be found and the Whereabouts of the Form. This description might be too simple....sorry! Is my view correct? Or no. Thank you.
@peterpiper5300
2 жыл бұрын
what Google product is similar to ms access?
@krishnareddyyerram4615
Жыл бұрын
Sql vs no sql vs hybrid use cases?
@jramirezdearellano
Жыл бұрын
From your point of view, are you writing backwards? I enjoyed learning something new.
Пікірлер: 117