[fusion_builder_container background_color=”” background_image=”https://itym.nl/wp-content/uploads/2016/02/meeting-technische-trainingen.jpg” background_parallax=”none” enable_mobile=”no” parallax_speed=”0.3″ background_repeat=”no-repeat” background_position=”left top” video_url=”” video_aspect_ratio=”16:9″ video_webm=”” video_mp4=”” video_ogv=”” video_preview_image=”” overlay_color=”” overlay_opacity=”0.5″ video_mute=”yes” video_loop=”yes” fade=”no” border_size=”0px” border_color=”” border_style=”solid” padding_top=”20″ padding_bottom=”20″ padding_left=”” padding_right=”” hundred_percent=”no” equal_height_columns=”no” hide_on_mobile=”no” menu_anchor=”” class=”” id=””][fusion_builder_row][fusion_builder_column type=”1_1″ background_position=”left top” background_color=”” border_size=”” border_color=”” border_style=”solid” spacing=”yes” background_image=”” background_repeat=”no-repeat” padding=”” margin_top=”0px” margin_bottom=”0px” class=”” id=”” animation_type=”” animation_speed=”0.3″ animation_direction=”left” hide_on_mobile=”no” center_content=”no” min_height=”none”][fusion_title size=”1″ content_align=”center” style_type=”none” sep_color=”” margin_top=”” margin_bottom=”” class=”” id=””]MCSA: SQL 2014 Microsoft Certified Solutions Associate[/fusion_title][/fusion_builder_column][/fusion_builder_row][/fusion_builder_container][fusion_builder_container background_color=”” background_image=”” background_parallax=”none” enable_mobile=”no” parallax_speed=”0.3″ background_repeat=”no-repeat” background_position=”left top” video_url=”” video_aspect_ratio=”16:9″ video_webm=”” video_mp4=”” video_ogv=”” video_preview_image=”” overlay_color=”” overlay_opacity=”0.5″ video_mute=”yes” video_loop=”yes” fade=”no” border_size=”0px” border_color=”” border_style=”” padding_top=”20″ padding_bottom=”20″ padding_left=”” padding_right=”” hundred_percent=”no” equal_height_columns=”no” hide_on_mobile=”no” menu_anchor=”” class=”” id=””][fusion_builder_row][fusion_builder_column type=”1_2″ last=”no” spacing=”yes” center_content=”no” hide_on_mobile=”no” background_color=”” background_image=”” background_repeat=”no-repeat” background_position=”left top” hover_type=”none” link=”” border_position=”all” border_size=”0px” border_color=”” border_style=”” padding=”” margin_top=”” margin_bottom=”” animation_type=”” animation_direction=”” animation_speed=”0.1″ animation_offset=”” class=”” id=””][fusion_text]De Microsoft Certified Solutions Associate (MCSA) ben je als je de drie benodigde certificaten behaald! Ga samen met ITYM op pad naar professionalisering in de IT! Microsoft-technologieën getraind door ITYM en gevalideerd door Microsoft! ITYM Traint je op het nieuwste platform en dat is nu 2014. SQL 2016 komt eraan!

[fusion_separator style_type=”none” top_margin=”20″ bottom_margin=”0″ sep_color=”” border_size=”” icon=”” icon_circle=”” icon_circle_color=”” width=”” alignment=”center” class=”” id=””/]

[fusion_button link=”https://itym.nl/contact/” color=”default” size=”” stretch=”” type=”” shape=”” target=”_self” title=”” gradient_colors=”|” gradient_hover_colors=”|” accent_color=”” accent_hover_color=”” bevel_color=”” border_width=”1px” icon=”” icon_divider=”yes” icon_position=”left” modal=”” animation_type=”0″ animation_direction=”down” animation_speed=”0.1″ animation_offset=”” alignment=”center” class=”” id=””]Aanmelden[/fusion_button][/fusion_text][/fusion_builder_column][fusion_builder_column type=”1_2″ last=”yes” spacing=”yes” center_content=”no” hide_on_mobile=”no” background_color=”” background_image=”” background_repeat=”no-repeat” background_position=”left top” hover_type=”none” link=”” border_position=”all” border_size=”0px” border_color=”” border_style=”” padding=”” margin_top=”” margin_bottom=”” animation_type=”” animation_direction=”” animation_speed=”0.1″ animation_offset=”” class=”” id=””][fusion_slider hover_type=”none” width=”100%” height=”100%” class=”” id=””][fusion_slide type=”image” link=”” linktarget=”_self” lightbox=”yes”]https://itym.nl/wp-content/uploads/2016/04/database-screen-1.jpg[/fusion_slide][fusion_slide type=”image” link=”” linktarget=”_self” lightbox=”yes”]https://itym.nl/wp-content/uploads/2016/04/database-screen-2.jpg[/fusion_slide][/fusion_slider][/fusion_builder_column][fusion_builder_column type=”1_1″ background_position=”left top” background_color=”” border_size=”” border_color=”” border_style=”solid” spacing=”yes” background_image=”” background_repeat=”no-repeat” padding=”” margin_top=”0px” margin_bottom=”0px” class=”” id=”” animation_type=”” animation_speed=”0.3″ animation_direction=”left” hide_on_mobile=”no” center_content=”no” min_height=”none”][fusion_text]This three-day MTA Training course helps you prepare for Microsoft Technology Associate Exam 98-349 and build an understanding of these topics: Operating System Configurations, Installing and Upgrading Client Systems, Managing Applications, Managing Files and Folders, Managing Devices, and Operating System Maintenance. De vijfdaagse MCSA Trainingen helpen je voor te bereiden op Microsoft Certified Solutions Associate: SQL 2014 examens.This course leverages the same content as found in the Microsoft Official Academic Course (MOAC) for this exam. ITYM ITYM maakt gebruik van de Microsoft Official Course (MOC) tijdens de trainingen. Onder begeleiding van door ITYM en Microsoft gecertificeerde trainer leer je de benodigde kennis om het bijbehorende examens te kunnen doen.

ITYM biedt je de volgende trainingen aan voor het behalen van het MCSA SQL 2014:[/fusion_text][/fusion_builder_column][/fusion_builder_row][/fusion_builder_container][fusion_builder_container background_color=”” background_image=”” background_parallax=”none” enable_mobile=”no” parallax_speed=”0.3″ background_repeat=”no-repeat” background_position=”left top” video_url=”” video_aspect_ratio=”16:9″ video_webm=”” video_mp4=”” video_ogv=”” video_preview_image=”” overlay_color=”” overlay_opacity=”0.5″ video_mute=”yes” video_loop=”yes” fade=”no” border_size=”0px” border_color=”” border_style=”” padding_top=”20″ padding_bottom=”20″ padding_left=”” padding_right=”” hundred_percent=”no” equal_height_columns=”no” hide_on_mobile=”no” menu_anchor=”” class=”” id=””][fusion_builder_row][fusion_builder_column type=”1_1″ background_position=”left top” background_color=”” border_size=”” border_color=”” border_style=”solid” spacing=”yes” background_image=”” background_repeat=”no-repeat” padding=”” margin_top=”0px” margin_bottom=”0px” class=”” id=”” animation_type=”” animation_speed=”0.3″ animation_direction=”left” hide_on_mobile=”no” center_content=”no” min_height=”none”][fusion_title size=”2″ content_align=”left” style_type=”none” sep_color=”” margin_top=”” margin_bottom=”” class=”” id=””]MCSA Training 20461: Querying Microsoft SQL Server 2014[/fusion_title][/fusion_builder_column][fusion_builder_column type=”1_1″ background_position=”left top” background_color=”” border_size=”” border_color=”” border_style=”solid” spacing=”yes” background_image=”” background_repeat=”no-repeat” padding=”” margin_top=”0px” margin_bottom=”0px” class=”” id=”” animation_type=”” animation_speed=”0.3″ animation_direction=”left” hide_on_mobile=”no” center_content=”no” min_height=”none”][fusion_title size=”2″ content_align=”left” style_type=”default” sep_color=”” margin_top=”” margin_bottom=”” class=”” id=””]Na het voltooien van deze cursus heb je een goed begrip over[/fusion_title][/fusion_builder_column][fusion_builder_column type=”1_1″ background_position=”left top” background_color=”” border_size=”” border_color=”” border_style=”solid” spacing=”yes” background_image=”” background_repeat=”no-repeat” padding=”” margin_top=”0px” margin_bottom=”0px” class=”” id=”” animation_type=”” animation_speed=”0.3″ animation_direction=”left” hide_on_mobile=”no” center_content=”no” min_height=”none”][fusion_checklist icon=”fa-check” iconcolor=”” circle=”” circlecolor=”” size=”22px” class=”” id=””][fusion_li_item icon=””]Understanding Operating System Configurations write SELECT queries[/fusion_li_item][fusion_li_item icon=””]query multiple tables[/fusion_li_item][fusion_li_item icon=””]sort and filter data[/fusion_li_item][fusion_li_item icon=””]describe the use of data types in SQL Server[/fusion_li_item][fusion_li_item icon=””]modify data using Transact-SQL[/fusion_li_item][fusion_li_item icon=””]use built-in functions[/fusion_li_item][fusion_li_item icon=””]group and aggregate data[/fusion_li_item][fusion_li_item icon=””]use subqueries[/fusion_li_item][fusion_li_item icon=””]use table expressions[/fusion_li_item][fusion_li_item icon=””]use set operators[/fusion_li_item][fusion_li_item icon=””]use window ranking, offset and aggregate functions[/fusion_li_item][fusion_li_item icon=””]implement pivoting and grouping sets[/fusion_li_item][fusion_li_item icon=””]execute stored procedures[/fusion_li_item][fusion_li_item icon=””]program with T-SQL[/fusion_li_item][fusion_li_item icon=””]implement error handling[/fusion_li_item][fusion_li_item icon=””]implement transactions[/fusion_li_item][/fusion_checklist][/fusion_builder_column][/fusion_builder_row][/fusion_builder_container][fusion_builder_container background_color=”” background_image=”” background_parallax=”none” enable_mobile=”no” parallax_speed=”0.3″ background_repeat=”no-repeat” background_position=”left top” video_url=”” video_aspect_ratio=”16:9″ video_webm=”” video_mp4=”” video_ogv=”” video_preview_image=”” overlay_color=”” overlay_opacity=”0.5″ video_mute=”yes” video_loop=”yes” fade=”no” border_size=”0px” border_color=”” border_style=”” padding_top=”20″ padding_bottom=”20″ padding_left=”” padding_right=”” hundred_percent=”no” equal_height_columns=”no” hide_on_mobile=”no” menu_anchor=”” class=”” id=””][fusion_builder_row][fusion_builder_column type=”1_1″ background_position=”left top” background_color=”” border_size=”” border_color=”” border_style=”solid” spacing=”yes” background_image=”” background_repeat=”no-repeat” padding=”” margin_top=”0px” margin_bottom=”0px” class=”” id=”” animation_type=”” animation_speed=”0.3″ animation_direction=”left” hide_on_mobile=”no” center_content=”no” min_height=”none”][fusion_title size=”2″ content_align=”left” style_type=”default” sep_color=”” margin_top=”” margin_bottom=”” class=”” id=””]Tijdens deze training komen de volgende onderwerpen aan bod[/fusion_title][/fusion_builder_column][fusion_builder_column type=”1_1″ background_position=”left top” background_color=”” border_size=”” border_color=”” border_style=”solid” spacing=”yes” background_image=”” background_repeat=”no-repeat” padding=”” margin_top=”0px” margin_bottom=”0px” class=”” id=”” animation_type=”” animation_speed=”0.3″ animation_direction=”left” hide_on_mobile=”no” center_content=”no” min_height=”none”][fusion_checklist icon=”fa-check” iconcolor=”” circle=”” circlecolor=”” size=”22px” class=”” id=””][fusion_li_item icon=””]Module 1: Introduction to Microsoft SQL Server 2014[/fusion_li_item][fusion_li_item icon=””]Module 2: Introduction to T-SQL Querying[/fusion_li_item][fusion_li_item icon=””]Module 3: Writing SELECT queries[/fusion_li_item][fusion_li_item icon=””]Module 4: Querying Multiple tables[/fusion_li_item][fusion_li_item icon=””]Module 5: Sorting and Filtering Data[/fusion_li_item][fusion_li_item icon=””]Module 6: Working with SQL Server 2014 Data Types[/fusion_li_item][fusion_li_item icon=””]Module 7: Using DML to Modify Data[/fusion_li_item][fusion_li_item icon=””]Module 8: Using Built-In Functions[/fusion_li_item][fusion_li_item icon=””]Module 9: Grouping and Aggregating Data[/fusion_li_item][fusion_li_item icon=””]Module 10: Using Subqueries[/fusion_li_item][fusion_li_item icon=””]Module 11: Using Table Expressions[/fusion_li_item][fusion_li_item icon=””]Module 12: Using Set Operators[/fusion_li_item][fusion_li_item icon=””]Module 13: Using Window Ranking, Offset, and Aggregate Functions[/fusion_li_item][fusion_li_item icon=””]Module 14: Pivoting and Grouping Sets[/fusion_li_item][fusion_li_item icon=””]Module 15: Executing Stored Procedures[/fusion_li_item][fusion_li_item icon=””]Module 16: Programming with T-SQL[/fusion_li_item][fusion_li_item icon=””]Module 17: Implementing Error Handling[/fusion_li_item][fusion_li_item icon=””]Module 18: Implementing Transactions[/fusion_li_item][fusion_li_item icon=””]Module 19: Improving Query Performance[/fusion_li_item][fusion_li_item icon=””]Module 20: Querying SQL Server Metadata[/fusion_li_item][/fusion_checklist][/fusion_builder_column][/fusion_builder_row][/fusion_builder_container][fusion_builder_container background_color=”” background_image=”” background_parallax=”none” enable_mobile=”no” parallax_speed=”0.3″ background_repeat=”no-repeat” background_position=”left top” video_url=”” video_aspect_ratio=”16:9″ video_webm=”” video_mp4=”” video_ogv=”” video_preview_image=”” overlay_color=”” overlay_opacity=”0.5″ video_mute=”yes” video_loop=”yes” fade=”no” border_size=”0px” border_color=”” border_style=”” padding_top=”20″ padding_bottom=”20″ padding_left=”” padding_right=”” hundred_percent=”no” equal_height_columns=”no” hide_on_mobile=”no” menu_anchor=”” class=”” id=””][fusion_builder_row][fusion_builder_column type=”1_1″ background_position=”left top” background_color=”” border_size=”” border_color=”” border_style=”solid” spacing=”yes” background_image=”” background_repeat=”no-repeat” padding=”” margin_top=”0px” margin_bottom=”0px” class=”” id=”” animation_type=”” animation_speed=”0.3″ animation_direction=”left” hide_on_mobile=”no” center_content=”no” min_height=”none”][fusion_title size=”2″ content_align=”left” style_type=”none” sep_color=”” margin_top=”” margin_bottom=”” class=”” id=””]Examen en certificaat[/fusion_title][fusion_text]Na afloop van de training ontvangt u van ITYM het bewijs van deelname: “Querying Microsoft SQL Server”. Deze training is een goede voorbereiding op het examen Querying Microsoft SQL Server (70-461).

Ook ITYM gaat mee in de tijd en biedt ook de Onlinetrainingen aan. Je hebt nu dus de keuze om de training te volgen tijdens de klassikale uitleg of via Online MOC. Deze nieuwe vorm van leren geeft je recht om in drie maanden tijd de inhoud eigen te maken! Uiteraard kun je altijd terecht bij een van de leer centrums van ITYM of gewoon lekker thuis op de bank of op je eigen werkplek op kantoor!

[fusion_separator style_type=”none” top_margin=”20″ bottom_margin=”0″ sep_color=”” border_size=”” icon=”” icon_circle=”” icon_circle_color=”” width=”” alignment=”center” class=”” id=””/]

[fusion_button link=”https://itym.nl/contact/” color=”default” size=”” stretch=”” type=”” shape=”” target=”_self” title=”” gradient_colors=”|” gradient_hover_colors=”|” accent_color=”” accent_hover_color=”” bevel_color=”” border_width=”1px” icon=”” icon_divider=”yes” icon_position=”left” modal=”” animation_type=”0″ animation_direction=”down” animation_speed=”0.1″ animation_offset=”” alignment=”center” class=”” id=””]Aanmelden[/fusion_button][/fusion_text][/fusion_builder_column][/fusion_builder_row][/fusion_builder_container][fusion_builder_container background_color=”” background_image=”” background_parallax=”none” enable_mobile=”no” parallax_speed=”0.3″ background_repeat=”no-repeat” background_position=”left top” video_url=”” video_aspect_ratio=”16:9″ video_webm=”” video_mp4=”” video_ogv=”” video_preview_image=”” overlay_color=”” overlay_opacity=”0.5″ video_mute=”yes” video_loop=”yes” fade=”no” border_size=”0px” border_color=”” border_style=”” padding_top=”20″ padding_bottom=”20″ padding_left=”” padding_right=”” hundred_percent=”no” equal_height_columns=”no” hide_on_mobile=”no” menu_anchor=”” class=”” id=””][fusion_builder_row][fusion_builder_column type=”1_1″ background_position=”left top” background_color=”” border_size=”” border_color=”” border_style=”solid” spacing=”yes” background_image=”” background_repeat=”no-repeat” padding=”” margin_top=”0px” margin_bottom=”0px” class=”” id=”” animation_type=”” animation_speed=”0.3″ animation_direction=”left” hide_on_mobile=”no” center_content=”no” min_height=”none”][fusion_title size=”2″ content_align=”left” style_type=”none” sep_color=”” margin_top=”” margin_bottom=”” class=”” id=””]MCSA Training 20462 – Administering Microsoft SQL Server 2014 Databases[/fusion_title][/fusion_builder_column][fusion_builder_column type=”1_1″ background_position=”left top” background_color=”” border_size=”” border_color=”” border_style=”solid” spacing=”yes” background_image=”” background_repeat=”no-repeat” padding=”” margin_top=”0px” margin_bottom=”0px” class=”” id=”” animation_type=”” animation_speed=”0.3″ animation_direction=”left” hide_on_mobile=”no” center_content=”no” min_height=”none”][fusion_title size=”2″ content_align=”left” style_type=”default” sep_color=”” margin_top=”” margin_bottom=”” class=”” id=””]Na het voltooien van deze cursus heb je een goed begrip over[/fusion_title][/fusion_builder_column][fusion_builder_column type=”1_1″ background_position=”left top” background_color=”” border_size=”” border_color=”” border_style=”solid” spacing=”yes” background_image=”” background_repeat=”no-repeat” padding=”” margin_top=”0px” margin_bottom=”0px” class=”” id=”” animation_type=”” animation_speed=”0.3″ animation_direction=”left” hide_on_mobile=”no” center_content=”no” min_height=”none”][fusion_checklist icon=”fa-check” iconcolor=”” circle=”” circlecolor=”” size=”22px” class=”” id=””][fusion_li_item icon=””]plan and install SQL Server 2014[/fusion_li_item][fusion_li_item icon=””]describe system databases, the physical structure of databases, and the most common configuration options related to them[/fusion_li_item][fusion_li_item icon=””]explain the concept of the transaction log and the SQL Server recovery models and implement different backup strategies that are available with SQL Server[/fusion_li_item][fusion_li_item icon=””]back up SQL Server databases[/fusion_li_item][fusion_li_item icon=””]restore SQL Server databases[/fusion_li_item][fusion_li_item icon=””]import and export data by using wizards, the bulk copy utility, and data-tier applications[/fusion_li_item][fusion_li_item icon=””]work with SQL Server security models, logins, users, and contained databases[/fusion_li_item][fusion_li_item icon=””]work with server roles and database roles[/fusion_li_item][fusion_li_item icon=””]use permissions to secure resources[/fusion_li_item][fusion_li_item icon=””]use SQL Server audit and Transparent Data Encryption[/fusion_li_item][fusion_li_item icon=””]work with SQL Server Agent to configure and execute jobs[/fusion_li_item][fusion_li_item icon=””]implement SQL Server Agent security, proxy accounts, and credentials[/fusion_li_item][fusion_li_item icon=””]configure database mail, alerts, and notifications[/fusion_li_item][fusion_li_item icon=””]create database maintenance plans[/fusion_li_item][fusion_li_item icon=””]use SQL Server Profiler, SQL Trace, and Distributed Relay[/fusion_li_item][fusion_li_item icon=””]use Distributed Management Views and configure data collection[/fusion_li_item][/fusion_checklist][/fusion_builder_column][/fusion_builder_row][/fusion_builder_container][fusion_builder_container background_color=”” background_image=”” background_parallax=”none” enable_mobile=”no” parallax_speed=”0.3″ background_repeat=”no-repeat” background_position=”left top” video_url=”” video_aspect_ratio=”16:9″ video_webm=”” video_mp4=”” video_ogv=”” video_preview_image=”” overlay_color=”” overlay_opacity=”0.5″ video_mute=”yes” video_loop=”yes” fade=”no” border_size=”0px” border_color=”” border_style=”” padding_top=”20″ padding_bottom=”20″ padding_left=”” padding_right=”” hundred_percent=”no” equal_height_columns=”no” hide_on_mobile=”no” menu_anchor=”” class=”” id=””][fusion_builder_row][fusion_builder_column type=”1_1″ background_position=”left top” background_color=”” border_size=”” border_color=”” border_style=”solid” spacing=”yes” background_image=”” background_repeat=”no-repeat” padding=”” margin_top=”0px” margin_bottom=”0px” class=”” id=”” animation_type=”” animation_speed=”0.3″ animation_direction=”left” hide_on_mobile=”no” center_content=”no” min_height=”none”][fusion_title size=”2″ content_align=”left” style_type=”default” sep_color=”” margin_top=”” margin_bottom=”” class=”” id=””]Tijdens deze training komen de volgende onderwerpen aan bod[/fusion_title][/fusion_builder_column][fusion_builder_column type=”1_1″ background_position=”left top” background_color=”” border_size=”” border_color=”” border_style=”solid” spacing=”yes” background_image=”” background_repeat=”no-repeat” padding=”” margin_top=”0px” margin_bottom=”0px” class=”” id=”” animation_type=”” animation_speed=”0.3″ animation_direction=”left” hide_on_mobile=”no” center_content=”no” min_height=”none”][fusion_checklist icon=”fa-check” iconcolor=”” circle=”” circlecolor=”” size=”22px” class=”” id=””][fusion_li_item icon=””]Module 1: Introduction to SQL Server 2014 Database Administration[/fusion_li_item][fusion_li_item icon=””]Module 2: Installing and Configuring SQL Server 2014[/fusion_li_item][fusion_li_item icon=””]Module 3: Working with Databases and Storage[/fusion_li_item][fusion_li_item icon=””]Module 4: Planning and Implementing a Backup Strategy[/fusion_li_item][fusion_li_item icon=””]Module 5: Restoring SQL Server 2014 Databases[/fusion_li_item][fusion_li_item icon=””]Module 6: Importing and Exporting Data[/fusion_li_item][fusion_li_item icon=””]Module 7: Monitoring SQL Server 2014[/fusion_li_item][fusion_li_item icon=””]Module 8: Tracing SQL Server Activity[/fusion_li_item][fusion_li_item icon=””]Module 9: Managing SQL Server Security[/fusion_li_item][fusion_li_item icon=””]Module 10: Auditing Data Access and Encrypting Data[/fusion_li_item][fusion_li_item icon=””]Module 11: Performing Ongoing Database Maintenance[/fusion_li_item][fusion_li_item icon=””]Module 12: Automating SQL Server 2014 Management[/fusion_li_item][fusion_li_item icon=””]Module 13: Monitoring SQL Server 2014 by Using Alerts and Notifications[/fusion_li_item][/fusion_checklist][/fusion_builder_column][/fusion_builder_row][/fusion_builder_container][fusion_builder_container background_color=”” background_image=”” background_parallax=”none” enable_mobile=”no” parallax_speed=”0.3″ background_repeat=”no-repeat” background_position=”left top” video_url=”” video_aspect_ratio=”16:9″ video_webm=”” video_mp4=”” video_ogv=”” video_preview_image=”” overlay_color=”” overlay_opacity=”0.5″ video_mute=”yes” video_loop=”yes” fade=”no” border_size=”0px” border_color=”” border_style=”” padding_top=”20″ padding_bottom=”20″ padding_left=”” padding_right=”” hundred_percent=”no” equal_height_columns=”no” hide_on_mobile=”no” menu_anchor=”” class=”” id=””][fusion_builder_row][fusion_builder_column type=”1_1″ background_position=”left top” background_color=”” border_size=”” border_color=”” border_style=”solid” spacing=”yes” background_image=”” background_repeat=”no-repeat” padding=”” margin_top=”0px” margin_bottom=”0px” class=”” id=”” animation_type=”” animation_speed=”0.3″ animation_direction=”left” hide_on_mobile=”no” center_content=”no” min_height=”none”][fusion_title size=”2″ content_align=”left” style_type=”none” sep_color=”” margin_top=”” margin_bottom=”” class=”” id=””]Examen en certificaat[/fusion_title][fusion_text]Na afloop van de training ontvangt u van ITYM het bewijs van deelname: “Administering Microsoft SQL Server 2014 Databases”. Deze training is een goede voorbereiding op het examen Administering Microsoft SQL Server 2014 Databases (70-462).

[fusion_separator style_type=”none” top_margin=”20″ bottom_margin=”0″ sep_color=”” border_size=”” icon=”” icon_circle=”” icon_circle_color=”” width=”” alignment=”center” class=”” id=””/]

[fusion_button link=”https://itym.nl/contact/” color=”default” size=”” stretch=”” type=”” shape=”” target=”_self” title=”” gradient_colors=”|” gradient_hover_colors=”|” accent_color=”” accent_hover_color=”” bevel_color=”” border_width=”1px” icon=”” icon_divider=”yes” icon_position=”left” modal=”” animation_type=”0″ animation_direction=”down” animation_speed=”0.1″ animation_offset=”” alignment=”center” class=”” id=””]Aanmelden[/fusion_button][/fusion_text][/fusion_builder_column][/fusion_builder_row][/fusion_builder_container][fusion_builder_container background_color=”” background_image=”” background_parallax=”none” enable_mobile=”no” parallax_speed=”0.3″ background_repeat=”no-repeat” background_position=”left top” video_url=”” video_aspect_ratio=”16:9″ video_webm=”” video_mp4=”” video_ogv=”” video_preview_image=”” overlay_color=”” overlay_opacity=”0.5″ video_mute=”yes” video_loop=”yes” fade=”no” border_size=”0px” border_color=”” border_style=”” padding_top=”20″ padding_bottom=”20″ padding_left=”” padding_right=”” hundred_percent=”no” equal_height_columns=”no” hide_on_mobile=”no” menu_anchor=”” class=”” id=””][fusion_builder_row][fusion_builder_column type=”1_1″ background_position=”left top” background_color=”” border_size=”” border_color=”” border_style=”solid” spacing=”yes” background_image=”” background_repeat=”no-repeat” padding=”” margin_top=”0px” margin_bottom=”0px” class=”” id=”” animation_type=”” animation_speed=”0.3″ animation_direction=”left” hide_on_mobile=”no” center_content=”no” min_height=”none”][fusion_title size=”2″ content_align=”left” style_type=”none” sep_color=”” margin_top=”” margin_bottom=”” class=”” id=””]MCSA Training 20463D: Implementing a Data Warehouse with Microsoft® SQL Server® 2014[/fusion_title][/fusion_builder_column][fusion_builder_column type=”1_1″ background_position=”left top” background_color=”” border_size=”” border_color=”” border_style=”solid” spacing=”yes” background_image=”” background_repeat=”no-repeat” padding=”” margin_top=”0px” margin_bottom=”0px” class=”” id=”” animation_type=”” animation_speed=”0.3″ animation_direction=”left” hide_on_mobile=”no” center_content=”no” min_height=”none”][fusion_title size=”2″ content_align=”left” style_type=”default” sep_color=”” margin_top=”” margin_bottom=”” class=”” id=””]Na het voltooien van deze cursus heb je een goed begrip over[/fusion_title][/fusion_builder_column][fusion_builder_column type=”1_1″ background_position=”left top” background_color=”” border_size=”” border_color=”” border_style=”solid” spacing=”yes” background_image=”” background_repeat=”no-repeat” padding=”” margin_top=”0px” margin_bottom=”0px” class=”” id=”” animation_type=”” animation_speed=”0.3″ animation_direction=”left” hide_on_mobile=”no” center_content=”no” min_height=”none”][fusion_checklist icon=”fa-check” iconcolor=”” circle=”” circlecolor=”” size=”22px” class=”” id=””][fusion_li_item icon=””]Describe data warehouse concepts and architecture considerations[/fusion_li_item][fusion_li_item icon=””]Select an appropriate hardware platform for a data warehouse[/fusion_li_item][fusion_li_item icon=””]Design and implement a data warehouse[/fusion_li_item][fusion_li_item icon=””]Implement Data Flow in an SSIS Package[/fusion_li_item][fusion_li_item icon=””]Implement Control Flow in an SSIS Package[/fusion_li_item][fusion_li_item icon=””]Debug and Troubleshoot SSIS packages[/fusion_li_item][fusion_li_item icon=””]Implement an ETL solution that supports incremental data extraction[/fusion_li_item][fusion_li_item icon=””]Implement an ETL solution that supports incremental data loading[/fusion_li_item][fusion_li_item icon=””]Implement data cleansing by using Microsoft Data Quality Services[/fusion_li_item][fusion_li_item icon=””]Implement Master Data Services to enforce data integrity[/fusion_li_item][fusion_li_item icon=””]Extend SSIS with custom scripts and components[/fusion_li_item][fusion_li_item icon=””]Deploy and Configure SSIS packages[/fusion_li_item][fusion_li_item icon=””]Describe how BI solutions can consume data from the data warehouse[/fusion_li_item][/fusion_checklist][/fusion_builder_column][/fusion_builder_row][/fusion_builder_container][fusion_builder_container background_color=”” background_image=”” background_parallax=”none” enable_mobile=”no” parallax_speed=”0.3″ background_repeat=”no-repeat” background_position=”left top” video_url=”” video_aspect_ratio=”16:9″ video_webm=”” video_mp4=”” video_ogv=”” video_preview_image=”” overlay_color=”” overlay_opacity=”0.5″ video_mute=”yes” video_loop=”yes” fade=”no” border_size=”0px” border_color=”” border_style=”” padding_top=”20″ padding_bottom=”20″ padding_left=”” padding_right=”” hundred_percent=”no” equal_height_columns=”no” hide_on_mobile=”no” menu_anchor=”” class=”” id=””][fusion_builder_row][fusion_builder_column type=”1_1″ background_position=”left top” background_color=”” border_size=”” border_color=”” border_style=”solid” spacing=”yes” background_image=”” background_repeat=”no-repeat” padding=”” margin_top=”0px” margin_bottom=”0px” class=”” id=”” animation_type=”” animation_speed=”0.3″ animation_direction=”left” hide_on_mobile=”no” center_content=”no” min_height=”none”][fusion_title size=”2″ content_align=”left” style_type=”default” sep_color=”” margin_top=”” margin_bottom=”” class=”” id=””]Tijdens deze training komen de volgende onderwerpen aan bod[/fusion_title][/fusion_builder_column][fusion_builder_column type=”1_1″ background_position=”left top” background_color=”” border_size=”” border_color=”” border_style=”solid” spacing=”yes” background_image=”” background_repeat=”no-repeat” padding=”” margin_top=”0px” margin_bottom=”0px” class=”” id=”” animation_type=”” animation_speed=”0.3″ animation_direction=”left” hide_on_mobile=”no” center_content=”no” min_height=”none”][fusion_checklist icon=”fa-check” iconcolor=”” circle=”” circlecolor=”” size=”22px” class=”” id=””][fusion_li_item icon=””]Module 1: Introduction to Data Warehousing[/fusion_li_item][fusion_li_item icon=””]Module 2: Planning Data Warehouse Infrastructure[/fusion_li_item][fusion_li_item icon=””]Module 3: Designing and Implementing a Data Warehouse[/fusion_li_item][fusion_li_item icon=””]Module 4: Creating an ETL Solution with SSIS[/fusion_li_item][fusion_li_item icon=””]Module 5: Implementing Control Flow in an SSIS Package[/fusion_li_item][fusion_li_item icon=””]Module 6: Debugging and Troubleshooting SSIS Packages[/fusion_li_item][fusion_li_item icon=””]Module 7: Implementing a Data Extraction Solution[/fusion_li_item][fusion_li_item icon=””]Module 8: Loading Data into a Data Warehouse[/fusion_li_item][fusion_li_item icon=””]Module 9: Enforcing Data Quality[/fusion_li_item][fusion_li_item icon=””]Module 10: Master Data Services[/fusion_li_item][fusion_li_item icon=””]Module 11: Extending SQL Server Integration Services[/fusion_li_item][fusion_li_item icon=””]Module 12: Deploying and Configuring SSIS Packages[/fusion_li_item][fusion_li_item icon=””]Module 13: Consuming Data in a Data Warehouse[/fusion_li_item][/fusion_checklist][/fusion_builder_column][/fusion_builder_row][/fusion_builder_container][fusion_builder_container background_color=”” background_image=”” background_parallax=”none” enable_mobile=”no” parallax_speed=”0.3″ background_repeat=”no-repeat” background_position=”left top” video_url=”” video_aspect_ratio=”16:9″ video_webm=”” video_mp4=”” video_ogv=”” video_preview_image=”” overlay_color=”” overlay_opacity=”0.5″ video_mute=”yes” video_loop=”yes” fade=”no” border_size=”0px” border_color=”” border_style=”” padding_top=”20″ padding_bottom=”20″ padding_left=”” padding_right=”” hundred_percent=”no” equal_height_columns=”no” hide_on_mobile=”no” menu_anchor=”” class=”” id=””][fusion_builder_row][fusion_builder_column type=”1_1″ background_position=”left top” background_color=”” border_size=”” border_color=”” border_style=”solid” spacing=”yes” background_image=”” background_repeat=”no-repeat” padding=”” margin_top=”0px” margin_bottom=”0px” class=”” id=”” animation_type=”” animation_speed=”0.3″ animation_direction=”left” hide_on_mobile=”no” center_content=”no” min_height=”none”][fusion_title size=”2″ content_align=”left” style_type=”none” sep_color=”” margin_top=”” margin_bottom=”” class=”” id=””]Examen en certificaat[/fusion_title][fusion_text]Na afloop van de training ontvangt u van ITYM het bewijs van deelname: “Implementing a Data Warehouse with Microsoft® SQL Server® 2014”. Deze training is een goede voorbereiding op het examen Implementing a Data Warehouse with Microsoft® SQL Server® 2014 (70-463).

Ook ITYM gaat mee in de tijd en biedt ook de Onlinetrainingen aan. Je hebt nu dus de keuze om de training te volgen tijdens de klassikale uitleg of via Online MOC. Deze nieuwe vorm van leren geeft je recht om in drie maanden tijd de inhoud eigen te maken! Uiteraard kun je altijd terecht bij een van de leer centrums van ITYM of gewoon lekker thuis op de bank of op je eigen werkplek op kantoor!

Behaal de drie examens en je hebt het MCSA-certificaat op zak!

[fusion_separator style_type=”none” top_margin=”20″ bottom_margin=”0″ sep_color=”” border_size=”” icon=”” icon_circle=”” icon_circle_color=”” width=”” alignment=”center” class=”” id=””/]

[fusion_button link=”https://itym.nl/contact/” color=”default” size=”” stretch=”” type=”” shape=”” target=”_self” title=”” gradient_colors=”|” gradient_hover_colors=”|” accent_color=”” accent_hover_color=”” bevel_color=”” border_width=”1px” icon=”” icon_divider=”yes” icon_position=”left” modal=”” animation_type=”0″ animation_direction=”down” animation_speed=”0.1″ animation_offset=”” alignment=”center” class=”” id=””]Aanmelden[/fusion_button][/fusion_text][/fusion_builder_column][/fusion_builder_row][/fusion_builder_container]