Database vs Data Warehouse vs Data Lake | K21Academy

preview_player
ะŸะพะบะฐะทะฐั‚ัŒ ะพะฟะธัะฐะฝะธะต

๐Ÿ“Œ In the past ten years, we have seen substantial ๐Ÿ“ˆ growth in data. We can say data is the new oil; According to a ๐Ÿ“ƒ survey, there will be a ๐Ÿš€ the rise of 27.9% in ๐——๐—ฎ๐˜๐—ฎ ๐—ฆ๐—ฐ๐—ถ๐—ฒ๐—ป๐—ฐ๐—ฒ job opportunities by 2026.

๐Ÿ“Œ Currently, 20% is structured data that we can store in ๐Ÿ“‘ rows and columns, but 80% of data is non-relational, with no SQL or unstructured.

๐Ÿ“Œ There are three forms of storage we have:
โžฅ ๐ƒ๐š๐ญ๐š๐›๐š๐ฌ๐ž: An organized collection of structured information that is stored in the form of rows and columns.
โžฅ ๐ƒ๐š๐ญ๐š ๐–๐š๐ซ๐ž๐ก๐จ๐ฎ๐ฌ๐ž: It is a special type of database through which we can create meaningful insights and analytics to get desired outcomes
โžฅ ๐ƒ๐š๐ญ๐š ๐‹๐š๐ค๐ž: It's storage where we can store anything like tables, images and any files.

๐Ÿค” ๐–๐š๐ง๐ญ ๐ญ๐จ ๐ค๐ง๐จ๐ฐ ๐ฆ๐จ๐ซ๐ž ๐š๐›๐จ๐ฎ๐ญ ๐ญ๐ก๐ž ๐๐ข๐Ÿ๐Ÿ๐ž๐ซ๐ž๐ง๐œ๐ž ๐›๐ž๐ญ๐ฐ๐ž๐ž๐ง ๐ƒ๐š๐ญ๐š๐›๐š๐ฌ๐ž๐ฌ, ๐ƒ๐š๐ญ๐š ๐–๐š๐ซ๐ž๐ก๐จ๐ฎ๐ฌ๐ž๐ฌ ๐š๐ง๐ ๐ƒ๐š๐ญ๐š ๐‹๐š๐ค๐ž๐ฌ?
๐–๐š๐ญ๐œ๐ก ๐ญ๐ก๐ž ๐š๐›๐จ๐ฏ๐ž ๐ฏ๐ข๐๐ž๐จ ๐ง๐จ๐ฐ ๐Ÿš€

๐–๐ก๐ž๐ซ๐ž ๐ก๐ž ๐ž๐ฑ๐ฉ๐ฅ๐š๐ข๐ง๐ฌ:
00:00 = Introduction
00:27 = Agenda
00:57 = Introduction and Types of Data
02:17 = What is Database, Data Warehouse and Data Lake?
05:14 = Examples of DB, DWH and DL
05:45 = How to Access Data in DB, DWH and DL?
06:15 = Learning Path for Microsoft Azure Data Engineer Certification [DP-203]
07:19 = FREE CLASS on DP-203
07:53 = Registration Link for FREE CLASS
08:01 = How to Register for FREE CLASS?

๐Ÿค” ๐ƒ๐จ ๐ฒ๐จ๐ฎ ๐ก๐š๐ฏ๐ž ๐ช๐ฎ๐ž๐ฌ๐ญ๐ข๐จ๐ง๐ฌ? ๐‹๐ž๐ญ ๐ฎ๐ฌ ๐ค๐ง๐จ๐ฐ ๐ข๐ง ๐ญ๐ก๐ž ๐œ๐จ๐ฆ๐ฆ๐ž๐ง๐ญ ๐ฌ๐ž๐œ๐ญ๐ข๐จ๐ง

#datawarehousevsdatalake #datawarehousevsdatabase #datalakevsdatawarehouse #datalakeanddatawarehouse #databasevsdatalakevsdatawarehouse #whatisdatalake #whatisdatabase #whatisdatawarehouse #database #datawarehouse #datalake #cloudcomputing #k21academy #askatul

---------------------------------------------------------------------------------------------------------------
LET'S CONNECT ON SOCIAL โ†ด

See you next video!
ะ ะตะบะพะผะตะฝะดะฐั†ะธะธ ะฟะพ ั‚ะตะผะต
ะšะพะผะผะตะฝั‚ะฐั€ะธะธ
ะะฒั‚ะพั€

Explained very nicely, I visually imagined all the points you covered.

anshukumari
ะะฒั‚ะพั€

Hello there, god bless your efforts.
I have a general enquiry as an sql newbie.
Does sql server provides multi user access to support many storage engines?
Thanks for taking care of this.

hasanmougharbel