The Data Channel
The Data Channel
  • 216
  • 189 288
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
Переглядів: 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

КОМЕНТАРІ

  • @KRISHNABADE-p7j
    @KRISHNABADE-p7j 4 дні тому

    great

  • @rj00502
    @rj00502 15 днів тому

    Watching all your videos is enough for the exam to pass. Or is there any other free materials to look on ?

  • @vvsbharadwaj9278
    @vvsbharadwaj9278 23 дні тому

    Hey have sent an email requesting for notes and supporting files. Please check

    • @thedatachannel878
      @thedatachannel878 23 дні тому

      Thank you reaching, have replied to your mail with details please check

  • @seblouchem
    @seblouchem 24 дні тому

    Thank you, i have sent you a mail for notebook and data

    • @thedatachannel878
      @thedatachannel878 23 дні тому

      Thank you reaching, have replied to your mail with details please check

  • @vvsbharadwaj9278
    @vvsbharadwaj9278 25 днів тому

    Have mailed for the files. Thanks

    • @thedatachannel878
      @thedatachannel878 23 дні тому

      Thank you reaching, have replied to your mail with details please check

  • @tomiad2773
    @tomiad2773 25 днів тому

    Hi! i mailed for the Notebooks and the data. Kindly send. Thanks for all your efforts

    • @thedatachannel878
      @thedatachannel878 23 дні тому

      Thank you reaching, have replied to your mail with details please check

  • @saeedwiz
    @saeedwiz 28 днів тому

    Where is the lady

  • @sushantkarad6413
    @sushantkarad6413 Місяць тому

    ❤❤

  • @AbdullaMadina672
    @AbdullaMadina672 Місяць тому

    Saying same thing multiple times using different words/sentence 2 vdo could have completed within 10 min only

    • @thedatachannel878
      @thedatachannel878 Місяць тому

      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

  • @sanjanahb1208
    @sanjanahb1208 Місяць тому

    I am follower of your channel, all videos are clears fundamental concepts, appreciate your patience and please keep up good work .Thank you.

  • @sanjanahb1208
    @sanjanahb1208 Місяць тому

    I am follower of your channel, all videos are clears fundamental concepts, appreciate your patience and please keep up good work .Thank you.

  • @sanjanahb1208
    @sanjanahb1208 Місяць тому

    I am follower of your channel, all videos are clears fundamental concepts, appreciate your patience and please keep up good work .Thank you.

  • @sanjanahb1208
    @sanjanahb1208 Місяць тому

    I am follower of your channel, all videos are clears fundamental concepts, appreciate your patience and please keep up good work.Thank you..

  • @sanjanahb1208
    @sanjanahb1208 Місяць тому

    I am follower of your channel, all videos are clears fundamental concepts, appreciate your patience and please keep up good work.Thank you..

  • @sanjanahb1208
    @sanjanahb1208 Місяць тому

    I am follower of your channel, all videos are clears fundamental concepts, appreciate your patience and please keep up good work.Thank you..

  • @himan8680
    @himan8680 Місяць тому

    Nice Ha

    • @thedatachannel878
      @thedatachannel878 Місяць тому

      Thank for your support. Please Subscribe Happy Learning

  • @itzashik
    @itzashik Місяць тому

    Can you please send the notebook and data? Set an email from - ashikrpk

  • @prajakeeya-karnatakasdemoc9186
    @prajakeeya-karnatakasdemoc9186 Місяць тому

    Good Python Teaching sir....

  • @prajakeeya-karnatakasdemoc9186
    @prajakeeya-karnatakasdemoc9186 Місяць тому

    Good Python Teaching sir....

  • @prajakeeya-karnatakasdemoc9186
    @prajakeeya-karnatakasdemoc9186 Місяць тому

    Good Python Teaching sir....

  • @prajakeeya-karnatakasdemoc9186
    @prajakeeya-karnatakasdemoc9186 Місяць тому

    Good Python Teaching sir....

  • @wah866sky7
    @wah866sky7 Місяць тому

    Thanks, I have sent you an email for the request of tutorial material files.

    • @thedatachannel878
      @thedatachannel878 Місяць тому

      Hi Thank you for Subscribing, Have replied to your mail with all the required details Regards, The Data Channel

  • @wah866sky7
    @wah866sky7 Місяць тому

    Thanks, i have sent you a mail for notebook.

    • @thedatachannel878
      @thedatachannel878 Місяць тому

      Hi Thank you for Subscribing, Have replied to your mail with all the required details Regards, The Data Channel

  • @rajsambhare1314
    @rajsambhare1314 Місяць тому

    Very good content... request you to please share me the .dbc file...have mailed you to share the same.

    • @rajsambhare1314
      @rajsambhare1314 Місяць тому

      @thedatachannel878 I have mailed you 2 days ago.. request you to please share the practice Notebooks

    • @thedatachannel878
      @thedatachannel878 Місяць тому

      Hi Thank you for Subscribing, Have replied to your mail with all the required details Regards, The Data Channel

    • @thedatachannel878
      @thedatachannel878 Місяць тому

      Hi Thank you for Subscribing, Have replied to your mail with all the required details Regards, The Data Channel

  • @rajsambhare1314
    @rajsambhare1314 Місяць тому

    Hi @thedatachannel, I need the practice notebook pls..i have sent you the mail also..thanks

    • @thedatachannel878
      @thedatachannel878 Місяць тому

      Hi Thank you for Subscribing, Have replied to your mail with all the required details Regards, The Data Channel

  • @fcreations8130
    @fcreations8130 Місяць тому

    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

    • @thedatachannel878
      @thedatachannel878 Місяць тому

      Hi Thank you for Subscribing, Have replied to your mail with all the required details Regards, The Data Channel

  • @XkefasX
    @XkefasX Місяць тому

    Thanks for tutorial ... I have send mail for Notebooks

    • @thedatachannel878
      @thedatachannel878 Місяць тому

      Hi Thank you for Subscribing, Have replied to your mail with all the required details Regards, The Data Channel

  • @pavanicowdary8395
    @pavanicowdary8395 Місяць тому

    I didnt understand the free taril and i am creating databrick acc using microsoft azure but it ask something

  • @oumaymabenyahya6066
    @oumaymabenyahya6066 Місяць тому

    Hii, i sent u an email for the dbc file !

    • @thedatachannel878
      @thedatachannel878 Місяць тому

      Hi Thank you for Subscribing, Have replied to your mail with all the required details Regards, The Data Channel

  • @nanivo9804
    @nanivo9804 Місяць тому

    what's the difference b/w both of this?

    • @thedatachannel878
      @thedatachannel878 Місяць тому

      Difference between Anaconda and Jupyter notebook?

  • @SRINIVASAREDDY-h2f
    @SRINIVASAREDDY-h2f 2 місяці тому

    Seems, Topic 5 is missing..

  • @SRINIVASAREDDY-h2f
    @SRINIVASAREDDY-h2f 2 місяці тому

    Great Job!! Sent an email for practice notes.

  • @SRINIVASAREDDY-h2f
    @SRINIVASAREDDY-h2f 2 місяці тому

    Very useful videos, Thanks for knowledge share.

  • @mohammedak-m8k
    @mohammedak-m8k 2 місяці тому

    hi day 2 for requesting all files related to this playlist and even i have mailed you .please help

    • @thedatachannel878
      @thedatachannel878 2 місяці тому

      Apologies for delay, I have shared now, please check your mail

  • @neuera9556
    @neuera9556 2 місяці тому

    Please send spark associate developer playlist dbf files i have send u email request still not response

  • @mohammedak-m8k
    @mohammedak-m8k 2 місяці тому

    please upload video 5

  • @mohammedak-m8k
    @mohammedak-m8k 2 місяці тому

    hi thanks for the course i have emailed to requesting for dbc file thanks

  • @vivekdutta7131
    @vivekdutta7131 2 місяці тому

    Sir! Where is the autoloader video. I cannot find it in this playlist! Please upload it.Thanks!🙂

  • @neuera9556
    @neuera9556 2 місяці тому

    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 !!

    • @thedatachannel878
      @thedatachannel878 2 місяці тому

      Amazed by your dedication, it is really inspiring. Thank you for your learning journey updates

  • @neuera9556
    @neuera9556 2 місяці тому

    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

    • @thedatachannel878
      @thedatachannel878 2 місяці тому

      Appreciate your efforts on compiling all this topics. Which would eventually help many learner’s Thank you, happy Learning

    • @neuera9556
      @neuera9556 2 місяці тому

      @@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 😊

    • @thedatachannel878
      @thedatachannel878 2 місяці тому

      @neuera9556 Noted Thank you for your genuine feedback

  • @neuera9556
    @neuera9556 2 місяці тому

    I saw thinking due to storage outage

  • @shubhambhardwaj2119
    @shubhambhardwaj2119 2 місяці тому

    is this sufficient to pass databricks certification and also pls share practice notebook hv shared a mail

    • @thedatachannel878
      @thedatachannel878 2 місяці тому

      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

  • @shubhambhardwaj2119
    @shubhambhardwaj2119 2 місяці тому

    Thanks for the tutorial ...Have mailed for the notebooks and course content. Please share.

    • @thedatachannel878
      @thedatachannel878 2 місяці тому

      Have shared details of practice notebooks in mail. Thank you

  • @ChrisC-k7y
    @ChrisC-k7y 2 місяці тому

    Thank you for making the course. Can I ask for the notebooks and data?

    • @thedatachannel878
      @thedatachannel878 2 місяці тому

      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

  • @JeevanKumar-z5k
    @JeevanKumar-z5k 2 місяці тому

    Request mail for the .dbc file to practice was sent to your mail, could you please send that file for my mail. Thanks

    • @thedatachannel878
      @thedatachannel878 2 місяці тому

      Hi, have shared the practice notebook details to your mail id. Thank you

  • @neuera9556
    @neuera9556 2 місяці тому

    Hi - i wana become data engineer can u suggest ur playlist in alphabetical order

  • @neuera9556
    @neuera9556 2 місяці тому

    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 😊

    • @thedatachannel878
      @thedatachannel878 2 місяці тому

      thedatapedia.com/2024/01/04/azure-data-engineering-comprehensive-learning-guide/

    • @thedatachannel878
      @thedatachannel878 2 місяці тому

      Refer to this link, where there is complete curated list in order and plan to learn. Hope it helps

  • @manaskumar9048
    @manaskumar9048 2 місяці тому

    Content is good, but the background music is really annoying. Please don't use it in your lectures.

    • @thedatachannel878
      @thedatachannel878 2 місяці тому

      Thank you for you valuable feedback . We have already considered and all our latest videos are without background noise Happy learning

  • @abdoukhadrediop804
    @abdoukhadrediop804 2 місяці тому

    Hello i send you a mail for content notebook

    • @thedatachannel878
      @thedatachannel878 2 місяці тому

      Hi, have replied you with required practice materials Thank you

  • @abdoukhadrediop804
    @abdoukhadrediop804 2 місяці тому

    Hello, thanks for tutorial ! i send you a mail for notebook.

    • @thedatachannel878
      @thedatachannel878 2 місяці тому

      Hi, have shared the practice notebook details to your mail id. Thank you