Skip to content

MCSE SQL Server 2012 SharePoint


South & City College Birmingham

Summary

Price
£600 inc VAT
Study method
Online
Duration
Self-paced
Qualification
No formal qualification

Overview

Master enterprise document and file management as a fully qualified MCSE SQL Server 2012 database administrator with additional skills in the deployment and management of SharePoint Server. Once they have completed this intensive hands-on course, students will be ready to sit the MCSE qualification exams and to implement SharePoint-based knowledgebase systems.

Description

Master enterprise document and file management as a fully qualified MCSE SQL Server 2012 database administrator with additional skills in the deployment and management of SharePoint Server. Once they have completed this intensive hands-on course, students will be ready to sit the MCSE qualification exams and to implement SharePoint-based knowledgebase systems.

From the fundamentals of querying SQL database tables using T-SQL to building an enterprise-class intranet and document management system using SharePoint, the MCSE SQL Server and SharePoint server course is perfect for:

  • System administrators.
  • System engineers
  • Database and intranet developers who want to improve their skills and earn an industry-recognised qualification.
  • Individuals seeking to retrain in modern data storage and indexing technologies.

Students will learn the skills needed to install, configure and manage SharePoint Server 2013, and develop a greater understanding of the SQL Server technologies which provide the technical framework for the SharePoint. This approach ensures students can develop the level of expertise required to manage a SharePoint deployment in any environment.

Using a seamless blend of instructor led videos and self-study resources, the MCSE SQL Server 2012 Sharepoint course is completed online using the learning platform. All course materials are available anyplace anytime so that learners can study whenever best suits them. A built-in social networking platform also allows participants to ask questions and share knowledge with their peers, providing additional opportunities for learning.

Students can legitimately expect to boost their job prospects and employability as they acquire new expert-level skills and experience in SQL Server 2012 and SharePoint Server 2013.

Key learning points

Initially students will be taken through the basics of the SharePoint 2013 platform, learning about:

  • How to Install, configure, manage and maintain a SharePoint Server 2013 instance.
  • Using profiles and permissions to secure data stored in SharePoint 2013.
  • Configuring enterprise search and managing taxonomy to ensure users can find and access the information they need quickly and easily.
  • Building web applications and site collections.
  • Designing an information architecture with accompanying logical and physical architectures to build a corporate intranet that scales according to business needs and priorities.

Once proficient in the basics, students move on to the final module, learning about advanced SharePoint techniques including:

  • How to upgrade and migrate SharePoint Server installations.
  • How to configure and manage apps and solutions within the SharePoint Server 2013 environment.
  • Building a scalable SharePoint Server environment that will meet the growth and search demands of an enterprise-class organisation.
  • Configure interoperability with other services and applications including Business Intelligence (BI), social computing, productivity and collaboration platforms to create additional value from the SharePoint platform.
  • Improving SharePoint Server resilience for high-availability deployments and to cope with Disaster Recovery (DR) scenarios.

In preparation for the MCSE SharePoint 2013 examination, this course takes students through five in-depth modules to ensure they have the skills and expertise to pass the tests and prepare themselves for a productive IT career. The other three modules help learners get to grips with Microsoft SQL Server 2012, which provides the database backend for the SharePoint intranet and document management system. These modules cover concepts including querying and manipulating data using T-SQL, installing and administering the SQL Server 2012 platform, and how to build a data warehouse to support the intranet and other BI applications.

Advantages of this course

Web-accessible course materials allow students to follow the course at their own pace, so they are never “left behind”. The MCSE SQL Server 2012 SharePoint course provides:

  • All the training and resources needed to sit and pass the MCSA SQL Server 2012 and MCSE SharePoint Server exams.
  • The opportunity to improve knowledge, skills and employment prospects with Microsoft-approved course materials.
  • The knowledge required to install, configure and maintain SQL Server 2012 for optimum performance and reliability.
  • Similar skills in installing, configuring and maintaining SharePoint Server 2013 in an enterprise computing context.
  • The techniques required to query and manipulate data directly using T-SQL.
  • Knowledge in advanced SQL Server 2012 data warehouse construction, deployment and management.
  • The ability to extend SharePoint Server 2013 by integrating Business Connectivity Services.

The MCSE SQL Server 2012 and SharePoint Server 2013 course is essential for IT professionals who want to improve their database and intranet management skills, or to gain the knowledge and experience required to pass their MCSA and MCSE exams.

Questions and answers

Reviews

Currently there are no reviews for this course. Be the first to leave a review.

FAQs

Study method describes the format in which the course will be delivered. At Reed Courses, courses are delivered in a number of ways, including online courses, where the course content can be accessed online remotely, and classroom courses, where courses are delivered in person at a classroom venue.

CPD stands for Continuing Professional Development. If you work in certain professions or for certain companies, your employer may require you to complete a number of CPD hours or points, per year. You can find a range of CPD courses on Reed Courses, many of which can be completed online.

A regulated qualification is delivered by a learning institution which is regulated by a government body. In England, the government body which regulates courses is Ofqual. Ofqual regulated qualifications sit on the Regulated Qualifications Framework (RQF), which can help students understand how different qualifications in different fields compare to each other. The framework also helps students to understand what qualifications they need to progress towards a higher learning goal, such as a university degree or equivalent higher education award.

An endorsed course is a skills based course which has been checked over and approved by an independent awarding body. Endorsed courses are not regulated so do not result in a qualification - however, the student can usually purchase a certificate showing the awarding body's logo if they wish. Certain awarding bodies - such as Quality Licence Scheme and TQUK - have developed endorsement schemes as a way to help students select the best skills based courses for them.