Menara Q Sentral, Kuala Lumpur Sentral.+603 9212 0203enquiry@bsacrescent.com

Microsoft SQL Server

Microsoft SQL Server Course

Microsoft Certified Technology Specialist (MCTS)

After completion of the course candidates will be able to install and configure SQL Server 2008, maintain instances, manage security, maintain a database and perform data management tasks.

[qode_advanced_tabs title_tag=”h3″][qode_advanced_tab tab_title=”About”]
ABOUT THIS COURSE

After completion of the course candidates will be able to install and configure SQL Server 2008, maintain instances, manage security, maintain a database and perform data management tasks. They will also learn how to monitor and troubleshoot SQL Server, optimize performance and implement high availability. Subsequently, the course will move on to designing database infrastructure, designing strategies for automating, securing, distributing data, monitoring and maintaining high availability of a database server.

AUDIENCE PROFILE

This course is targeted at the professional level SQL Server 2008 Database Administrator. Candidates for this course intend to work in an environment in which Microsoft SQL Server 2008 is used for database solutions.

AT COURSE COMPLETION

After completing this course, students will be able to:

  • Implement an administrative solution for SQL Server 2008.
  • Deploy SQL Server 2008.
  • Design the physical structure for SQL Server 2008.
  • Design a strategy for maintaining SQL Server 2008.
  • Design a strategy for managing SQL Server 2008.
  • Automate the database managing strategy for SQL Server 2008.
  • Design a strategy for securing databases in SQL Server 2008.
  • Design a strategy for monitoring SQL Server 2008.
  • Design a strategy for content distribution in SQL Server 2008.
  • Design a strategy for replication in SQL Server 2008.
  • Design a high availability solution for SQL Server 2008.
  • Design a strategy for backup and recovery in SQL Server 2008.
[/qode_advanced_tab][qode_advanced_tab tab_title=”Topics”]
COURSE OUTLINE
  • Implement an administrative solution for SQL Server 2008.
  • Deploy SQL Server 2008.
  • Design the physical structure for SQL Server 2008.
  • Design a strategy for maintaining SQL Server 2008.
  • Design a strategy for managing SQL Server 2008.
  • Automate the database managing strategy for SQL Server 2008.
  • Design a strategy for securing databases in SQL Server 2008.
  • Design a strategy for monitoring SQL Server 2008.
  • Design a strategy for content distribution in SQL Server 2008.
  • Design a strategy for replication in SQL Server 2008.
  • Design a high availability solution for SQL Server 2008.
  • Design a strategy for backup and recovery in SQL Server 2008.
[/qode_advanced_tab][qode_advanced_tab tab_title=”Prerequisites”]
  • Basic knowledge of Microsoft Windows operating system and its core functionality.
  • Working knowledge of Transact-SQL.
  • Working knowledge of relational databases.
  • Some experience with database design.
  • Completed Course 2778: Writing Queries Using Microsoft SQL Server 2008 Transact-SQL.
[/qode_advanced_tab][qode_advanced_tab tab_title=”Calendar”]

Calendar coming soon. Enquire today to receive more information and to get alerts on upcoming courses.

[/qode_advanced_tab][/qode_advanced_tabs]

Enquire for this course

  • This field is for validation purposes and should be left unchanged.

Learn digital skills and get certified with our training programs

All BSA Crescent Training Programs are HRDF claimable!

[image_with_text title_tag="h3" title_color="#182d58" title="Leadership Courses" image="1326"] [/image_with_text]
[image_with_text title_tag="h3" title_color="#182d58" image="883" title="Blockchain Academy courses"] [/image_with_text]
[image_with_text title_tag="h3" title_color="#182d58" image="1055" title="Management courses"] [/image_with_text]
[image_with_text title_tag="h3" title_color="#182d58" title="Soft Skill Development" image="1262"] [/image_with_text]
[image_with_text title_tag="h3" title_color="#182d58" image="445" title="Digital Marketing courses"] [/image_with_text]
[image_with_text title_tag="h3" title_color="#182d58" image="438" title="Cisco courses"] [/image_with_text]
[image_with_text title_tag="h3" title_color="#182d58" image="435" title="Adobe courses"] [/image_with_text]
[image_with_text title_tag="h3" title_color="#182d58" image="434" title="Microsoft courses"] [/image_with_text]
[image_with_text title_tag="h3" title_color="#182d58" image="436" title="Autodesk courses"] [/image_with_text]

Upcoming course dates

All BSA Crescent Training Programs are HRDF claimable!

[qode_info_card title_tag="h2" enable_button="yes" image="1332" title="Winning Communication course" text="13 October | Q Sentral | HRDF Claimable | Knowing your audience, that’s the most important tip for Winning Communication" button_link="//bsacrescent.com/courses/soft-skills-development/winning-communication-course/" button_text="View details"]
[qode_info_card title_tag="h2" enable_button="yes" image="1298" title="Customer Service Excellence course" text="22 November | Q Sentral | HRDF Claimable | Customer expectations are extremely high and you may encounter some very challenging and demanding people " button_link="//bsacrescent.com/courses/soft-skills-development/customer-service-excellence/" button_text="View details"]
[qode_info_card title_tag="h2" enable_button="yes" image="1320" title="Problem Solving & Decision Making skills" text="23 November | Q Sentral | HRDF Claimable | Correct and timely decision-making can be done using specific techniques and enhanced knowledge of the self and situations" button_link="//bsacrescent.com/courses/leadership/problem-solving-decision-making-skills/" button_text="View details"]

Training Centre Location

Unit 30-2
Menara Q Sentral
2A Jalan Stesen Sentral 2
KL Sentral
50470 Kuala Lumpur
Malaysia

Training Centre Accessibility

BSA Crescent Academy Training Centre is conveniently located at KL Sentral.

Our Training Centre is connected by mayor highways, LRT, MRT, Monorail, KTM Komuter and ERL.

Ample parking space is available in the building.

Why BSA Crescent?

[icon_text box_type="normal" icon="fa-building" icon_type="circle" icon_position="top" icon_size="fa-3x" use_custom_icon_size="no" title="State of the art facilities" title_tag="h3" separator="no" icon_border_color="#ffffff" icon_color="#ffffff" icon_hover_color="#ffffff" title_color="#ffffff"]
[icon_text box_type="normal" icon="fa-user" icon_type="circle" icon_position="top" icon_size="fa-3x" use_custom_icon_size="no" title="Experienced and certified trainers" title_tag="h3" separator="no" icon_border_color="#ffffff" icon_color="#ffffff" icon_hover_color="#ffffff" title_color="#ffffff"]
[icon_text box_type="normal" icon="fa-desktop" icon_type="circle" icon_position="top" icon_size="fa-3x" use_custom_icon_size="no" title="Stay up-to-date with new and relevant technologies" title_tag="h3" separator="no" icon_border_color="#ffffff" icon_color="#ffffff" icon_hover_color="#ffffff" title_color="#ffffff"]
[icon_text box_type="normal" icon="fa-info" icon_type="circle" icon_position="top" icon_size="fa-3x" use_custom_icon_size="no" title="Training and mentorship combined" title_tag="h3" separator="no" icon_border_color="#ffffff" icon_color="#ffffff" icon_hover_color="#ffffff" title_color="#ffffff"]
[icon_text box_type="normal" icon="fa-thumbs-up" icon_type="circle" icon_position="top" icon_size="fa-3x" use_custom_icon_size="no" title="Fully HRDF Claimable" title_tag="h3" separator="no" icon_border_color="#ffffff" icon_color="#ffffff" icon_hover_color="#ffffff" title_color="#ffffff"]
[icon_text box_type="normal" icon="fa-certificate" icon_type="circle" icon_position="top" icon_size="fa-3x" use_custom_icon_size="no" title="Internationally Recognized Certification" title_tag="h3" separator="no" icon_border_color="#ffffff" icon_color="#ffffff" icon_hover_color="#ffffff" title_color="#ffffff"]
[icon_text box_type="normal" icon="fa-globe" icon_type="circle" icon_position="top" icon_size="fa-3x" use_custom_icon_size="no" title="Placement Opportunities" title_tag="h3" separator="no" icon_border_color="#ffffff" icon_color="#ffffff" icon_hover_color="#ffffff" title_color="#ffffff"]
[icon_text box_type="normal" icon="fa-book" icon_type="circle" icon_position="top" icon_size="fa-3x" use_custom_icon_size="no" title="High Quality Courseware" title_tag="h3" separator="no" icon_border_color="#ffffff" icon_color="#ffffff" icon_hover_color="#ffffff" title_color="#ffffff"]

Course Partners

BSA Crescent is an authorised testing center for...

Translate »