- 216
- 189 288
The Data Channel
India
Приєднався 10 вер 2021
"The Data Channel”, your go-to destination for unraveling the mysteries of the ever-expanding data universe. In an era where information reigns supreme, understanding the intricacies of data and its related technologies is not just a skill but a necessity. Whether you’re a seasoned data enthusiast, a budding analyst, or someone simply curious about the transformative power of information, this blog aims to be your compass in navigating the dynamic world of data.
Join us at “The Datapedia” as we navigate the exciting intersections of data engineering, data science, and the ever-evolving landscape of cloud platforms. From foundational knowledge to advanced techniques, our mission is to make the complexities of these technologies accessible to all. Embark on this data odyssey with us and discover the limitless possibilities within the data spectrum.
Join us at “The Datapedia” as we navigate the exciting intersections of data engineering, data science, and the ever-evolving landscape of cloud platforms. From foundational knowledge to advanced techniques, our mission is to make the complexities of these technologies accessible to all. Embark on this data odyssey with us and discover the limitless possibilities within the data spectrum.
WHAT are SQL Indexes? Pros and Cons of using them | SQL for Data Professionals |Topic #11
Indexing in SQL is a technique used to optimize the performance of queries by allowing the database to find and retrieve data faster. An index is a data structure (often a B-tree or hash table) that improves the speed of data retrieval operations on a table at the cost of additional storage space and slower write operations (INSERT, UPDATE, DELETE).
#learnsql #sqlperformance #SQLIndex #thedatachannel #SQLforDataProfessionals
WEBSITE: thedatapedia.com/
WHATSAPP: chat.whatsapp.com/CbXLGiu2QUoI3DOgl55JSL
FOLLOW US ON:
Twitter: The_DataChannel?s=09
Facebook: The-Data-Channel-110561871369766/
Instagram: the.data.channel
@The Data Channel
About Channel:
This Channel is dedicated for people who want to learn and share their ideas or experience related to data and its related technologies. People who are in learn path about data, it is recommended to follow this channel. We ensure you to deliver quality content by covering the most importance and relevant topics.
If you are in learning path about data and haven't yet subscribed for this channel. Please do LIKE,SHARE and SUBSCRIBE and press bell button for instant notification.
We also recommend Below videos:
1. Azure Data Factory Series:
ua-cam.com/play/PLubLCwMyFlZT1yrtfUjmPu9UZyn806IiK.html
2. Data Engineering with Azure Series:
ua-cam.com/play/PLubLCwMyFlZRHB8UUqRCgo7PhSQBWfjrR.html
3. Azure CosmoDB Series:
ua-cam.com/play/PLubLCwMyFlZQIdJMMTfMZXhlWsOC6OFOM.html
4. Basic Of Understanding Data and its related Technologies
ua-cam.com/play/PLubLCwMyFlZR3tbqqPDk4pkGTov8n6wnv.html
5.Data Design and Architectural Concepts
ua-cam.com/play/PLubLCwMyFlZTn2TK43doZ_SzpF_WNyYOUe.html statements like Create, Alter, Drop, Rename, Truncate are explained in this video
#SQLDDL #DataDefinitionLanguage #thedatachannel #SQLforDataProfessionals
WEBSITE: thedatapedia.com/
WHATSAPP: chat.whatsapp.com/CbXLGiu2QUoI3DOgl55JSL
FOLLOW US ON:
Twitter: The_DataChannel?s=09
Facebook: The-Data-Channel-110561871369766/
Instagram: the.data.channel
@The Data Channel
About Channel:
This Channel is dedicated for people who want to learn and share their ideas or experience related to data and its related technologies. People who are in learn path about data, it is recommended to follow this channel. We ensure you to deliver quality content by covering the most importance and relevant topics.
If you are in learning path about data and haven't yet subscribed for this channel. Please do LIKE,SHARE and SUBSCRIBE and press bell button for instant notification.
We also recommend Below videos:
1. Azure Data Factory Series:
ua-cam.com/play/PLubLCwMyFlZT1yrtfUjmPu9UZyn806IiK.html
2. Data Engineering with Azure Series:
ua-cam.com/play/PLubLCwMyFlZRHB8UUqRCgo7PhSQBWfjrR.html
3. Azure CosmoDB Series:
ua-cam.com/play/PLubLCwMyFlZQIdJMMTfMZXhlWsOC6OFOM.html
4. Basic Of Understanding Data and its related Technologies
ua-cam.com/play/PLubLCwMyFlZR3tbqqPDk4pkGTov8n6wnv.html
5.Data Design and Architectural Concepts
ua-cam.com/play/PLubLCwMyFlZTn2TK43doZ_SzpF_WNyYOU.html
#learnsql #sqlperformance #SQLIndex #thedatachannel #SQLforDataProfessionals
WEBSITE: thedatapedia.com/
WHATSAPP: chat.whatsapp.com/CbXLGiu2QUoI3DOgl55JSL
FOLLOW US ON:
Twitter: The_DataChannel?s=09
Facebook: The-Data-Channel-110561871369766/
Instagram: the.data.channel
@The Data Channel
About Channel:
This Channel is dedicated for people who want to learn and share their ideas or experience related to data and its related technologies. People who are in learn path about data, it is recommended to follow this channel. We ensure you to deliver quality content by covering the most importance and relevant topics.
If you are in learning path about data and haven't yet subscribed for this channel. Please do LIKE,SHARE and SUBSCRIBE and press bell button for instant notification.
We also recommend Below videos:
1. Azure Data Factory Series:
ua-cam.com/play/PLubLCwMyFlZT1yrtfUjmPu9UZyn806IiK.html
2. Data Engineering with Azure Series:
ua-cam.com/play/PLubLCwMyFlZRHB8UUqRCgo7PhSQBWfjrR.html
3. Azure CosmoDB Series:
ua-cam.com/play/PLubLCwMyFlZQIdJMMTfMZXhlWsOC6OFOM.html
4. Basic Of Understanding Data and its related Technologies
ua-cam.com/play/PLubLCwMyFlZR3tbqqPDk4pkGTov8n6wnv.html
5.Data Design and Architectural Concepts
ua-cam.com/play/PLubLCwMyFlZTn2TK43doZ_SzpF_WNyYOUe.html statements like Create, Alter, Drop, Rename, Truncate are explained in this video
#SQLDDL #DataDefinitionLanguage #thedatachannel #SQLforDataProfessionals
WEBSITE: thedatapedia.com/
WHATSAPP: chat.whatsapp.com/CbXLGiu2QUoI3DOgl55JSL
FOLLOW US ON:
Twitter: The_DataChannel?s=09
Facebook: The-Data-Channel-110561871369766/
Instagram: the.data.channel
@The Data Channel
About Channel:
This Channel is dedicated for people who want to learn and share their ideas or experience related to data and its related technologies. People who are in learn path about data, it is recommended to follow this channel. We ensure you to deliver quality content by covering the most importance and relevant topics.
If you are in learning path about data and haven't yet subscribed for this channel. Please do LIKE,SHARE and SUBSCRIBE and press bell button for instant notification.
We also recommend Below videos:
1. Azure Data Factory Series:
ua-cam.com/play/PLubLCwMyFlZT1yrtfUjmPu9UZyn806IiK.html
2. Data Engineering with Azure Series:
ua-cam.com/play/PLubLCwMyFlZRHB8UUqRCgo7PhSQBWfjrR.html
3. Azure CosmoDB Series:
ua-cam.com/play/PLubLCwMyFlZQIdJMMTfMZXhlWsOC6OFOM.html
4. Basic Of Understanding Data and its related Technologies
ua-cam.com/play/PLubLCwMyFlZR3tbqqPDk4pkGTov8n6wnv.html
5.Data Design and Architectural Concepts
ua-cam.com/play/PLubLCwMyFlZTn2TK43doZ_SzpF_WNyYOU.html
Переглядів: 21
Відео
Disassemble Python bytecode into a human-readable form | Topic #24
Переглядів 3521 день тому
#pythonbytecode #pythonDis #PythonDisassemble #thedatachannel Python Installation: ua-cam.com/video/zBgIAjzfvAo/v-deo.html IDEs Installation Steps: VS Code Installation: ua-cam.com/video/_FQRJifGxBQ/v-deo.html Jupyter Notebook Installation: ua-cam.com/video/Nf-47V3LLzs/v-deo.html PyCharm Installation: ua-cam.com/video/aM7T3l7O3Hk/v-deo.html Spyder Installation: ua-cam.com/video/tcGAyByawYs/v-de...
SQL-SUB-QUERIES vs JOINS | SQL for Data Professionals |Topic #10
Переглядів 5921 день тому
SQL subqueries and joins are two different ways to retrieve data from multiple tables, and each has its advantages based on the use case #learnsql #sqljoins #SQLSubqueries #thedatachannel #SQLforDataProfessionals WEBSITE: thedatapedia.com/ WHATSAPP: chat.whatsapp.com/CbXLGiu2QUoI3DOgl55JSL FOLLOW US ON: Twitter: The_DataChannel?s=09 Facebook: The-Data-Channel-1105618713...
SQL window function in detail with examples| ROW_NUM(),RANK(), DENSE_RANK(),ROLLING SUM()|Topic #9
Переглядів 8328 днів тому
SQL window functions allow you to perform calculations across a set of table rows that are related to the current row without collapsing them into a single result. These functions are great for tasks like ranking, running totals, moving averages, and cumulative statistics. A window function computes its result based on a "window" of rows, defined by the OVER clause. #learnsql #sqlWindowFunction...
SQL Complex Aggregate Function with examples | SQL for Data Professionals | Topic #8
Переглядів 4728 днів тому
SQL Aggregate functions are used along with Group by Having however we can solve complex business problems using these complex Aggregate function, explained in this video in detail #learnsql #sqlgroupby #thedatachannel #SQLforDataProfessionals WEBSITE: thedatapedia.com/ WHATSAPP: chat.whatsapp.com/CbXLGiu2QUoI3DOgl55JSL FOLLOW US ON: Twitter: The_DataChannel?s=09 Facebook: facebook....
SQL Keys and their Purpose with Examples | SQL for Data Professionals | Topic #7
Переглядів 3228 днів тому
Often wondered what is different types of Keys in SQL and what is the purpose of each, explained in this video in detail #learnsql #SQLKeys #thedatachannel #SQLforDataProfessionals WEBSITE: thedatapedia.com/ WHATSAPP: chat.whatsapp.com/CbXLGiu2QUoI3DOgl55JSL FOLLOW US ON: Twitter: The_DataChannel?s=09 Facebook: The-Data-Channel-110561871369766/ Instagram: the.data.chann...
Python List Comprehension In great detail with examples | Topic #23
Переглядів 22Місяць тому
#pythonlistComprehension #pythonlists #pythonlist #thedatachannel Python Installation: ua-cam.com/video/zBgIAjzfvAo/v-deo.html IDEs Installation Steps: VS Code Installation: ua-cam.com/video/_FQRJifGxBQ/v-deo.html Jupyter Notebook Installation: ua-cam.com/video/Nf-47V3LLzs/v-deo.html PyCharm Installation: ua-cam.com/video/aM7T3l7O3Hk/v-deo.html Spyder Installation: ua-cam.com/video/tcGAyByawYs/...
Lists vs Sets vs Dictionary vs Tuple: Performance Comparison and Analysis | Topic #22
Переглядів 40Місяць тому
#pythondictionary #pythonsets #pythonlist #thedatachannel Python Installation: ua-cam.com/video/zBgIAjzfvAo/v-deo.html IDEs Installation Steps: VS Code Installation: ua-cam.com/video/_FQRJifGxBQ/v-deo.html Jupyter Notebook Installation: ua-cam.com/video/Nf-47V3LLzs/v-deo.html PyCharm Installation: ua-cam.com/video/aM7T3l7O3Hk/v-deo.html Spyder Installation: ua-cam.com/video/tcGAyByawYs/v-deo.ht...
COUNT(*) vs COUNT(1) in SQL | SQL for Data Professionals | Topic #6
Переглядів 262Місяць тому
Often wondered what is difference between Count(1) and Count(1) explained in this video in detail #learnsql #SQLCount #thedatachannel #SQLforDataProfessionals WEBSITE: thedatapedia.com/ WHATSAPP: chat.whatsapp.com/CbXLGiu2QUoI3DOgl55JSL FOLLOW US ON: Twitter: The_DataChannel?s=09 Facebook: The-Data-Channel-110561871369766/ Instagram: the.data.channel @The Data Channel A...
SQL Group By and Having| SQL for Data Professionals | Topic #5
Переглядів 40Місяць тому
SQL Group by Clause and Having Clause are explained in this video in detail #learnsql #SQLGroupBy #thedatachannel #SQLforDataProfessionals WEBSITE: thedatapedia.com/ WHATSAPP: chat.whatsapp.com/CbXLGiu2QUoI3DOgl55JSL FOLLOW US ON: Twitter: The_DataChannel?s=09 Facebook: The-Data-Channel-110561871369766/ Instagram: the.data.channel @The Data Channel About Channel: This C...
SQL Joins- Simplified|INNER JOIN, LEFT JOIN, RIGHT JOIN, OUTER JOIN, CROSS JOIN,SELF JOIN | Topic #4
Переглядів 68Місяць тому
SQL Joins like INNER JOIN, LEFT JOIN, RIGHT JOIN, OUTER JOIN, CROSS JOIN,SELF JOIN are explained in this video #SQLDDL #DataControlLanguage #thedatachannel #SQLforDataProfessionals WEBSITE: thedatapedia.com/ WHATSAPP: chat.whatsapp.com/CbXLGiu2QUoI3DOgl55JSL FOLLOW US ON: Twitter: The_DataChannel?s=09 Facebook: The-Data-Channel-110561871369766/ Instagram: the.data.chann...
DCL(Data Control Language) | SQL for Data Professionals | Topic #3
Переглядів 22Місяць тому
DCL (Data Control Language) like Grant and Revoke are explained in this video #SQLDDL #DataControlLanguage #thedatachannel #SQLforDataProfessionals WEBSITE: thedatapedia.com/ WHATSAPP: chat.whatsapp.com/CbXLGiu2QUoI3DOgl55JSL FOLLOW US ON: Twitter: The_DataChannel?s=09 Facebook: The-Data-Channel-110561871369766/ Instagram: the.data.channel @The Data Channel About Channe...
DML(Data Manipulation Language) | SQL for Data Professionals | Topic #2
Переглядів 23Місяць тому
DML(Data Manipulation Language) like Insert, Update, Delete are explained in this video #SQLDDL #DataManipulationLanguage #thedatachannel #SQLforDataProfessionals WEBSITE: thedatapedia.com/ WHATSAPP: chat.whatsapp.com/CbXLGiu2QUoI3DOgl55JSL FOLLOW US ON: Twitter: The_DataChannel?s=09 Facebook: The-Data-Channel-110561871369766/ Instagram: the.data.channel @The Data Chann...
Lists vs Sets vs Dictionary vs Tuple- with Real time Use Cases | Topic #21
Переглядів 81Місяць тому
#pythondictionary #pythonsets #pythonlist #thedatachannel Python Installation: ua-cam.com/video/zBgIAjzfvAo/v-deo.html IDEs Installation Steps: VS Code Installation: ua-cam.com/video/_FQRJifGxBQ/v-deo.html Jupyter Notebook Installation: ua-cam.com/video/Nf-47V3LLzs/v-deo.html PyCharm Installation: ua-cam.com/video/aM7T3l7O3Hk/v-deo.html Spyder Installation: ua-cam.com/video/tcGAyByawYs/v-deo.ht...
DDL(Data Definition Language) | SQL for Data Professionals | Topic #1
Переглядів 61Місяць тому
DDL(Data Definition Language statements like Create, Alter, Drop, Rename, Truncate are explained in this video #SQLDDL #DataDefinitionLanguage #thedatachannel #SQLforDataProfessionals WEBSITE: thedatapedia.com/ WHATSAPP: chat.whatsapp.com/CbXLGiu2QUoI3DOgl55JSL FOLLOW US ON: Twitter: The_DataChannel?s=09 Facebook: The-Data-Channel-110561871369766/ Instagram: the.data.ch...
SQL for Data Professionals: Introduction | Topic 0
Переглядів 53Місяць тому
SQL for Data Professionals: Introduction | Topic 0
Python SETS in Action - with Real time Use Cases | Topic #20
Переглядів 62Місяць тому
Python SETS in Action - with Real time Use Cases | Topic #20
Python TUPLES in Action - with Real time Use Cases | Topic #19
Переглядів 53Місяць тому
Python TUPLES in Action - with Real time Use Cases | Topic #19
Python Dictionary in Action - with Real time Use Cases | Topic #18
Переглядів 492 місяці тому
Python Dictionary in Action - with Real time Use Cases | Topic #18
Categorical data encoding using CHATGPT- (PART II) | Topic 5
Переглядів 462 місяці тому
Categorical data encoding using CHATGPT- (PART II) | Topic 5
Python LIST in Action - with Real time Use Cases | Topic #17
Переглядів 592 місяці тому
Python LIST in Action - with Real time Use Cases | Topic #17
Python STRING Data Type In Details:Slicing, String methods, Formatting, Escape Characters| Topic #16
Переглядів 402 місяці тому
Python STRING Data Type In Details:Slicing, String methods, Formatting, Escape Characters| Topic #16
Categorical data encoding using CHATGPT- (PART I) | Topic 4
Переглядів 472 місяці тому
Categorical data encoding using CHATGPT- (PART I) | Topic 4
Python Data Types- Numbers, Strings, Lists, Dictionary, Tuple, Sets, Boolean | Topic #15
Переглядів 302 місяці тому
Python Data Types- Numbers, Strings, Lists, Dictionary, Tuple, Sets, Boolean | Topic #15
Conditionals and Loops in Python and Importance of them in Data Processing and analysis | Topic #25
Переглядів 933 місяці тому
Conditionals and Loops in Python and Importance of them in Data Processing and analysis | Topic #25
Practice Python without any Installation using Online Platforms for FREE | Topic #14
Переглядів 613 місяці тому
Practice Python without any Installation using Online Platforms for FREE | Topic #14
Install Sublime Text Editor for Python | Python for Data Professionals | Topic #13
Переглядів 603 місяці тому
Install Sublime Text Editor for Python | Python for Data Professionals | Topic #13
Data Preparation and Cleaning using CHAT GPT | Topic 3
Переглядів 843 місяці тому
Data Preparation and Cleaning using CHAT GPT | Topic 3
Which Python IDE is Best for you? VS Code vs Jupyter vs PyCharm vs Spyder | Topic #12
Переглядів 4073 місяці тому
Which Python IDE is Best for you? VS Code vs Jupyter vs PyCharm vs Spyder | Topic #12
Prompt Engineering and its Key Features | Topic 2
Переглядів 573 місяці тому
Prompt Engineering and its Key Features | Topic 2
great
Watching all your videos is enough for the exam to pass. Or is there any other free materials to look on ?
Hey have sent an email requesting for notes and supporting files. Please check
Thank you reaching, have replied to your mail with details please check
Thank you, i have sent you a mail for notebook and data
Thank you reaching, have replied to your mail with details please check
Have mailed for the files. Thanks
Thank you reaching, have replied to your mail with details please check
Hi! i mailed for the Notebooks and the data. Kindly send. Thanks for all your efforts
Thank you reaching, have replied to your mail with details please check
Where is the lady
❤❤
Thank you for the support Happy Learning
Saying same thing multiple times using different words/sentence 2 vdo could have completed within 10 min only
Thank you sharing your feedback. Please note the videos will be made based on consideration that there will be viewers both from beginner and expert level, so we need keep phase for both. Hope you understand Thank you again for your feedback, it’s valuable Happy learning
I am follower of your channel, all videos are clears fundamental concepts, appreciate your patience and please keep up good work .Thank you.
Thank you for your support Happy Learning
I am follower of your channel, all videos are clears fundamental concepts, appreciate your patience and please keep up good work .Thank you.
Thank you for your support Happy Learning
I am follower of your channel, all videos are clears fundamental concepts, appreciate your patience and please keep up good work .Thank you.
Thank you for your support Happy Learning
I am follower of your channel, all videos are clears fundamental concepts, appreciate your patience and please keep up good work.Thank you..
Thank you for your support Happy Learning
I am follower of your channel, all videos are clears fundamental concepts, appreciate your patience and please keep up good work.Thank you..
Thank you for your support Happy Learning
I am follower of your channel, all videos are clears fundamental concepts, appreciate your patience and please keep up good work.Thank you..
Thank you for your support Happy Learning
Nice Ha
Thank for your support. Please Subscribe Happy Learning
Can you please send the notebook and data? Set an email from - ashikrpk
Good Python Teaching sir....
Thank you for the support Happy Learning 😇
Good Python Teaching sir....
Thank you Happy Learning 😊
Good Python Teaching sir....
Thank you for the support Happy Learning 😊
Good Python Teaching sir....
Thank you for the support Happy Learning😊
Thanks, I have sent you an email for the request of tutorial material files.
Hi Thank you for Subscribing, Have replied to your mail with all the required details Regards, The Data Channel
Thanks, i have sent you a mail for notebook.
Hi Thank you for Subscribing, Have replied to your mail with all the required details Regards, The Data Channel
Very good content... request you to please share me the .dbc file...have mailed you to share the same.
@thedatachannel878 I have mailed you 2 days ago.. request you to please share the practice Notebooks
Hi Thank you for Subscribing, Have replied to your mail with all the required details Regards, The Data Channel
Hi Thank you for Subscribing, Have replied to your mail with all the required details Regards, The Data Channel
Hi @thedatachannel, I need the practice notebook pls..i have sent you the mail also..thanks
Hi Thank you for Subscribing, Have replied to your mail with all the required details Regards, The Data Channel
Hi sir, I have sent the mail for notes, can you please provide the notes. It will be helpful. And Thank You for the detailed playlist
Hi Thank you for Subscribing, Have replied to your mail with all the required details Regards, The Data Channel
Thanks for tutorial ... I have send mail for Notebooks
Hi Thank you for Subscribing, Have replied to your mail with all the required details Regards, The Data Channel
I didnt understand the free taril and i am creating databrick acc using microsoft azure but it ask something
Hii, i sent u an email for the dbc file !
Hi Thank you for Subscribing, Have replied to your mail with all the required details Regards, The Data Channel
what's the difference b/w both of this?
Difference between Anaconda and Jupyter notebook?
Seems, Topic 5 is missing..
Thank you bringing this up, Sure will add it
Great Job!! Sent an email for practice notes.
Sent to your mail ID Thank you
Very useful videos, Thanks for knowledge share.
Thank you for your support Happy learning 😇
hi day 2 for requesting all files related to this playlist and even i have mailed you .please help
Apologies for delay, I have shared now, please check your mail
Please send spark associate developer playlist dbf files i have send u email request still not response
You mail id?
please upload video 5
Thank you bringing this up, Sure will add it
Thank you bringing this up, Sure will add it
hi thanks for the course i have emailed to requesting for dbc file thanks
Sent to your mail, please check, Thank you
Sir! Where is the autoloader video. I cannot find it in this playlist! Please upload it.Thanks!🙂
Thank you bringing this up, Sure will add it
Hi hope you’re doing great 👍 ! After learning basics n understanding ( types of data, 6vs of data, etl vs elt, db vs dw vs dm vs dl, full vs incremental load, fact vs dimensions, dw schemas, scd type n storage layer types, oltp vs olap) in one day , i have moved to databricks instead of data analysis as i want to become data engineer so today i have started this playlist n done with below topics ( 1- data bricks -- simple open source and single seloid teck stack ( all stack under 1 unberla ) lakehouse Data lake + dw = lakehouse (delta lake ) as delta lake is heart of lake house n lakehouse is build on top of delta lake (Topic-2 free trail - 2 ways aws n direct db website register ( need credit card 14 days trail n set termination 120 or 15 minutes as if u unchecked it will consume storage ) 1- trail version single node ( default driver node ) Multi node has worker + driver Topic-3 ( db architecture n services) ( control plane n data plane Control plane :: db cloud admin control Data plane : customer cloud ( aws azure gcp ) all exution transformation compute memory storage physically present here ) High level cluster : 1- general purpose interactive n job cluster Topic-3 db workspace Db page overview ( left side personas ( ml de n sql will b available in premium version) rest create workspace repos compute data workflow will b same in all 3 pasonas ( ds ml sql ) -- right side top ( user settings , admin consle , logout many more ) Topic -4 create n manage clusters Workspace create or compute create new ( single node -) When u click on created cluster u will have many options logs alerts metrics many more where we can mintor all Topic-5 db notebooks 1- create new notebook name n select lang u want 2- execute cell print (“hello”) 3- magic command %sql %python to change language of note book 4- md 5- %run “path” of child notebook or second notebook 6- %run “./notbookname” for exiting folder 7- dbutilies.help 8- display dbutlies.fs.help to display in tabular format Topic-6 git version n repos Create account in git hub settings developer mode acess token create copy then go to db settings add token repos n configure then create a child branch n to avoid conflict ( first always pull latest version n then push) Topic -7 taking brake may b evening i will practice Thanks 😊 once again !!
Amazed by your dedication, it is really inspiring. Thank you for your learning journey updates
Learn in one day all below topics n return what i learn thanks now starting this playlist Topic -1 Types of data 1- structured ( oltp transactional online banking booking erp ) relation between tables Eg : oracle sql server ibm db2 vertica 2-semi structured- json xml format Dw / data bricks / delta or data lake ( iot sensor data ) 3- unstructured ( images videos ) ( dw / delta lake ) N for statistics data ( Topic -2 6 vs of data 1- volume (gb tb peta bytes) 2- variety (semi structured unstructured) 3- velocity-( 4- value ( analysis dashboard) 5- veracity ( redundancy scalability) 6- variability( change in variable) Topic -3 etl vs elt Etl : extract transform load- specific use case Elt : extract load n transform- many use case Topic -4 Db - rdbms oltp ( relationship primary n foreign key) Dw - storage ( dw / db) fact n dimensional ) Dm - subset of dw for fast recent revision history Dl- large storage Topic -5 full vs incremental load Full: replace full load in target system ( useful when less volume n frequency is often Incremental load : first time full load n from next load it only takes updates or modified record( volume is high n modifications) Topic-6 fact vs dimensions Fact: Measures Transitional Dimensions: Not change statics Dim tables Topic-7 scd Scd -0 to 6(5) Scd -0 fixed dimensions Scd-1 no history Scd -2 Scd -3 Scd -4 Scd -6(5) Topic -8 dw schemas 1- star - straight forward centralised fact n many dim tables but dim tables will not have relation with other dim tables 2- snow flake - Complex query performance low One fact table have many dim tables n each dim tables have relation b/w them know as child tables 3- galaxy star schema
Appreciate your efforts on compiling all this topics. Which would eventually help many learner’s Thank you, happy Learning
@@thedatachannel878 thanks for making’s such clear content video I request you to make video on real time projects for azure data engineering with step by step notes 📝 n data sets which can easily downloaded n use for practice thanks 😊
@neuera9556 Noted Thank you for your genuine feedback
I saw thinking due to storage outage
is this sufficient to pass databricks certification and also pls share practice notebook hv shared a mail
We covered almost all the topics as part of certification. But to attend to certification exam, suggest you to please take exam dumps and understand the pattern of questions
Thanks for the tutorial ...Have mailed for the notebooks and course content. Please share.
Have shared details of practice notebooks in mail. Thank you
Thank you for making the course. Can I ask for the notebooks and data?
Hi thank you responding. Request you to please send mail request to yt.the.data.channel@gmail.com and we will send required materials for practice
Request mail for the .dbc file to practice was sent to your mail, could you please send that file for my mail. Thanks
Hi, have shared the practice notebook details to your mail id. Thank you
Hi - i wana become data engineer can u suggest ur playlist in alphabetical order
Hi i want to learn data engineering n get job as experience data engineer can you suggest playlist in alphabetical order for de and ru data engineering if yes can i know ur LinkedIn? Thanks 😊
thedatapedia.com/2024/01/04/azure-data-engineering-comprehensive-learning-guide/
Refer to this link, where there is complete curated list in order and plan to learn. Hope it helps
Content is good, but the background music is really annoying. Please don't use it in your lectures.
Thank you for you valuable feedback . We have already considered and all our latest videos are without background noise Happy learning
Hello i send you a mail for content notebook
Hi, have replied you with required practice materials Thank you
Hello, thanks for tutorial ! i send you a mail for notebook.
Hi, have shared the practice notebook details to your mail id. Thank you