[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=””]Microsoft T-SQL:[/fusion_title][fusion_text]

Querying databases vanaf de basis

[/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_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]In deze ITYM training Microsoft T-SQL krijgt u een grondige kennis van de taal Transact-SQL. Die stelt u in staat om complexe databases door te spitten. Eveneens ontdekt u hoe u ook met slimme queries de belasting op een database kunt beperken. Uw winst? De performance van applicaties verbetert!

[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/aanmelden/” 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/03/microsoft-tsql-training-1.jpg[/fusion_slide][fusion_slide type=”image” link=”” linktarget=”_self” lightbox=”yes”]https://itym.nl/wp-content/uploads/2016/03/microsoft-sharepoint-designer-training-3.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]Als u graag op een makkelijke manier data wilt opvragen uit een relationele database, is T-SQL ideaal. Dit staat voor Transact Structured Query Language. U kunt hier ook gegevens mee aanpassen. ANSI SQL is de populairste gestandaardiseerde databasetaal en tegenwoordig niet meer weg te denken bij het gebruik van relationele databases. Ook kunt u SQL gebruiken om data te manipuleren en tabelstructuren aan te passen. Altijd verbaasd hoe die collega de juiste informatie in een rapport tevoorschijn tovert? Dan is dit de training voor u![/fusion_text][/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=”none” sep_color=”” margin_top=”” margin_bottom=”” class=”” id=””]Ontwikkel u samen met ITYM tot dé expert in uw organisatie[/fusion_title][fusion_text]In deze compacte training van ITYM ontwikkelt u brede kennis en vaardigheden omtrent T-SQL. Databases zijn cruciaal voor uw bedrijf. Omdat alle cruciale data hierin wordt opgeslagen, is het zaak dat u goed leert hoe u de juiste informatie naar boven krijgt. Tijdens de ITYM training T-SQL behandelt de ervaren ITYM database trainer de theorie en laat hij diverse demo’s zien. Deze ITYM training is een ideale opstap voor professionals die de ambitie hebben zich te ontwikkelen met de focus op databasebeheer en databaseontwikkeling.[/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=””]Deze onderdelen komen aan bod tijdens deze ITYM training[/fusion_title][fusion_separator style_type=”single solid” top_margin=”” bottom_margin=”” sep_color=”” border_size=”” icon=”” icon_circle=”” icon_circle_color=”” width=”” alignment=”center” class=”” id=””/][/fusion_builder_column][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_title size=”3″ content_align=”left” style_type=”none” sep_color=”” margin_top=”” margin_bottom=”” class=”” id=””]Inleiding in SQL[/fusion_title][fusion_checklist icon=”fa-check” iconcolor=”” circle=”” circlecolor=”” size=”22px” class=”” id=””][fusion_li_item icon=””]Basisprincipes[/fusion_li_item][fusion_li_item icon=””]Datatypes[/fusion_li_item][fusion_li_item icon=””]Sleutels[/fusion_li_item][/fusion_checklist][/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_title size=”3″ content_align=”left” style_type=”none” sep_color=”” margin_top=”” margin_bottom=”” class=”” id=””]Gegevens[/fusion_title][fusion_checklist icon=”fa-check” iconcolor=”” circle=”” circlecolor=”” size=”22px” class=”” id=””][fusion_li_item icon=””]Gegevens opvragen[/fusion_li_item][fusion_li_item icon=””]Gegevens sorteren[/fusion_li_item][fusion_li_item icon=””]Gegevens filteren[/fusion_li_item][fusion_li_item icon=””]Geavanceerde filteringen[/fusion_li_item][fusion_li_item icon=””]Filteren met behulp van wildcards[/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_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_title size=”3″ content_align=”left” style_type=”none” sep_color=”” margin_top=”” margin_bottom=”” class=”” id=””]Geavanceerd[/fusion_title][fusion_checklist icon=”fa-check” iconcolor=”” circle=”” circlecolor=”” size=”22px” class=”” id=””][fusion_li_item icon=””]Berekende velden[/fusion_li_item][fusion_li_item icon=””]Gegevens aanpassen met functies[/fusion_li_item][fusion_li_item icon=””]Gegevens samenvatten[/fusion_li_item][fusion_li_item icon=””]Groeperen van gegevens[/fusion_li_item][fusion_li_item icon=””]Werken met subquery’s[/fusion_li_item][/fusion_checklist][/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_title size=”3″ content_align=”left” style_type=”none” sep_color=”” margin_top=”” margin_bottom=”” class=”” id=””]Joins[/fusion_title][fusion_checklist icon=”fa-check” iconcolor=”” circle=”” circlecolor=”” size=”22px” class=”” id=””][fusion_li_item icon=””]Combineren van gegevens uit meerdere tabellen met joining[/fusion_li_item][fusion_li_item icon=””]Geavanceerde Joins[/fusion_li_item][fusion_li_item icon=””]Query’s combineren[/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_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_title size=”3″ content_align=”left” style_type=”none” sep_color=”” margin_top=”” margin_bottom=”” class=”” id=””]Data[/fusion_title][fusion_checklist icon=”fa-check” iconcolor=”” circle=”” circlecolor=”” size=”22px” class=”” id=””][fusion_li_item icon=””]Gegevens toevoegen[/fusion_li_item][fusion_li_item icon=””]Gegevens aanpassen en verwijderen[/fusion_li_item][/fusion_checklist][/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_title size=”3″ content_align=”left” style_type=”none” sep_color=”” margin_top=”” margin_bottom=”” class=”” id=””]Rapporten maken[/fusion_title][fusion_checklist icon=”fa-check” iconcolor=”” circle=”” circlecolor=”” size=”22px” class=”” id=””][fusion_li_item icon=””]De Rapport Wizard[/fusion_li_item][fusion_li_item icon=””]Een rapport layout maken[/fusion_li_item][fusion_li_item icon=””]Weergave eigenschappen veranderen[/fusion_li_item][fusion_li_item icon=””]Sorteren/Groeperen[/fusion_li_item][fusion_li_item icon=””]Berekende velden maken[/fusion_li_item][fusion_li_item icon=””]Een rapport afdrukken[/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_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_title size=”3″ content_align=”left” style_type=”none” sep_color=”” margin_top=”” margin_bottom=”” class=”” id=””]Queries uitvoeren[/fusion_title][fusion_checklist icon=”fa-check” iconcolor=”” circle=”” circlecolor=”” size=”22px” class=”” id=””][fusion_li_item icon=””]Een selectie query maken[/fusion_li_item][fusion_li_item icon=””]Gegevens sorteren[/fusion_li_item][fusion_li_item icon=””]Criteria definiëren[/fusion_li_item][fusion_li_item icon=””]Meerdere criteria gebruiken: EN/OF[/fusion_li_item][fusion_li_item icon=””]Een berekening maken in een query[/fusion_li_item][fusion_li_item icon=””]De Query wizard gebruiken[/fusion_li_item][/fusion_checklist][/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_title size=”3″ content_align=”left” style_type=”none” sep_color=”” margin_top=”” margin_bottom=”” class=”” id=””]Importeren en exporteren[/fusion_title][fusion_checklist icon=”fa-check” iconcolor=”” circle=”” circlecolor=”” size=”22px” class=”” id=””][fusion_li_item icon=””]Exporteren naar Excel[/fusion_li_item][fusion_li_item icon=””]Een Excel werkblad importeren[/fusion_li_item][fusion_li_item icon=””]Met tekstbestanden werken[/fusion_li_item][fusion_li_item icon=””]Met HTML werken[/fusion_li_item][fusion_li_item icon=””]Een database bestand importeren[/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_text]Uiteraard presenteert uw door Itym gecertificeerde trainer voldoende Praktische oefeningen die goed aansluiten op uw praktijksituatie.[/fusion_text][/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=”none” sep_color=”” margin_top=”” margin_bottom=”” class=”” id=””]Ervaren en door Microsoft gecertificeerde trainer[/fusion_title][fusion_text]Een ervaren en door Microsoft gecertificeerde trainer begeleidt u namens ITYM tijdens de training Microsoft SQL. U ontvangt dus kwaliteitskennis uit de eerste hand.[/fusion_text][/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=”none” sep_color=”” margin_top=”” margin_bottom=”” class=”” id=””]Altijd de locatie die u past[/fusion_title][fusion_text]Als u dat wilt, geven wij deze training inhouse bij u. Aanvullende leerdoelen vanuit uw organisatie zijn daarvoor prima bespreekbaar. Eveneens geven wij deze training regelmatig op een van onze landelijke trainingslocaties. U kiest met ITYM wat U het beste past.[/fusion_text][/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=”none” sep_color=”” margin_top=”” margin_bottom=”” class=”” id=””]Alvast reserveren?[/fusion_title][fusion_text]Neemt u daartoe contact op met ons via onderstaande knop.

[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/aanmelden/” 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]