[av_section min_height=’custom’ min_height_pc=’25’ min_height_px=’230px’ padding=’default’ custom_margin=’0px’ custom_margin_sync=’true’ color=’main_color’ background=’bg_color’ custom_bg=” background_gradient_color1=” background_gradient_color2=” background_gradient_direction=’diagonal_tb’ src=’https://kriesi.at/themes/enfold-law/wp-content/uploads/sites/78/2018/05/hero-skyscraper.jpg’ attachment=’827′ attachment_size=’full’ attach=’scroll’ position=’center center’ repeat=’stretch’ video=” video_ratio=’16:9′ overlay_enable=’aviaTBoverlay_enable’ overlay_opacity=’0.7′ overlay_color=’#084a79′ overlay_pattern=” overlay_custom_pattern=” shadow=’no-border-styling’ bottom_border=’no-border-styling’ bottom_border_diagonal_color=’#333333′ bottom_border_diagonal_direction=” bottom_border_style=” custom_arrow_bg=” id=” custom_class=” template_class=” aria_label=” av_element_hidden_in_editor=’0′ av_uid=” sc_version=’1.0′]

[av_one_full first min_height=” vertical_alignment=’av-align-top’ space=” custom_margin=’aviaTBcustom_margin’ margin=’0px’ margin_sync=’true’ link=” linktarget=” link_hover=” padding=’0px’ padding_sync=’true’ border=” border_color=” radius=’0px’ radius_sync=’true’ background=’bg_color’ background_color=” background_gradient_color1=” background_gradient_color2=” background_gradient_direction=’vertical’ src=” attachment=” attachment_size=” background_position=’top left’ background_repeat=’no-repeat’ animation=’left-to-right’ mobile_breaking=” mobile_display=” av_uid=”]

[av_heading heading=’Querying Database Using Microsoft Sql Server’ tag=’h2′ style=’blockquote modern-quote’ subheading_active=’subheading_below’ show_icon=” icon=’ue800′ font=’entypo-fontello’ size=’4vw’ av-medium-font-size-title=” av-small-font-size-title=” av-mini-font-size-title=” subheading_size=’18’ av-medium-font-size=” av-small-font-size=” av-mini-font-size=” icon_size=” av-medium-font-size-1=” av-small-font-size-1=” av-mini-font-size-1=” color=’custom-color-heading’ custom_font=’#ffffff’ icon_color=” margin=’0′ margin_sync=’true’ padding=’0′ icon_padding=’10’ link=” link_target=” id=” custom_class=” template_class=” av_uid=’av-ku413y4a’ sc_version=’1.0′ admin_preview_bg=’rgb(34, 34, 34)’]
( Duration 2 Months )
[/av_heading]

[/av_one_full][av_two_fifth first min_height=” vertical_alignment=’av-align-top’ space=” custom_margin=’aviaTBcustom_margin’ margin=’0px’ margin_sync=’true’ link=” linktarget=” link_hover=” padding=’0px’ padding_sync=’true’ border=” border_color=” radius=’0px’ radius_sync=’true’ background=’bg_color’ background_color=” background_gradient_color1=” background_gradient_color2=” background_gradient_direction=’vertical’ src=” attachment=” attachment_size=” background_position=’top left’ background_repeat=’no-repeat’ animation=’left-to-right’ mobile_breaking=” mobile_display=” av_uid=”]

[av_textblock size=’22’ av-medium-font-size=” av-small-font-size=” av-mini-font-size=” font_color=’custom’ color=’#ffffff’ id=” custom_class=” template_class=” av_uid=” sc_version=’1.0′ admin_preview_bg=”]

Online Training

Rs. 27,500 *100 days access

Classroom Training

Rs. 27,500 *100 days access
[/av_textblock]

[/av_two_fifth][av_one_third min_height=” vertical_alignment=’av-align-top’ space=” custom_margin=’aviaTBcustom_margin’ margin=’0px’ margin_sync=’true’ link=” linktarget=” link_hover=” padding=’0px’ padding_sync=’true’ border=” border_color=” radius=’0px’ radius_sync=’true’ background=’bg_color’ background_color=” background_gradient_color1=” background_gradient_color2=” background_gradient_direction=’vertical’ src=” attachment=” attachment_size=” background_position=’top left’ background_repeat=’no-repeat’ animation=’left-to-right’ mobile_breaking=” mobile_display=” av_uid=”]

[av_hr class=’custom’ icon_select=’no’ icon=’ue808′ font=’entypo-fontello’ position=’center’ shadow=’no-shadow’ height=’50’ custom_border=’av-border-none’ custom_width=’50px’ custom_margin_top=’10px’ custom_margin_bottom=’10px’ custom_border_color=” custom_icon_color=” id=” custom_class=” template_class=” av_uid=” sc_version=’1.0′ admin_preview_bg=”]

[av_textblock size=” av-medium-font-size=” av-small-font-size=” av-mini-font-size=” font_color=’custom’ color=’#ffffff’ id=” custom_class=” template_class=” av_uid=’av-ku41f1vq’ sc_version=’1.0′ admin_preview_bg=”]

[/av_textblock]

[/av_one_third][av_one_fourth min_height=” vertical_alignment=’av-align-top’ space=” custom_margin=’aviaTBcustom_margin’ margin=’0px’ margin_sync=’true’ link=” linktarget=” link_hover=” padding=’0px’ padding_sync=’true’ border=” border_color=” radius=’0px’ radius_sync=’true’ background=’bg_color’ background_color=” background_gradient_color1=” background_gradient_color2=” background_gradient_direction=’vertical’ src=” attachment=” attachment_size=” background_position=’top left’ background_repeat=’no-repeat’ animation=’left-to-right’ mobile_breaking=” mobile_display=” av_uid=”]

[av_hr class=’custom’ icon_select=’no’ icon=’ue808′ font=’entypo-fontello’ position=’center’ shadow=’no-shadow’ height=’50’ custom_border=’av-border-none’ custom_width=’50px’ custom_margin_top=’10px’ custom_margin_bottom=’10px’ custom_border_color=” custom_icon_color=” id=” custom_class=” template_class=” av_uid=” sc_version=’1.0′ admin_preview_bg=”]

[av_textblock size=” av-medium-font-size=” av-small-font-size=” av-mini-font-size=” font_color=’custom’ color=’#ffffff’ id=” custom_class=” template_class=” av_uid=” sc_version=’1.0′ admin_preview_bg=”]

  • Get Certification
  • Expert Educators
  • Flexible Schedule
  • 24×7 Tech Support

[/av_textblock]

[av_textblock size=” av-medium-font-size=” av-small-font-size=” av-mini-font-size=” font_color=’custom’ color=’#ffffff’ id=” custom_class=” template_class=” av_uid=” sc_version=’1.0′ admin_preview_bg=”]

[/av_textblock]

[/av_one_fourth][/av_section][av_section min_height=” min_height_pc=’25’ min_height_px=’500px’ padding=’default’ margin=” custom_margin=’0px’ color=’main_color’ background=’bg_color’ custom_bg=” background_gradient_color1=” background_gradient_color2=” background_gradient_direction=’vertical’ src=” attach=’scroll’ position=’top left’ repeat=’no-repeat’ video=” video_ratio=’16:9′ video_mobile_disabled=” overlay_enable=” overlay_opacity=’0.5′ overlay_color=” overlay_pattern=” overlay_custom_pattern=” shadow=’no-border-styling’ bottom_border=’no-border-styling’ bottom_border_diagonal_color=’#333333′ bottom_border_diagonal_direction=” bottom_border_style=” scroll_down=” custom_arrow_bg=” av-desktop-hide=” av-medium-hide=” av-small-hide=” av-mini-hide=” id=” custom_class=” template_class=” aria_label=” av_element_hidden_in_editor=’0′ av_uid=” sc_version=’1.0′]

[av_one_half first min_height=” vertical_alignment=’av-align-top’ space=” row_boxshadow=” row_boxshadow_color=” row_boxshadow_width=’10’ custom_margin=” margin=’0px’ mobile_breaking=” border=” border_color=” radius=’0px’ padding=’0px’ column_boxshadow=” column_boxshadow_color=” column_boxshadow_width=’10’ background=’bg_color’ background_color=” background_gradient_color1=” background_gradient_color2=” background_gradient_direction=’vertical’ src=” background_position=’top left’ background_repeat=’no-repeat’ highlight=” highlight_size=” animation=” link=” linktarget=” link_hover=” title_attr=” alt_attr=” mobile_display=” id=” custom_class=” template_class=” aria_label=” av_uid=” sc_version=’1.0′]

[av_textblock size=” av-medium-font-size=” av-small-font-size=” av-mini-font-size=” font_color=” color=” id=” custom_class=” template_class=” av_uid=’av-ku415mvg’ sc_version=’1.0′ admin_preview_bg=”]

Introduction to MS SQL Server

  • SQL Server Management Studio
  • Components and services provided
  • Integration with .NET Framework

Retrieving Data using Select Statement

  • Data types,
  • Retrieving specific column data
  • Retrieving specific row data
  • Using String and numeric function
  • Using aggregate and grouping function

[/av_textblock]

[/av_one_half][av_one_half min_height=” vertical_alignment=’av-align-top’ space=” row_boxshadow=” row_boxshadow_color=” row_boxshadow_width=’10’ custom_margin=” margin=’0px’ mobile_breaking=” border=” border_color=” radius=’0px’ padding=’0px’ column_boxshadow=” column_boxshadow_color=” column_boxshadow_width=’10’ background=’bg_color’ background_color=” background_gradient_color1=” background_gradient_color2=” background_gradient_direction=’vertical’ src=” background_position=’top left’ background_repeat=’no-repeat’ highlight=” highlight_size=” animation=” link=” linktarget=” link_hover=” title_attr=” alt_attr=” mobile_display=” id=” custom_class=” template_class=” aria_label=” av_uid=” sc_version=’1.0′]

[av_image src=’https://softbravo.com/institute/wp-content/uploads/2021/08/pexels-fauxels-3184296-1030×686.jpg’ attachment=’1098′ attachment_size=’large’ copyright=” caption=” styling=” align=’center’ font_size=” overlay_opacity=’0.4′ overlay_color=’#000000′ overlay_text_color=’#ffffff’ animation=’no-animation’ hover=” appearance=” link=” target=” title_attr=” alt_attr=” lazy_loading=’disabled’ id=” custom_class=” template_class=” av_element_hidden_in_editor=’0′ av_uid=” sc_version=’1.0′ admin_preview_bg=”][/av_image]

[/av_one_half][/av_section][av_section min_height=” min_height_pc=’25’ min_height_px=’500px’ padding=’default’ custom_margin=’0px’ custom_margin_sync=’true’ color=’main_color’ background=’bg_color’ custom_bg=’#f2f2f2′ background_gradient_color1=” background_gradient_color2=” background_gradient_direction=’vertical’ src=” attachment=” attachment_size=” attach=’scroll’ position=’top left’ repeat=’no-repeat’ video=” video_ratio=’16:9′ overlay_opacity=’0.5′ overlay_color=” overlay_pattern=” overlay_custom_pattern=” shadow=’no-border-styling’ bottom_border=’no-border-styling’ bottom_border_diagonal_color=’#333333′ bottom_border_diagonal_direction=” bottom_border_style=” custom_arrow_bg=” id=” custom_class=” template_class=” aria_label=” av_element_hidden_in_editor=’0′ av_uid=” sc_version=’1.0′]

[av_one_full first min_height=” vertical_alignment=’av-align-top’ space=” row_boxshadow=” row_boxshadow_color=” row_boxshadow_width=’10’ custom_margin=” margin=’0px’ mobile_breaking=” border=” border_color=” radius=’0px’ padding=’0px’ column_boxshadow=” column_boxshadow_color=” column_boxshadow_width=’10’ background=’bg_color’ background_color=” background_gradient_color1=” background_gradient_color2=” background_gradient_direction=’vertical’ src=” background_position=’top left’ background_repeat=’no-repeat’ highlight=” highlight_size=” animation=” link=” linktarget=” link_hover=” title_attr=” alt_attr=” mobile_display=” id=” custom_class=” template_class=” aria_label=” av_uid=” sc_version=’1.0′]

[av_textblock size=” av-medium-font-size=” av-small-font-size=” av-mini-font-size=” font_color=’custom’ color=’#000000′ id=” custom_class=” template_class=” av_uid=’av-ku41dg5g’ sc_version=’1.0′ admin_preview_bg=”]

Courses details

Pre-requisite For The Course: Knowledge of any Operating System
[/av_textblock]

[/av_one_full][av_one_full first min_height=” vertical_alignment=’av-align-top’ space=” row_boxshadow=” row_boxshadow_color=” row_boxshadow_width=’10’ custom_margin=” margin=’0px’ mobile_breaking=” border=” border_color=” radius=’0px’ padding=’0px’ column_boxshadow=” column_boxshadow_color=” column_boxshadow_width=’10’ background=’bg_color’ background_color=” background_gradient_color1=” background_gradient_color2=” background_gradient_direction=’vertical’ src=” background_position=’top left’ background_repeat=’no-repeat’ highlight=” highlight_size=” animation=” link=” linktarget=” link_hover=” title_attr=” alt_attr=” mobile_display=” id=” custom_class=” template_class=” aria_label=” av_uid=” sc_version=’1.0′]

[av_toggle_container faq_markup=” initial=’0′ mode=’accordion’ sort=” styling=” colors=” font_color=” background_color=” border_color=” colors_current=” font_color_current=” background_current=” background_color_current=” background_gradient_current_color1=” background_gradient_current_color2=” background_gradient_current_direction=’vertical’ hover_colors=” hover_background_color=” hover_font_color=” alb_description=” id=” custom_class=” template_class=” av_uid=’av-ku41d15t’ sc_version=’1.0′]
[av_toggle title=’Querying Multiple Tables and Subquery’ tags=” custom_id=” av_uid=’av-ku4188un’ sc_version=’1.0′]

  • Querying data by using different Joins
  • Using inner, outer, cross, self and equi-joins
  • Retrieving data using subqueries
  • Using various subquery operators
  • Using correlated subqueries

[/av_toggle]
[av_toggle title=’ Managing Databases’ tags=” custom_id=” av_uid=’av-ku418q4d’ sc_version=’1.0′]

  • Managing Databases and System Database
  • Creating Altering Dropping Databases

[/av_toggle]
[av_toggle title=’Managing Tables’ tags=” custom_id=” av_uid=’av-ku4196va’ sc_version=’1.0′]

  • Creating, Altering and Dropping Tables
  • Implementing Data Integrity using
  • Using Primary Key, Foreign Key,
  • Using Unique Key, Check Constraints
  • Creating user defined data types
  • Creating a partitioned Tables

[/av_toggle]
[av_toggle title=’Manipulating Data’ tags=” custom_id=” av_uid=’av-ku419pkd’ sc_version=’1.0′]

  • Manipulating Data using DML Statements
  • Using Insert, Update, and Delete Statements

[/av_toggle]
[av_toggle title=’Manipulating XML Data’ tags=” custom_id=” av_uid=’av-ku41a9nt’ sc_version=’1.0′]

  • Components of XML documents
  • Storing XML data in a Table
  • Retrieving Table data into XML format

[/av_toggle]
[av_toggle title=’Create and Manage Views and Indexes’ tags=” custom_id=” av_uid=’av-ku41avaq’ sc_version=’1.0′]

  • Creating and managing views
  • Advantages of using views
  • Understanding catalog views
  • Creating and Managing Indexes
  • Creating XML and Partitioned indexes
  • Implementing full-text search

[/av_toggle]
[av_toggle title=’ Implementing Batches and Procedures’ tags=” custom_id=” av_uid=’av-ku41bg1j’ sc_version=’1.0′]

  • Creating Batches, using variables
  • Using construct and Handling Exceptions
  • Creating different types of procedures
  • Retrieving values from stored procedures

[/av_toggle]
[av_toggle title=’ Function, Triggers and Transactions’ tags=” custom_id=” av_uid=’av-ku41bg1j’ sc_version=’1.0′]

  • Creating and managing user defined functions
  • Implementing Triggers, using DML Triggers
  • Implementing DDL and nested Triggers
  • Creating and Implementing Transactions
  • Auto-commit Implicit and Explicit Transactions

[/av_toggle]
[av_toggle title=’ Creating Managed Code’ tags=” custom_id=” av_uid=’av-ku41bg1j’ sc_version=’1.0′]

  • Understanding Managed Code
  • Creating Managed Objects
  • Managed Function and Triggers
  • Introduction to Service Broker
  • Message based communication
  • Create Message, Queues & Contra

[/av_toggle]
[/av_toggle_container]

[/av_one_full][/av_section][av_section min_height=” min_height_pc=’25’ min_height_px=’500px’ padding=’default’ custom_margin=’0px’ custom_margin_sync=’true’ color=’main_color’ background=’bg_color’ custom_bg=” background_gradient_color1=” background_gradient_color2=” background_gradient_direction=’vertical’ src=” attachment=” attachment_size=” attach=’scroll’ position=’top left’ repeat=’no-repeat’ video=” video_ratio=’16:9′ overlay_opacity=’0.5′ overlay_color=” overlay_pattern=” overlay_custom_pattern=” shadow=’no-border-styling’ bottom_border=’no-border-styling’ bottom_border_diagonal_color=’#333333′ bottom_border_diagonal_direction=” bottom_border_style=” custom_arrow_bg=” id=” custom_class=” template_class=” aria_label=” av_element_hidden_in_editor=’0′ av_uid=” sc_version=’1.0′]
[av_heading heading=’Related Courses’ tag=’h2′ style=’blockquote modern-quote modern-centered’ subheading_active=” show_icon=” icon=’ue800′ font=’entypo-fontello’ size=’50’ av-medium-font-size-title=” av-small-font-size-title=” av-mini-font-size-title=” subheading_size=’30’ av-medium-font-size=” av-small-font-size=” av-mini-font-size=” icon_size=” av-medium-font-size-1=” av-small-font-size-1=” av-mini-font-size-1=” color=” custom_font=” icon_color=” margin=’0′ margin_sync=’true’ padding=’0′ icon_padding=’10’ link=” link_target=” id=” custom_class=” template_class=” av_uid=” sc_version=’1.0′ admin_preview_bg=’rgb(255, 255, 255)’][/av_heading]

[av_textblock size=” font_color=” color=” av-medium-font-size=” av-small-font-size=” av-mini-font-size=” av_uid=” admin_preview_bg=”]

Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.
Lorem ipsum dolor sit amet, consectetuer adipiscing elit.

[/av_textblock]

[av_hr class=’custom’ icon_select=’yes’ icon=’ue84f’ font=’entypo-fontello’ position=’center’ shadow=’no-shadow’ height=’20’ custom_border=’av-border-thin’ custom_width=’50px’ custom_margin_top=’10px’ custom_margin_bottom=’10px’ custom_border_color=’#d3d3d3′ custom_icon_color=’#072f4c’ id=” custom_class=” template_class=” av_uid=” sc_version=’1.0′ admin_preview_bg=’rgb(255, 255, 255)’]

[av_one_full first min_height=’av-equal-height-column’ vertical_alignment=’av-align-middle’ space=” row_boxshadow_color=’#000000′ row_boxshadow_width=’10’ custom_margin=’aviaTBcustom_margin’ margin=’0px’ margin_sync=’true’ mobile_breaking=” border=” border_color=’#000000′ radius=’px’ radius_sync=’true’ padding=’px,15px,15px,15px’ column_boxshadow_color=’#000000′ column_boxshadow_width=’10’ background=’bg_color’ background_color=” background_gradient_color1=” background_gradient_color2=” background_gradient_direction=’diagonal_bt’ src=” attachment=” attachment_size=” background_position=’top left’ background_repeat=’no-repeat’ highlight_size=’1.1′ animation=’left-to-right’ link=” linktarget=” link_hover=’opacity80′ title_attr=” alt_attr=” mobile_display=” id=” custom_class=” template_class=” aria_label=” av_uid=” sc_version=’1.0′]

[av_postslider link=’category,1′ wc_prod_visible=” wc_prod_hidden=’hide’ wc_prod_featured=” prod_order_by=” prod_order=” date_filter=” date_filter_start=” date_filter_end=” date_filter_format=’yy/mm/dd’ items=’9′ offset=’0′ contents=’excerpt’ columns=’4′ preview_mode=’auto’ image_size=’portfolio’ autoplay=’yes’ interval=’5′ lazy_loading=’enabled’ alb_description=” id=” custom_class=” template_class=” av_uid=” sc_version=’1.0′]

[/av_one_full]
[/av_section]

[av_section min_height=” min_height_pc=’25’ min_height_px=’500px’ padding=’default’ custom_margin=’0px’ custom_margin_sync=’true’ color=’main_color’ background=’bg_color’ custom_bg=’#f7f7f7′ background_gradient_color1=” background_gradient_color2=” background_gradient_direction=’vertical’ src=” attachment=” attachment_size=” attach=’scroll’ position=’top left’ repeat=’no-repeat’ video=” video_ratio=’16:9′ overlay_opacity=’0.5′ overlay_color=” overlay_pattern=” overlay_custom_pattern=” shadow=’no-border-styling’ bottom_border=’no-border-styling’ bottom_border_diagonal_color=’#333333′ bottom_border_diagonal_direction=” bottom_border_style=” custom_arrow_bg=” id=” custom_class=” template_class=” aria_label=” av_element_hidden_in_editor=’0′ av_uid=” sc_version=’1.0′]
[av_one_half first min_height=” vertical_alignment=’av-align-top’ space=” row_boxshadow=” row_boxshadow_color=” row_boxshadow_width=’10’ custom_margin=” margin=’0px’ mobile_breaking=” border=” border_color=” radius=’0px’ padding=’0px’ column_boxshadow=” column_boxshadow_color=” column_boxshadow_width=’10’ background=’bg_color’ background_color=” background_gradient_color1=” background_gradient_color2=” background_gradient_direction=’vertical’ src=” background_position=’top left’ background_repeat=’no-repeat’ highlight=” highlight_size=” animation=” link=” linktarget=” link_hover=” title_attr=” alt_attr=” mobile_display=” id=” custom_class=” template_class=” aria_label=” av_uid=” sc_version=’1.0′]

[av_textblock size=” av-medium-font-size=” av-small-font-size=” av-mini-font-size=” font_color=” color=” id=” custom_class=” template_class=” av_uid=” sc_version=’1.0′ admin_preview_bg=”]

Request for more information

 

Verification


[/av_textblock]

[/av_one_half][av_one_half min_height=” vertical_alignment=’av-align-top’ space=” row_boxshadow=” row_boxshadow_color=” row_boxshadow_width=’10’ custom_margin=” margin=’0px’ mobile_breaking=” border=” border_color=” radius=’0px’ padding=’0px’ column_boxshadow=” column_boxshadow_color=” column_boxshadow_width=’10’ background=’bg_color’ background_color=” background_gradient_color1=” background_gradient_color2=” background_gradient_direction=’vertical’ src=” background_position=’top left’ background_repeat=’no-repeat’ highlight=” highlight_size=” animation=” link=” linktarget=” link_hover=” title_attr=” alt_attr=” mobile_display=” id=” custom_class=” template_class=” aria_label=” av_uid=” sc_version=’1.0′]

[av_hr class=’custom’ icon_select=’no’ icon=’ue808′ font=’entypo-fontello’ position=’center’ shadow=’no-shadow’ height=’50’ custom_border=’av-border-none’ custom_width=’50px’ custom_margin_top=’30px’ custom_margin_bottom=’30px’ custom_border_color=” custom_icon_color=” id=” custom_class=” template_class=” av_uid=” sc_version=’1.0′ admin_preview_bg=”]

[av_image src=’https://softbravo.com/institute/wp-content/uploads/2021/08/pexels-mikhail-nilov-8284724.jpg’ attachment=’1101′ attachment_size=’full’ copyright=” caption=” styling=” align=’center’ font_size=” overlay_opacity=’0.4′ overlay_color=’#000000′ overlay_text_color=’#ffffff’ animation=’no-animation’ hover=” appearance=” link=” target=” title_attr=” alt_attr=” lazy_loading=’disabled’ id=” custom_class=” template_class=” av_element_hidden_in_editor=’0′ av_uid=” sc_version=’1.0′ admin_preview_bg=”][/av_image]

[/av_one_half]
[/av_section]


Home

Calendar

Blog

Gallery

Address