{"id":979,"date":"2019-12-03T21:55:26","date_gmt":"2019-12-03T21:55:26","guid":{"rendered":"https:\/\/sky-it.ro\/clone\/?page_id=979"},"modified":"2020-01-06T19:10:18","modified_gmt":"2020-01-06T19:10:18","slug":"curs-oficial-microsoft-sql-20767c-implementing-a-sql-data-warehouse","status":"publish","type":"page","link":"https:\/\/sky-it.ro\/clone\/curs-oficial-microsoft-sql-20767c-implementing-a-sql-data-warehouse\/","title":{"rendered":"Course 20767C: Implementing a SQL Data Warehouse"},"content":{"rendered":"<p>[vc_row css_animation=&#8221;&#8221; row_type=&#8221;row&#8221; use_row_as_full_screen_section=&#8221;no&#8221; type=&#8221;grid&#8221; angled_section=&#8221;no&#8221; text_align=&#8221;left&#8221; background_image_as_pattern=&#8221;without_pattern&#8221; z_index=&#8221;&#8221; padding_top=&#8221;44&#8243; padding_bottom=&#8221;44&#8243;][vc_column width=&#8221;2\/3&#8243;][vc_row_inner row_type=&#8221;row&#8221; type=&#8221;full_width&#8221; text_align=&#8221;left&#8221; css_animation=&#8221;&#8221;][vc_column_inner width=&#8221;1\/3&#8243;][vc_column_text]<\/p>\n<h6>Durata: <span style=\"color: gray;\">5 zile<\/span><\/h6>\n<p>[\/vc_column_text][\/vc_column_inner][vc_column_inner width=&#8221;1\/3&#8243;][vc_column_text]<\/p>\n<h6>Pret:\u00a0<span style=\"color: gray;\">Solicita oferta!<\/span><\/h6>\n<p>[\/vc_column_text][\/vc_column_inner][vc_column_inner width=&#8221;1\/3&#8243;][vc_column_text]<\/p>\n<h6>Nivel: <span style=\"color: gray;\">intermediar<\/span><\/h6>\n<p>[\/vc_column_text][\/vc_column_inner][\/vc_row_inner][vc_separator type=&#8221;transparent&#8221; up=&#8221;44&#8243;]<div class=\"qode-advanced-tabs qode-advanced-tabs qode-advanced-horizontal-tab clearfix qode-advanced-tab-without-icon qode-advanced-tabs-column-3 clearfix\">\n\t<ul class=\"qode-advanced-tabs-nav\">\n\t\t\t\t\t<li>\n\t\t\t\t<h3>\n\t\t\t\t\t<a href=\"#tab-overview\">\n\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"qode-advanced-tab-text-after-icon\">\n\t\t\t\t\t\t\t\tOverview\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t<\/h3>\n\t\t\t<\/li>\n\t\t\t\t\t<li>\n\t\t\t\t<h3>\n\t\t\t\t\t<a href=\"#tab-course-detalis\">\n\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"qode-advanced-tab-text-after-icon\">\n\t\t\t\t\t\t\t\tCourse detalis\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t<\/h3>\n\t\t\t<\/li>\n\t\t\t\t\t<li>\n\t\t\t\t<h3>\n\t\t\t\t\t<a href=\"#tab-prerequisites\">\n\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"qode-advanced-tab-text-after-icon\">\n\t\t\t\t\t\t\t\tPrerequisites\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t<\/h3>\n\t\t\t<\/li>\n\t\t\t<\/ul>\n\t<div class=\"qode-advanced-tab-container\" id=\"tab-overview-26\" data-icon-pack=\"\" data-icon-html=\"\">[vc_column_text]<strong>About this course<\/strong><\/p>\n<p>This five-day instructor-led course provides students with the knowledge and skills to provision a Microsoft SQL Server database. The course covers SQL Server provision both on-premise and in Azure, and covers installing from new and migrating from an existing install.<\/p>\n<p><strong>Audience profile<\/strong><\/p>\n<p>The primary audience for this course are database professionals who need to fulfil a Business Intelligence Developer role.\u00a0 They will need to focus on hands-on work creating BI solutions including Data Warehouse implementation, ETL, and data cleansing.<\/p>\n<p><strong>At course completion<\/strong><\/p>\n<p>After completing this course, students will be able to:<\/p>\n<ul>\n<li>Describe the key elements of a data warehousing solution<\/li>\n<li>Describe the main hardware considerations for building a data warehouse<\/li>\n<li>Implement a logical design for a data warehouse<\/li>\n<li>Implement a physical design for a data warehouse<\/li>\n<li>Create columnstore indexes<\/li>\n<li>Implementing an Azure SQL Data Warehouse<\/li>\n<li>Describe the key features of SSIS<\/li>\n<li>Implement a data flow by using SSIS<\/li>\n<li>Implement control flow by using tasks and precedence constraints<\/li>\n<li>Create dynamic packages that include variables and parameters<\/li>\n<li>Debug SSIS packages<\/li>\n<li>Describe the considerations for implement an ETL solution<\/li>\n<li>Implement Data Quality Services<\/li>\n<li>Implement a Master Data Services model<\/li>\n<li>Describe how you can use custom components to extend SSIS<\/li>\n<li>Deploy SSIS projects<\/li>\n<li>Describe BI and common BI scenarios<\/li>\n<\/ul>\n<p>[\/vc_column_text]<\/div><div class=\"qode-advanced-tab-container\" id=\"tab-course-detalis-341\" data-icon-pack=\"\" data-icon-html=\"\">[vc_column_text]<strong>Course Outline<\/strong><\/p>\n<p><strong>Module 1: Introduction to Data Warehousing<\/strong><\/p>\n<p>This module describes data warehouse concepts and architecture consideration.Lessons<\/p>\n<ul>\n<li>Overview of Data Warehousing<\/li>\n<li>Considerations for a Data Warehouse Solution<\/li>\n<\/ul>\n<p>Lab : Exploring a Data Warehouse Solution<\/p>\n<ul>\n<li>Exploring data sources<\/li>\n<li>Exploring an ETL process<\/li>\n<li>Exploring a data warehouse<\/li>\n<\/ul>\n<p>After completing this module, you will be able to:<\/p>\n<ul>\n<li>Describe the key elements of a data warehousing solution<\/li>\n<li>Describe the key considerations for a data warehousing solution<\/li>\n<\/ul>\n<p><strong>Module 2: Planning Data Warehouse Infrastructure<\/strong><\/p>\n<p>This module describes the main hardware considerations for building a data warehouse.<\/p>\n<p><strong>Lessons<\/strong><\/p>\n<ul>\n<li>Considerations for data warehouse infrastructure.<\/li>\n<li>Planning data warehouse hardware.<\/li>\n<\/ul>\n<p>Lab : Planning Data Warehouse Infrastructure<\/p>\n<ul>\n<li>Planning data warehouse hardware<\/li>\n<\/ul>\n<p>After completing this module, you will be able to:<\/p>\n<ul>\n<li>Describe the main hardware considerations for building a data warehouse<\/li>\n<li>Explain how to use reference architectures and data warehouse appliances to create a data warehouse<\/li>\n<\/ul>\n<p><strong>Module 3: Designing and Implementing a Data Warehouse<\/strong><\/p>\n<p>This module describes how you go about designing and implementing a schema for a data warehouse.<\/p>\n<p><strong>Lessons<\/strong><\/p>\n<ul>\n<li>Data warehouse design overview<\/li>\n<li>Designing dimension tables<\/li>\n<li>Designing fact tables<\/li>\n<li>Physical Design for a Data Warehouse<\/li>\n<\/ul>\n<p>Lab : Implementing a Data Warehouse Schema<\/p>\n<ul>\n<li>Implementing a star schema<\/li>\n<li>Implementing a snowflake schema<\/li>\n<li>Implementing a time dimension table<\/li>\n<\/ul>\n<p>After completing this module, you will be able to:<\/p>\n<ul>\n<li>Implement a logical design for a data warehouse<\/li>\n<li>Implement a physical design for a data warehouse<\/li>\n<\/ul>\n<p><strong>Module 4: Columnstore Indexes<\/strong><\/p>\n<p>This module introduces Columnstore Indexes.<\/p>\n<p><strong>Lessons<\/strong><\/p>\n<ul>\n<li>Introduction to Columnstore Indexes<\/li>\n<li>Creating Columnstore Indexes<\/li>\n<li>Working with Columnstore Indexes<\/li>\n<\/ul>\n<p>Lab : Using Columnstore Indexes<\/p>\n<ul>\n<li>Create a Columnstore index on the FactProductInventory table<\/li>\n<li>Create a Columnstore index on the FactInternetSales table<\/li>\n<li>Create a memory optimized Columnstore table<\/li>\n<\/ul>\n<p>After completing this module, you will be able to:<\/p>\n<ul>\n<li>Create Columnstore indexes<\/li>\n<li>Work with Columnstore Indexes<\/li>\n<\/ul>\n<p><strong>Module 5: Implementing an Azure SQL Data Warehouse<\/strong><\/p>\n<p>This module describes Azure SQL Data Warehouses and how to implement them.<\/p>\n<p><strong>Lessons<\/strong><\/p>\n<ul>\n<li>Advantages of Azure SQL Data Warehouse<\/li>\n<li>Implementing an Azure SQL Data Warehouse<\/li>\n<li>Developing an Azure SQL Data Warehouse<\/li>\n<li>Migrating to an Azure SQ Data Warehouse<\/li>\n<li>Copying data with the Azure data factory<\/li>\n<\/ul>\n<p>Lab : Implementing an Azure SQL Data Warehouse<\/p>\n<ul>\n<li>Create an Azure SQL data warehouse database<\/li>\n<li>Migrate to an Azure SQL Data warehouse database<\/li>\n<li>Copy data with the Azure data factory<\/li>\n<\/ul>\n<p>After completing this module, you will be able to:<\/p>\n<ul>\n<li>Describe the advantages of Azure SQL Data Warehouse<\/li>\n<li>Implement an Azure SQL Data Warehouse<\/li>\n<li>Describe the considerations for developing an Azure SQL Data Warehouse<\/li>\n<li>Plan for migrating to Azure SQL Data Warehouse<\/li>\n<\/ul>\n<p><strong>Module 6: Creating an ETL Solution<\/strong><\/p>\n<p>At the end of this module you will be able to implement data flow in a SSIS package.<\/p>\n<p><strong>Lessons<\/strong><\/p>\n<ul>\n<li>Introduction to ETL with SSIS<\/li>\n<li>Exploring Source Data<\/li>\n<li>Implementing Data Flow<\/li>\n<\/ul>\n<p>Lab : Implementing Data Flow in an SSIS Package<\/p>\n<ul>\n<li>Exploring source data<\/li>\n<li>Transferring data by using a data row task<\/li>\n<li>Using transformation components in a data row<\/li>\n<\/ul>\n<p>After completing this module, you will be able to:<\/p>\n<ul>\n<li>Describe ETL with SSIS<\/li>\n<li>Explore Source Data<\/li>\n<li>Implement a Data Flow<\/li>\n<\/ul>\n<p><strong>Module 7: Implementing Control Flow in an SSIS Package<\/strong><\/p>\n<p>This module describes implementing control flow in an SSIS package.<\/p>\n<p><strong>Lessons<\/strong><\/p>\n<ul>\n<li>Introduction to Control Flow<\/li>\n<li>Creating Dynamic Packages<\/li>\n<li>Using Containers<\/li>\n<li>Managing consistency.<\/li>\n<\/ul>\n<p>Lab : Implementing Control Flow in an SSIS Package<\/p>\n<ul>\n<li>Using tasks and precedence in a control flow<\/li>\n<li>Using variables and parameters<\/li>\n<li>Using containers<\/li>\n<\/ul>\n<p>Lab : Using Transactions and Checkpoints<\/p>\n<ul>\n<li>Using transactions<\/li>\n<li>Using checkpoints<\/li>\n<\/ul>\n<p>After completing this module, you will be able to:<\/p>\n<ul>\n<li>Describe control flow<\/li>\n<li>Create dynamic packages<\/li>\n<li>Use containers<\/li>\n<\/ul>\n<p><strong>Module 8: Debugging and Troubleshooting SSIS Packages<\/strong><\/p>\n<p>This module describes how to debug and troubleshoot SSIS packages.<\/p>\n<p><strong>Lessons<\/strong><\/p>\n<ul>\n<li>Debugging an SSIS Package<\/li>\n<li>Logging SSIS Package Events<\/li>\n<li>Handling Errors in an SSIS Package<\/li>\n<\/ul>\n<p>Lab : Debugging and Troubleshooting an SSIS Package<\/p>\n<ul>\n<li>Debugging an SSIS package<\/li>\n<li>Logging SSIS package execution<\/li>\n<li>Implementing an event handler<\/li>\n<li>Handling errors in data flow<\/li>\n<\/ul>\n<p>After completing this module, you will be able to:<\/p>\n<ul>\n<li>Debug an SSIS package<\/li>\n<li>Log SSIS package events<\/li>\n<li>Handle errors in an SSIS package<\/li>\n<\/ul>\n<p><strong>Module 9: Implementing a Data Extraction Solution<\/strong><\/p>\n<p>This module describes how to implement an SSIS solution that supports incremental DW loads and changing data.<\/p>\n<p><strong>Lessons<\/strong><\/p>\n<ul>\n<li>Introduction to Incremental ETL<\/li>\n<li>Extracting Modified Data<\/li>\n<li>Loading modified data<\/li>\n<li>Temporal Tables<\/li>\n<\/ul>\n<p>Lab : Extracting Modified Data<\/p>\n<ul>\n<li>Using a datetime column to incrementally extract data<\/li>\n<li>Using change data capture<\/li>\n<li>Using the CDC control task<\/li>\n<li>Using change tracking<\/li>\n<\/ul>\n<p>Lab : Loading a data warehouse<\/p>\n<ul>\n<li>Loading data from CDC output tables<\/li>\n<li>Using a lookup transformation to insert or update dimension data<\/li>\n<li>Implementing a slowly changing dimension<\/li>\n<li>Using the merge statement<\/li>\n<\/ul>\n<p>After completing this module, you will be able to:<\/p>\n<ul>\n<li>Describe incremental ETL<\/li>\n<li>Extract modified data<\/li>\n<li>Load modified data.<\/li>\n<li>Describe temporal tables<\/li>\n<\/ul>\n<p><strong>Module 10: Enforcing Data Quality<\/strong><\/p>\n<p>This module describes how to implement data cleansing by using Microsoft Data Quality services.<\/p>\n<p><strong>Lessons<\/strong><\/p>\n<ul>\n<li>Introduction to Data Quality<\/li>\n<li>Using Data Quality Services to Cleanse Data<\/li>\n<li>Using Data Quality Services to Match Data<\/li>\n<\/ul>\n<p>Lab : Cleansing Data<\/p>\n<ul>\n<li>Creating a DQS knowledge base<\/li>\n<li>Using a DQS project to cleanse data<\/li>\n<li>Using DQS in an SSIS package<\/li>\n<\/ul>\n<p>Lab : De-duplicating Data<\/p>\n<ul>\n<li>Creating a matching policy<\/li>\n<li>Using a DS project to match data<\/li>\n<\/ul>\n<p>After completing this module, you will be able to:<\/p>\n<ul>\n<li>Describe data quality services<\/li>\n<li>Cleanse data using data quality services<\/li>\n<li>Match data using data quality services<\/li>\n<li>De-duplicate data using data quality services<\/li>\n<\/ul>\n<p><strong>Module 11: Using Master Data Services<\/strong><\/p>\n<p>This module describes how to implement master data services to enforce data integrity at source.<\/p>\n<p><strong>Lessons<\/strong><\/p>\n<ul>\n<li>Introduction to Master Data Services<\/li>\n<li>Implementing a Master Data Services Model<\/li>\n<li>Hierarchies and collections<\/li>\n<li>Creating a Master Data Hub<\/li>\n<\/ul>\n<p>Lab : Implementing Master Data Services<\/p>\n<ul>\n<li>Creating a master data services model<\/li>\n<li>Using the master data services add-in for Excel<\/li>\n<li>Enforcing business rules<\/li>\n<li>Loading data into a model<\/li>\n<li>Consuming master data services data<\/li>\n<\/ul>\n<p>After completing this module, you will be able to:<\/p>\n<ul>\n<li>Describe the key concepts of master data services<\/li>\n<li>Implement a master data service model<\/li>\n<li>Manage master data<\/li>\n<li>Create a master data hub<\/li>\n<\/ul>\n<p><strong>Module 12: Extending SQL Server Integration Services (SSIS)<\/strong><\/p>\n<p>This module describes how to extend SSIS with custom scripts and components.<\/p>\n<p><strong>Lessons<\/strong><\/p>\n<ul>\n<li>Using scripting in SSIS<\/li>\n<li>Using custom components in SSIS<\/li>\n<\/ul>\n<p>Lab : Using scripts<\/p>\n<ul>\n<li>Using a script task<\/li>\n<\/ul>\n<p>After completing this module, you will be able to:<\/p>\n<ul>\n<li>Use custom components in SSIS<\/li>\n<li>Use scripting in SSIS<\/li>\n<\/ul>\n<p><strong>Module 13: Deploying and Configuring SSIS Packages<\/strong><\/p>\n<p>This module describes how to deploy and configure SSIS packages.<\/p>\n<p><strong>Lessons<\/strong><\/p>\n<ul>\n<li>Overview of SSIS Deployment<\/li>\n<li>Deploying SSIS Projects<\/li>\n<li>Planning SSIS Package Execution<\/li>\n<\/ul>\n<p>Lab : Deploying and Configuring SSIS Packages<\/p>\n<ul>\n<li>Creating an SSIS catalog<\/li>\n<li>Deploying an SSIS project<\/li>\n<li>Creating environments for an SSIS solution<\/li>\n<li>Running an SSIS package in SQL server management studio<\/li>\n<li>Scheduling SSIS packages with SQL server agent<\/li>\n<\/ul>\n<p>After completing this module, you will be able to:<\/p>\n<ul>\n<li>Describe an SSIS deployment<\/li>\n<li>Deploy an SSIS package<\/li>\n<li>Plan SSIS package execution<\/li>\n<\/ul>\n<p><strong>Module 14: Consuming Data in a Data Warehouse<\/strong><\/p>\n<p>This module describes how to debug and troubleshoot SSIS packages.<\/p>\n<p><strong>Lessons<\/strong><\/p>\n<ul>\n<li>Introduction to Business Intelligence<\/li>\n<li>An Introduction to Data Analysis<\/li>\n<li>Introduction to reporting<\/li>\n<li>Analyzing Data with Azure SQL Data Warehouse<\/li>\n<\/ul>\n<p>Lab : Using a data warehouse<\/p>\n<ul>\n<li>Exploring a reporting services report<\/li>\n<li>Exploring a PowerPivot workbook<\/li>\n<li>Exploring a power view report<\/li>\n<\/ul>\n<p>After completing this module, you will be able to:<\/p>\n<ul>\n<li>Describe at a high level business intelligence<\/li>\n<li>Show an understanding of reporting<\/li>\n<li>Show an understanding of data analysis<\/li>\n<li>Analyze data with Azure SQL data warehouse<\/li>\n<\/ul>\n<p>[\/vc_column_text]<\/div><div class=\"qode-advanced-tab-container\" id=\"tab-prerequisites-817\" data-icon-pack=\"\" data-icon-html=\"\">[vc_column_text]In addition to their professional experience, students who attend this training should already have the following technical knowledge:<\/p>\n<ul>\n<li>Basic knowledge of the Microsoft Windows operating system and its core functionality.<\/li>\n<li>Working knowledge of relational databases.<\/li>\n<li>Some experience with database design.<\/li>\n<\/ul>\n<p>[\/vc_column_text]<\/div><\/div>[\/vc_column][vc_column width=&#8221;1\/3&#8243;][vc_row_inner row_type=&#8221;row&#8221; type=&#8221;full_width&#8221; text_align=&#8221;left&#8221; css_animation=&#8221;&#8221;][vc_column_inner][vc_column_text]<\/p>\n<h6>Formular inregistrare:<\/h6>\n<p>[\/vc_column_text][\/vc_column_inner][\/vc_row_inner][vc_separator type=&#8221;transparent&#8221; up=&#8221;36&#8243;]\n<div class=\"wpcf7 no-js\" id=\"wpcf7-f740-o1\" lang=\"ro-RO\" dir=\"ltr\">\n<div class=\"screen-reader-response\"><p role=\"status\" aria-live=\"polite\" aria-atomic=\"true\"><\/p> <ul><\/ul><\/div>\n<form action=\"\/clone\/wp-json\/wp\/v2\/pages\/979#wpcf7-f740-o1\" method=\"post\" class=\"wpcf7-form init default\" aria-label=\"Formular de contact\" novalidate=\"novalidate\" data-status=\"init\">\n<div style=\"display: none;\">\n<input type=\"hidden\" name=\"_wpcf7\" value=\"740\" \/>\n<input type=\"hidden\" name=\"_wpcf7_version\" value=\"5.9.8\" \/>\n<input type=\"hidden\" name=\"_wpcf7_locale\" value=\"ro_RO\" \/>\n<input type=\"hidden\" name=\"_wpcf7_unit_tag\" value=\"wpcf7-f740-o1\" \/>\n<input type=\"hidden\" name=\"_wpcf7_container_post\" value=\"0\" \/>\n<input type=\"hidden\" name=\"_wpcf7_posted_data_hash\" value=\"\" \/>\n<\/div>\n<p><label> *Nume si prenume: <span class=\"wpcf7-form-control-wrap\" data-name=\"your-name\"><input size=\"40\" maxlength=\"400\" class=\"wpcf7-form-control wpcf7-text wpcf7-validates-as-required\" aria-required=\"true\" aria-invalid=\"false\" value=\"\" type=\"text\" name=\"your-name\" \/><\/span> <\/label>\n<\/p>\n<p><label> *Email: <span class=\"wpcf7-form-control-wrap\" data-name=\"your-email\"><input size=\"40\" maxlength=\"400\" class=\"wpcf7-form-control wpcf7-email wpcf7-validates-as-required wpcf7-text wpcf7-validates-as-email\" aria-required=\"true\" aria-invalid=\"false\" value=\"\" type=\"email\" name=\"your-email\" \/><\/span> <\/label><br \/>\n<label> *Mobil: <span class=\"wpcf7-form-control-wrap\" data-name=\"tel-942\"><input size=\"10\" maxlength=\"400\" class=\"wpcf7-form-control wpcf7-tel wpcf7-validates-as-required wpcf7-text wpcf7-validates-as-tel\" aria-required=\"true\" aria-invalid=\"false\" placeholder=\"ex: 0720000000\" value=\"\" type=\"tel\" name=\"tel-942\" \/><\/span> <\/label><br \/>\n<label> *Numar participanti: <span class=\"wpcf7-form-control-wrap\" data-name=\"number-552\"><input class=\"wpcf7-form-control wpcf7-number wpcf7-validates-as-required wpcf7-validates-as-number\" aria-required=\"true\" aria-invalid=\"false\" value=\"\" type=\"number\" name=\"number-552\" \/><\/span> <\/label><br \/>\n<label> Firma: <span class=\"wpcf7-form-control-wrap\" data-name=\"your-subject\"><input size=\"40\" maxlength=\"400\" class=\"wpcf7-form-control wpcf7-text\" aria-invalid=\"false\" value=\"\" type=\"text\" name=\"your-subject\" \/><\/span> <\/label>\n<\/p>\n<p><label> Observatii: <span class=\"wpcf7-form-control-wrap\" data-name=\"your-message\"><textarea cols=\"40\" rows=\"10\" maxlength=\"2000\" class=\"wpcf7-form-control wpcf7-textarea\" aria-invalid=\"false\" name=\"your-message\"><\/textarea><\/span> <\/label>\n<\/p>\n<p>Campurile marcate cu * sunt obligatorii!\n<\/p>\n<p><span class=\"wpcf7-form-control-wrap\" data-name=\"acceptance-216\"><span class=\"wpcf7-form-control wpcf7-acceptance\"><span class=\"wpcf7-list-item\"><label><input type=\"checkbox\" name=\"acceptance-216\" value=\"1\" aria-invalid=\"false\" \/><span class=\"wpcf7-list-item-label\">Sunt de acord cu <a href=\"https:\/\/sky-it.ro\/clone\/termeni-si-conditii\/\">termenii si conditiile<\/a> afisate pe site.<\/span><\/label><\/span><\/span><\/span><br \/>\n<div id=\"cf7sr-69f7293a7c5f1\" class=\"cf7sr-g-recaptcha\" data-theme=\"light\" data-type=\"image\" data-size=\"normal\" data-sitekey=\"6LemG9IUAAAAAIVQNEiLTTvj-bLZnZN2NKEw1NDY\"><\/div><span class=\"wpcf7-form-control-wrap cf7sr-recaptcha\" data-name=\"cf7sr-recaptcha\"><input type=\"hidden\" name=\"cf7sr-recaptcha\" value=\"\" class=\"wpcf7-form-control\"><\/span><br \/>\n<input class=\"wpcf7-form-control wpcf7-submit has-spinner\" type=\"submit\" value=\"Trimite\" \/>\n<\/p><p style=\"display: none !important;\" class=\"akismet-fields-container\" data-prefix=\"_wpcf7_ak_\"><label>&#916;<textarea name=\"_wpcf7_ak_hp_textarea\" cols=\"45\" rows=\"8\" maxlength=\"100\"><\/textarea><\/label><input type=\"hidden\" id=\"ak_js_1\" name=\"_wpcf7_ak_js\" value=\"215\"\/><script>document.getElementById( \"ak_js_1\" ).setAttribute( \"value\", ( new Date() ).getTime() );<\/script><\/p><div class=\"wpcf7-response-output\" aria-hidden=\"true\"><\/div>\n<\/form>\n<\/div>\n[vc_separator type=&#8221;transparent&#8221; up=&#8221;46&#8243;][vc_column_text]<\/p>\n<h6>Te-ar putea interesa si:<\/h6>\n<p>[\/vc_column_text][vc_column_text]<div id='1' class='widgets_on_page wop_tiny1  wop_small1  wop_medium1  wop_large1  wop_wide1'>\n\t\t\t<ul><!-- ERROR NO TURBO SIDEBAR FOUND WITH ID wop-1--><\/ul><\/div><!-- widgets_on_page -->[\/vc_column_text][\/vc_column][\/vc_row][vc_row css_animation=&#8221;&#8221; row_type=&#8221;row&#8221; use_row_as_full_screen_section=&#8221;no&#8221; type=&#8221;grid&#8221; angled_section=&#8221;no&#8221; text_align=&#8221;left&#8221; background_image_as_pattern=&#8221;without_pattern&#8221; css=&#8221;.vc_custom_1473086245677{padding-top: 13px !important;padding-bottom: 13px !important;background-color: #ffffff !important;}&#8221;][vc_column]<div class='qode_carousels_holder clearfix'><div class='qode_carousels' data-number-of-visible-items='4'><ul class='slides'><li class='item'><div class=\"carousel_item_holder\"><a itemprop='url' href='#' target='_self'><span class='first_image_holder has_hover_image'><img decoding=\"async\" itemprop=\"image\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/06\/cursuri-excel1-1.png\" alt=\"carousel image\" \/><\/span><span class='second_image_holder has_hover_image'><img decoding=\"async\" itemprop=\"image\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/06\/cursuri-excel-1.png\" alt=\"carousel image\" \/><\/span><\/a><\/div><\/li><li class='item'><div class=\"carousel_item_holder\"><a itemprop='url' href='#' target='_self'><span class='first_image_holder has_hover_image'><img decoding=\"async\" itemprop=\"image\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/06\/cursuri-excel3.png\" alt=\"carousel image\" \/><\/span><span class='second_image_holder has_hover_image'><img decoding=\"async\" itemprop=\"image\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/06\/cursuri-excel2-1.png\" alt=\"carousel image\" \/><\/span><\/a><\/div><\/li><li class='item'><div class=\"carousel_item_holder\"><a itemprop='url' href='#' target='_self'><span class='first_image_holder has_hover_image'><img decoding=\"async\" itemprop=\"image\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/06\/cursuri-excel5.png\" alt=\"carousel image\" \/><\/span><span class='second_image_holder has_hover_image'><img decoding=\"async\" itemprop=\"image\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/06\/cursuri-excel4.png\" alt=\"carousel image\" \/><\/span><\/a><\/div><\/li><li class='item'><div class=\"carousel_item_holder\"><a itemprop='url' href='#' target='_self'><span class='first_image_holder has_hover_image'><img decoding=\"async\" itemprop=\"image\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/06\/cursuri-excel7.png\" alt=\"carousel image\" \/><\/span><span class='second_image_holder has_hover_image'><img decoding=\"async\" itemprop=\"image\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/06\/cursuri-excel6.png\" alt=\"carousel image\" \/><\/span><\/a><\/div><\/li><li class='item'><div class=\"carousel_item_holder\"><a itemprop='url' href='#' target='_self'><span class='first_image_holder has_hover_image'><img decoding=\"async\" itemprop=\"image\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/06\/cursuri-excel9.png\" alt=\"carousel image\" \/><\/span><span class='second_image_holder has_hover_image'><img decoding=\"async\" itemprop=\"image\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/06\/cursuri-excel8.png\" alt=\"carousel image\" \/><\/span><\/a><\/div><\/li><li class='item'><div class=\"carousel_item_holder\"><a itemprop='url' href='#' target='_self'><span class='first_image_holder has_hover_image'><img decoding=\"async\" itemprop=\"image\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/06\/cursuri-excel11.png\" alt=\"carousel image\" \/><\/span><span class='second_image_holder has_hover_image'><img decoding=\"async\" itemprop=\"image\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/06\/cursuri-excel10.png\" alt=\"carousel image\" \/><\/span><\/a><\/div><\/li><li class='item'><div class=\"carousel_item_holder\"><a itemprop='url' href='#' target='_self'><span class='first_image_holder has_hover_image'><img decoding=\"async\" itemprop=\"image\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/06\/cursuri-excel13.png\" alt=\"carousel image\" \/><\/span><span class='second_image_holder has_hover_image'><img decoding=\"async\" itemprop=\"image\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/06\/cursuri-excel12.png\" alt=\"carousel image\" \/><\/span><\/a><\/div><\/li><li class='item'><div class=\"carousel_item_holder\"><a itemprop='url' href='#' target='_self'><span class='first_image_holder has_hover_image'><img decoding=\"async\" itemprop=\"image\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/06\/cursuri-excel15.png\" alt=\"carousel image\" \/><\/span><span class='second_image_holder has_hover_image'><img decoding=\"async\" itemprop=\"image\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/06\/cursuri-excel14.png\" alt=\"carousel image\" \/><\/span><\/a><\/div><\/li><\/ul><\/div><\/div>[\/vc_column][\/vc_row]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>[vc_row css_animation=&#8221;&#8221; row_type=&#8221;row&#8221; use_row_as_full_screen_section=&#8221;no&#8221; type=&#8221;grid&#8221; angled_section=&#8221;no&#8221; text_align=&#8221;left&#8221; background_image_as_pattern=&#8221;without_pattern&#8221; z_index=&#8221;&#8221; padding_top=&#8221;44&#8243; padding_bottom=&#8221;44&#8243;][vc_column width=&#8221;2\/3&#8243;][vc_row_inner row_type=&#8221;row&#8221; type=&#8221;full_width&#8221; text_align=&#8221;left&#8221; css_animation=&#8221;&#8221;][vc_column_inner width=&#8221;1\/3&#8243;][vc_column_text] Durata: 5 zile [\/vc_column_text][\/vc_column_inner][vc_column_inner width=&#8221;1\/3&#8243;][vc_column_text] Pret:\u00a0Solicita oferta! [\/vc_column_text][\/vc_column_inner][vc_column_inner width=&#8221;1\/3&#8243;][vc_column_text] Nivel: intermediar [\/vc_column_text][\/vc_column_inner][\/vc_row_inner][vc_separator type=&#8221;transparent&#8221; up=&#8221;44&#8243;][\/vc_column][vc_column width=&#8221;1\/3&#8243;][vc_row_inner row_type=&#8221;row&#8221; type=&#8221;full_width&#8221; text_align=&#8221;left&#8221; css_animation=&#8221;&#8221;][vc_column_inner][vc_column_text] Formular inregistrare: [\/vc_column_text][\/vc_column_inner][\/vc_row_inner][vc_separator type=&#8221;transparent&#8221; up=&#8221;36&#8243;][vc_separator type=&#8221;transparent&#8221; up=&#8221;46&#8243;][vc_column_text] Te-ar putea&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"full_width.php","meta":{"footnotes":""},"categories":[],"tags":[],"yst_prominent_words":[],"_links":{"self":[{"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/pages\/979"}],"collection":[{"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/comments?post=979"}],"version-history":[{"count":3,"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/pages\/979\/revisions"}],"predecessor-version":[{"id":1775,"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/pages\/979\/revisions\/1775"}],"wp:attachment":[{"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/media?parent=979"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/categories?post=979"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/tags?post=979"},{"taxonomy":"yst_prominent_words","embeddable":true,"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/yst_prominent_words?post=979"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}