Database vs Data Warehouse vs Data Lake | K21Academy

𝐉𝐨𝐢𝐧 𝐭𝐡𝐞 𝐅𝐑𝐄𝐄 𝐂𝐥𝐚𝐬𝐬 𝐨𝐧 𝐌𝐢𝐜𝐫𝐨𝐬𝐨𝐟𝐭 𝐀𝐳𝐮𝐫𝐞 𝐃𝐚𝐭𝐚 𝐄𝐧𝐠𝐢𝐧𝐞𝐞𝐫 𝐂𝐞𝐫𝐭𝐢𝐟𝐢𝐜𝐚𝐭𝐢𝐨𝐧 𝐛𝐲 𝐂𝐥𝐢𝐜𝐤𝐢𝐧𝐠 𝐡𝐞𝐫𝐞 bit.ly/3qIz4sK
📌 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?
𝐀𝐥𝐬𝐨, 𝐝𝐨 𝐧𝐨𝐭 𝐟𝐨𝐫𝐠𝐞𝐭 𝐭𝐨 𝐣𝐨𝐢𝐧 𝐮𝐬 𝐨𝐧 𝐨𝐮𝐫 𝐅𝐑𝐄𝐄 𝐓𝐞𝐥𝐞𝐠𝐫𝐚𝐦 𝐠𝐫𝐨𝐮𝐩 telegram.me/k2..., 𝐚𝐧𝐝 𝐛𝐞 𝐭𝐡𝐞 𝐟𝐢𝐫𝐬𝐭 𝐭𝐨 𝐫𝐞𝐜𝐞𝐢𝐯𝐞 𝐌𝐢𝐜𝐫𝐨𝐬𝐨𝐟𝐭 𝐀𝐳𝐮𝐫𝐞-𝐫𝐞𝐥𝐚𝐭𝐞𝐝 𝐧𝐞𝐰𝐬 𝐚𝐧𝐝 𝐮𝐩𝐝𝐚𝐭𝐞𝐬.
🤔 𝐃𝐨 𝐲𝐨𝐮 𝐡𝐚𝐯𝐞 𝐪𝐮𝐞𝐬𝐭𝐢𝐨𝐧𝐬? 𝐋𝐞𝐭 𝐮𝐬 𝐤𝐧𝐨𝐰 𝐢𝐧 𝐭𝐡𝐞 𝐜𝐨𝐦𝐦𝐞𝐧𝐭 𝐬𝐞𝐜𝐭𝐢𝐨𝐧
#datawarehousevsdatalake #datawarehousevsdatabase #datalakevsdatawarehouse #datalakeanddatawarehouse #databasevsdatalakevsdatawarehouse #whatisdatalake #whatisdatabase #whatisdatawarehouse #database #datawarehouse #datalake #cloudcomputing #k21academy #askatul
Subscribe us and know more about latest Cloud technology: k21academy.com...
---------------------------------------------------------------------------------------------------------------
LET'S CONNECT ON SOCIAL ↴
➽ Facebook: k21academy.com...
➽ Linkedin:k21academy.com...
➽ Twitter: k21academy.com...
➽ Instagram: k21academy.com...
See you next video!

[@K21Academy]

𝐉𝐨𝐢𝐧 𝐭𝐡𝐞 𝐅𝐑𝐄𝐄 𝐂𝐥𝐚𝐬𝐬 𝐨𝐧 𝐌𝐢𝐜𝐫𝐨𝐬𝐨𝐟𝐭 𝐀𝐳𝐮𝐫𝐞 𝐃𝐚𝐭𝐚 𝐄𝐧𝐠𝐢𝐧𝐞𝐞𝐫 𝐂𝐞𝐫𝐭𝐢𝐟𝐢𝐜𝐚𝐭𝐢𝐨𝐧 𝐛𝐲 𝐂𝐥𝐢𝐜𝐤𝐢𝐧𝐠 𝐡𝐞𝐫𝐞 bit.ly/3qIz4sK

[@anshukumari6226]

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

[@K21Academy]

Hey, thanks for watching! Do let us know what videos you'd like to see next?

[@Yesuratnam13]

Thank you so much😊🤝

[@K21Academy]

Glad you liked it!

[@hasanmougharbel8030]

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.

[@K21Academy]

Hi Hasan Mougharbel, Yes, it provides multi-user access. Please check the below link for Reference : learn.microsoft.com/en-us/sql/database-engine/configure-windows/database-engine-instances-sql-server?view=sql-server-ver16 You can also check our Free class bit.ly/3gWuCUa for more Hope this helps. Regards Team K21

[@kristopherrobin4001]

Nice

[@K21Academy]

Thanks