{"id":21265,"date":"2024-06-06T11:42:45","date_gmt":"2024-06-06T11:42:45","guid":{"rendered":"https:\/\/stage.cloudthat.com\/training\/?post_type=stm-courses&#038;p=21265"},"modified":"2025-03-19T07:24:29","modified_gmt":"2025-03-19T07:24:29","slug":"dp-602-implement-a-data-warehouse-in-microsoft-fabric","status":"publish","type":"stm-courses","link":"https:\/\/stage.cloudthat.com\/training\/azure\/dp-602-implement-a-data-warehouse-in-microsoft-fabric","title":{"rendered":"DP-602: Implement a data warehouse in Microsoft Fabric"},"content":{"rendered":"<p><span data-contrast=\"auto\">This course aims to develop your foundational skills in data engineering on Microsoft Fabric, with a focus on the Warehouse concept. You will understand how to save your data in a Warehouse using T-SQL, Dataflow Gen 2 and Data pipelines into Star schema model and efficiently to query your data using T-SQL. Additionally, you will explore how to monitor the performance of the data in your Fabric Warehouse. Through a blend of lectures and hands-on exercises, this course will equip you to effectively work with Warehouses in Microsoft Fabric.<\/span> <span data-ccp-props=\"{}\">\u00a0<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>This course aims to develop your foundational skills in data engineering on Microsoft Fabric, with a focus on the Warehouse concept. You will understand how to save your data in a Warehouse using T-SQL, Dataflow Gen 2 and Data pipelines into Star schema model and efficiently to query your data using T-SQL. Additionally, you will [&hellip;]<\/p>\n","protected":false},"author":3050,"featured_media":13797,"template":"","meta":{"footnotes":""},"stm_lms_course_taxonomy":[62],"metadata":{"stm_lms_product_id":["21266"],"_edit_lock":["1742368947:2"],"_edit_last":["2"],"permalink_customizer":["azure\/dp-602-implement-a-data-warehouse-in-microsoft-fabric"],"permalink_customizer_regenerate_status":["1"],"price":["34900"],"wpdocs-meta-bdt":["39900"],"wpdocs-meta-gbp":["1399"],"wpdocs-meta-usd":["1599"],"_yoast_wpseo_estimated-reading-time-minutes":["1"],"_yoast_wpseo_wordproof_timestamp":[""],"popular_course":["0"],"_popular_course":["field_64253688bc2e5"],"course_banner_image":[""],"_course_banner_image":["field_63c69a6b81cf1"],"mobile_banner_image":[""],"_mobile_banner_image":["field_63cf93896d207"],"banner_link":[""],"_banner_link":["field_63c69a9681cf2"],"banner_image":[""],"_banner_image":["field_621873548f922"],"banner_description":["Want to Validate your technical skills and open doors to new possibilities of advancement with Microsoft Applied Skills?  \r\n\r\nUnleash Your Data Potential with DP-602. With Microsoft Fabric, you can empower yourself with the expertise and capabilities needed to seamlessly implement a Warehouse architecture. As you master the Fabric tools, your data management skills will flourish. Embark on this educational voyage of transformation to become a Lakehouse implementation expert. "],"_banner_description":["field_612c733ed3564"],"overview_section_heading":[""],"_overview_section_heading":["field_64538867ffdd0"],"after_completing_course_heading":["After completing DP 601 course, students will be able to:"],"_after_completing_course_heading":["field_645c78ade3f50"],"after_completing_course_0_desciption":["Develop foundational skills in data engineering on Microsoft Fabric, focusing on the Warehouse concept. "],"_after_completing_course_0_desciption":["field_6103ad2f9f5b2"],"after_completing_course_1_desciption":["Explore T-SQL's capabilities for data ingestion and querying. "],"_after_completing_course_1_desciption":["field_6103ad2f9f5b2"],"after_completing_course_2_desciption":["Learn how to monitor you Fabric warehouse. "],"_after_completing_course_2_desciption":["field_6103ad2f9f5b2"],"after_completing_course_3_desciption":["Explore data ingestion and orchestration using Dataflows Gen2 and Data Factory pipelines. "],"_after_completing_course_3_desciption":["field_6103ad2f9f5b2"],"after_completing_course":["4"],"_after_completing_course":["field_6103aae828228"],"key_features_heading":["Key Features:"],"_key_features_heading":["field_645388ceffdd1"],"key_features_0_lists":["Guidance by Certified Experts: Benefit from expert instructors who will lead engaging online training sessions, providing you with valuable insights into Implementing a Data Warehouse using Microsoft Fabric."],"_key_features_0_lists":["field_6103ad559f5b3"],"key_features_1_lists":["Interactive Hands-On Labs: Gain practical experience through a series of interactive labs and exercises, allowing you to apply your newly acquired skills in real-world scenarios."],"_key_features_1_lists":["field_6103ad559f5b3"],"key_features_2_lists":["Personalized Learning Plans: Enjoy tailor-made training programs that cater to your unique learning requirements, ensuring you receive the most relevant knowledge and guidance."],"_key_features_2_lists":["field_6103ad559f5b3"],"key_features_3_lists":["Well-structured use-cases based on real world scenarios to help participants relate the scenarios where you can leverage Data Warehouse in Microsoft Fabric"],"_key_features_3_lists":["field_6103ad559f5b3"],"key_features_4_lists":["Integrated teaching assistance and support through experts designed Learning Management System (LMS) and Exam Ready platform."],"_key_features_4_lists":["field_6103ad559f5b3"],"key_features_5_lists":["Being a Microsoft Learning Partner, we offer authored curriculum that are at par with industry standards."],"_key_features_5_lists":["field_6103ad559f5b3"],"key_features":["6"],"_key_features":["field_6103aaff28229"],"who_should_attend_heading":["Who Should Attend:"],"_who_should_attend_heading":["field_645388faffdd2"],"who_should_attend_0_attend_lists":["The primary audience for this course is data professionals who are familiar with ETL operations, data modeling, extraction, and analytics.  "],"_who_should_attend_0_attend_lists":["field_6103adfb3f3e4"],"who_should_attend_1_attend_lists":["It is designed for professionals who are interested in gaining knowledge about Fabric Warehouse architecture in the Microsoft Fabric platform, and how to enable end-to-end analytics using these technologies. "],"_who_should_attend_1_attend_lists":["field_6103adfb3f3e4"],"who_should_attend":["2"],"_who_should_attend":["field_6103ab0d2822a"],"prerequisites_heading":["Pre-requisites of DP-602 course"],"_prerequisites_heading":["field_64538a51ffdd3"],"prerequisites_text":["<ul>To enrol in this course, it is recommended to have:  <\/ul>\r\n<li> Basic data concepts and terminology.  <\/li>\r\n<li> Fundamental data analytics concepts.<\/li>\r\n<li>The Microsoft Fabric interface and core concepts.  <\/li>\r\n<li>Microsoft Fabric warehouses and T-SQL. <\/li>\r\n<li>Microsoft Fabric and data orchestration. <\/li> "],"_prerequisites_text":["field_612c7498c4b84"],"question_sets_details_heading":[""],"_question_sets_details_heading":["field_65d303841f38d"],"question_sets_details_description":[""],"_question_sets_details_description":["field_65d303841f38e"],"question_sets_details_button_text":[""],"_question_sets_details_button_text":["field_65d303841f38f"],"question_sets_details_question_sets":[""],"_question_sets_details_question_sets":["field_65d303841f390"],"question_sets_details":[""],"_question_sets_details":["field_65d303841f38c"],"category_features_heading":[""],"_category_features_heading":["field_644b8ff35049c"],"category_features_features":[""],"_category_features_features":["field_644b90025049d"],"category_features_cta_text":[""],"_category_features_cta_text":["field_644b90285049f"],"category_features_cta_link":[""],"_category_features_cta_link":["field_644b902d504a0"],"category_features":[""],"_category_features":["field_644b8fe15049b"],"course_features_0_heading":["Why choose CloudThat as your training partner for DP-602? "],"_course_features_0_heading":["field_644a0fae0e67e"],"course_features_0_features_list_0_list":["CloudThat has successfully trained a vast number of professionals, approximately 6.5 lakh individuals, and provided training services to more than 100 corporate clients across the globe. "],"_course_features_0_features_list_0_list":["field_644a0fc80e680"],"course_features_0_features_list_1_list":["We have well-trained, experienced, and certified Subject matter experts and instructors to conduct these trainings. "],"_course_features_0_features_list_1_list":["field_644a0fc80e680"],"course_features_0_features_list_2_list":["The course guides students through specific tasks and real-world challenges to help them understand the relevance, power, and usefulness of Microsoft Word."],"_course_features_0_features_list_2_list":["field_644a0fc80e680"],"course_features_0_features_list":["3"],"_course_features_0_features_list":["field_644a0fb70e67f"],"course_features_0_background_color":["a:1:{i:0;s:4:\"blue\";}"],"_course_features_0_background_color":["field_644a0fde0e681"],"course_features_1_heading":["Learning objective of the DP-602 Certification Training "],"_course_features_1_heading":["field_644a0fae0e67e"],"course_features_1_features_list_0_list":["Describe core features and capabilities of warehouses in Microsoft Fabric "],"_course_features_1_features_list_0_list":["field_644a0fc80e680"],"course_features_1_features_list_1_list":["Using T-SQL in a Microsoft Fabric workspace "],"_course_features_1_features_list_1_list":["field_644a0fc80e680"],"course_features_1_features_list_2_list":["Monitoring a Data Warehouse in Microsoft Fabric "],"_course_features_1_features_list_2_list":["field_644a0fc80e680"],"course_features_1_features_list_3_list":["Implement Dataflow Gen 2 and Data Pipeline for data orchestration in Microsoft Fabric"],"_course_features_1_features_list_3_list":["field_644a0fc80e680"],"course_features_1_features_list":["4"],"_course_features_1_features_list":["field_644a0fb70e67f"],"course_features_1_background_color":["a:1:{i:0;s:5:\"white\";}"],"_course_features_1_background_color":["field_644a0fde0e681"],"course_features":["2"],"_course_features":["field_644a0fa10e67d"],"certification_heading":["Certification details:"],"_certification_heading":["field_64538bffffdd5"],"certification_0_short_description":[""],"_certification_0_short_description":["field_6103ab2f2822c"],"certification_0_list_content":["<li>Obtaining the Microsoft Azure DP-601 Applied Skill Credential certifies your familiarity with Implementing a Lakehouse with Microsoft Fabric.  <\/li>\r\n<li>DP-601 Applied skill course will teach you the way on how to Implement a Lakehouse in Microsoft Fabric for various scenarios. <\/li>\r\n<li>Applied skills can be utilized to be ready for more specialized or role-based Azure certifications.<\/li>\r\n<li>We award a certificate of course completion to candidates who pass the DP-601 Microsoft Azure Applied Skills Training.<\/li>\r\n<li>After completing the Microsoft Azure DP-601 assessment, candidates are awarded a Microsoft credential as well.\u202f <\/li> \r\n"],"_certification_0_list_content":["field_6103ab4a2822d"],"certification_0_image":["17714"],"_certification_0_image":["field_6103ab5b2822e"],"certification":["1"],"_certification":["field_6103ab1a2822b"],"about_trainer":[""],"_about_trainer":["field_6103ab6c2822f"],"course_fee_heading":[""],"_course_fee_heading":["field_64538c1cffdd6"],"course_fee_list":[""],"_course_fee_list":["field_6103abb728234"],"brochure_pdf":[""],"_brochure_pdf":["field_61232e258f89b"],"trainer":[""],"_trainer":["field_6124990e13784"],"course_outline_heading":["Course Outline :  "],"_course_outline_heading":["field_64538a8effdd4"],"course_section_0_module_title":["Get started with data warehouses in Microsoft Fabric "],"_course_section_0_module_title":["field_612f5535940c3"],"course_section_0_module_description":[""],"_course_section_0_module_description":["field_612f564c921af"],"course_section_0_section_0_title":[""],"_course_section_0_section_0_title":["field_612f5233b0278"],"course_section_0_section_0_lesson_list_0_lession_title":["Understand data warehouse fundamentals "],"_course_section_0_section_0_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_0_section_0_lesson_list_1_lession_title":["Understand data warehouses in Fabric "],"_course_section_0_section_0_lesson_list_1_lession_title":["field_612f533b0ac41"],"course_section_0_section_0_lesson_list_2_lession_title":["Query and transform data "],"_course_section_0_section_0_lesson_list_2_lession_title":["field_612f533b0ac41"],"course_section_0_section_0_lesson_list":["6"],"_course_section_0_section_0_lesson_list":["field_612f530a0ac40"],"course_section_0_section":["1"],"_course_section_0_section":["field_612f51e6b0277"],"course_section_1_module_title":[" Load data into a Microsoft Fabric data warehouse"],"_course_section_1_module_title":["field_612f5535940c3"],"course_section_1_module_description":[""],"_course_section_1_module_description":["field_612f564c921af"],"course_section_1_section_0_title":[""],"_course_section_1_section_0_title":["field_612f5233b0278"],"course_section_1_section_0_lesson_list_0_lession_title":["Explore data load strategies "],"_course_section_1_section_0_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_1_section_0_lesson_list_1_lession_title":["Use data pipelines to load a warehouse"],"_course_section_1_section_0_lesson_list_1_lession_title":["field_612f533b0ac41"],"course_section_1_section_0_lesson_list_2_lession_title":["Load data using T-SQL "],"_course_section_1_section_0_lesson_list_2_lession_title":["field_612f533b0ac41"],"course_section_1_section_0_lesson_list":["5"],"_course_section_1_section_0_lesson_list":["field_612f530a0ac40"],"course_section_1_section":["1"],"_course_section_1_section":["field_612f51e6b0277"],"course_section_2_module_title":["Query a data warehouse in Microsoft Fabric "],"_course_section_2_module_title":["field_612f5535940c3"],"course_section_2_module_description":[""],"_course_section_2_module_description":["field_612f564c921af"],"course_section_2_section_0_title":[""],"_course_section_2_section_0_title":["field_612f5233b0278"],"course_section_2_section_0_lesson_list_0_lession_title":["Use the SQL query editor "],"_course_section_2_section_0_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_2_section_0_lesson_list_1_lession_title":["Explore the visual query editor "],"_course_section_2_section_0_lesson_list_1_lession_title":["field_612f533b0ac41"],"course_section_2_section_0_lesson_list_2_lession_title":["Use client tools to query a warehouse "],"_course_section_2_section_0_lesson_list_2_lession_title":["field_612f533b0ac41"],"course_section_2_section_0_lesson_list_3_lession_title":["Lab - Query a data warehouse in Microsoft Fabric "],"_course_section_2_section_0_lesson_list_3_lession_title":["field_612f533b0ac41"],"course_section_2_section_0_lesson_list":["4"],"_course_section_2_section_0_lesson_list":["field_612f530a0ac40"],"course_section_2_section":["1"],"_course_section_2_section":["field_612f51e6b0277"],"course_section_3_module_title":["Monitor a Microsoft Fabric data warehouse"],"_course_section_3_module_title":["field_612f5535940c3"],"course_section_3_module_description":[""],"_course_section_3_module_description":["field_612f564c921af"],"course_section_3_section_0_title":[""],"_course_section_3_section_0_title":["field_612f5233b0278"],"course_section_3_section_0_lesson_list_0_lession_title":["Monitor capacity metrics "],"_course_section_3_section_0_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_3_section_0_lesson_list_1_lession_title":["Monitor current activity"],"_course_section_3_section_0_lesson_list_1_lession_title":["field_612f533b0ac41"],"course_section_3_section_0_lesson_list_2_lession_title":["Monitor queries "],"_course_section_3_section_0_lesson_list_2_lession_title":["field_612f533b0ac41"],"course_section_3_section_0_lesson_list_3_lession_title":["Lab - Monitor a data warehouse in Microsoft Fabric Use delta tables with streaming data "],"_course_section_3_section_0_lesson_list_3_lession_title":["field_612f533b0ac41"],"course_section_3_section_0_lesson_list":["4"],"_course_section_3_section_0_lesson_list":["field_612f530a0ac40"],"course_section_3_section":["1"],"_course_section_3_section":["field_612f51e6b0277"],"course_section":["4"],"_course_section":["field_612f4f27b0276"],"note_section":[""],"_note_section":["field_616d3ed46bbd2"],"popular_sort":[""],"_popular_sort":["field_6172496402af3"],"related_courses":[""],"_related_courses":["field_61c453ca6b2dd"],"reviews_heading":[""],"_reviews_heading":["field_64538c39ffdd7"],"review_rating":[""],"_review_rating":["field_62a813a92bee6"],"total_review_count":["2184"],"_total_review_count":["field_62b002d8d2de5"],"average_review_count":["4.5"],"_average_review_count":["field_62b00367d2de6"],"faq_heading":["FAQs on DP 602"],"_faq_heading":["field_64538c59ffdd8"],"educational_schema":[""],"_educational_schema":["field_652fbbf6f589a"],"sale_price_dates_start":[""],"sale_price_dates_end":[""],"curriculum":[""],"featured":[""],"views":["2407"],"level":["intermediate"],"current_students":["0"],"duration_info":["1 Day"],"video_duration":[""],"status":[""],"status_dates":[""],"not_single_sale":[""],"sale_price":[""],"sale_price_dates":[""],"enterprise_price":[""],"not_membership":[""],"affiliate_course":[""],"affiliate_course_text":[""],"affiliate_course_link":[""],"expiration_course":[""],"end_time":[""],"drip_content":[""],"prerequisites":[""],"prerequisite_passing_level":[""],"announcement":[""],"faq":["[{\"question\":\"What exactly is a Microsoft Applied Skill?\u202f\",\"answer\":\"It is based on one specific skill, Project based, Scenario-specific ability.\"},{\"question\":\"Can I access the course for free on Microsoft Learn?\u202f\",\"answer\":\"Yes, many Microsoft Learn courses, including this one, are often available for free.\"},{\"question\":\"Are there any specific software or tools required for the course?\",\"answer\":\"Participants will need a computer with internet access. \"},{\"question\":\"What prior knowledge is required for this Microsoft Learn course?\u202f \",\"answer\":\"Familiarity of basic data concepts, data analytics, T-SQL, pipelines may be helpful. \"},{\"question\":\"How can I prepare for the Microsoft DP-601?\u202f \",\"answer\":\"Use Microsoft's official documentation, practice labs, and exam-focused resources for comprehensive readiness.\u202f \"},{\"question\":\"Do we have to pay for the evaluation?\",\"answer\":\"No. Access Microsoft Learn and complete the assessment.\u202f \"},{\"question\":\"What happens after clearing assessment for Azure DP-602?\u202f \",\"answer\":\"After completing the DP-602 exam, you will receive the Microsoft Credential: Implementing a Lakehouse with Microsoft Fabric \"}]"],"course_files_pack":[""],"course_certificate":[""],"type":[""],"video_type":[""],"presto_player_idx":[""],"lesson_video":[""],"lesson_video_poster":[""],"lesson_video_width":[""],"lesson_shortcode":[""],"lesson_embed_ctx":[""],"lesson_youtube_url":[""],"lesson_stream_url":[""],"lesson_vimeo_url":[""],"lesson_ext_link_url":[""],"duration":[""],"preview":[""],"lesson_excerpt":[""],"lesson_files_pack":[""],"questions":[""],"quiz_style":[""],"duration_measure":[""],"correct_answer":[""],"passing_grade":[""],"re_take_cut":[""],"random_questions":[""],"answers":[""],"question_explanation":[""],"question_view_type":[""],"review_course":[""],"review_user":[""],"review_mark":[""],"order":[""],"absolute":[""],"sticky":[""],"sticky_threshold":[""],"sticky_threshold_color":[""],"stm_agenda":[""],"stm_host":[""],"stm_select_approved_denied":[""],"stm_multiselect_approved":[""],"stm_multiselect_denied":[""],"stm_date":[""],"stm_time":[""],"stm_timezone":[""],"stm_duration":[""],"stm_password":[""],"stm_waiting_room":[""],"stm_join_before_host":[""],"stm_host_join_start":[""],"stm_start_after_participants":[""],"stm_mute_participants":[""],"stm_enforce_login":[""],"stm_alternative_hosts":[""],"author_id":[""],"emails":[""],"_yoast_wpseo_primary_stm_lms_course_taxonomy":["62"],"course_section_0_section_0_lesson_list_3_lession_title":["Prepare data for analysis and reporting "],"_course_section_0_section_0_lesson_list_3_lession_title":["field_612f533b0ac41"],"course_section_0_section_0_lesson_list_4_lession_title":["Secure and monitor your data warehouse "],"_course_section_0_section_0_lesson_list_4_lession_title":["field_612f533b0ac41"],"course_section_0_section_0_lesson_list_5_lession_title":["Lab - Analyze data in a data warehouse "],"_course_section_0_section_0_lesson_list_5_lession_title":["field_612f533b0ac41"],"course_section_1_section_0_lesson_list_3_lession_title":["Load and transform data with Dataflow Gen2"],"_course_section_1_section_0_lesson_list_3_lession_title":["field_612f533b0ac41"],"course_section_1_section_0_lesson_list_4_lession_title":["Lab - Load data into a warehouse in Microsoft Fabric "],"_course_section_1_section_0_lesson_list_4_lession_title":["field_612f533b0ac41"],"_yoast_wpseo_title":["Ultimate DP-602 Certification Guide"],"_yoast_wpseo_metadesc":["Ace the DP-602 exam with our comprehensive Microsoft Azure Data Engineer Associate Certification guide. Master data engineering concepts like data ingestion, transformation, and big data processing using Azure services. Elevate your career - enroll now!"],"_wp_old_date":["2024-05-31"],"_thumbnail_id":["13797"],"_regular_price_wmcp":["{\"USD\":\"1599\",\"GBP\":\"1399\",\"BDT\":\"39900\"}"],"_yoast_wpseo_content_score":["90"]},"acf":[],"_links":{"self":[{"href":"https:\/\/stage.cloudthat.com\/training\/wp-json\/wp\/v2\/stm-courses\/21265"}],"collection":[{"href":"https:\/\/stage.cloudthat.com\/training\/wp-json\/wp\/v2\/stm-courses"}],"about":[{"href":"https:\/\/stage.cloudthat.com\/training\/wp-json\/wp\/v2\/types\/stm-courses"}],"author":[{"embeddable":true,"href":"https:\/\/stage.cloudthat.com\/training\/wp-json\/wp\/v2\/users\/3050"}],"version-history":[{"count":0,"href":"https:\/\/stage.cloudthat.com\/training\/wp-json\/wp\/v2\/stm-courses\/21265\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/stage.cloudthat.com\/training\/wp-json\/wp\/v2\/media\/13797"}],"wp:attachment":[{"href":"https:\/\/stage.cloudthat.com\/training\/wp-json\/wp\/v2\/media?parent=21265"}],"wp:term":[{"taxonomy":"stm_lms_course_taxonomy","embeddable":true,"href":"https:\/\/stage.cloudthat.com\/training\/wp-json\/wp\/v2\/stm_lms_course_taxonomy?post=21265"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}