• Mon - Saturday 08.00 - 20.00
  • 1st Floor North Westgate House, the High, Harlow, ESSEX, CM20 1YS
  • 0330 0240 989
  • [email protected]

MCSE SQL Server 2012 SharePoint (Live Labs Included)

MCSE SQL Server 2012 SharePoint (Live Labs Included)

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.


View more about Practice Labs

Responsive image
Responsive image


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.


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.

Live Labs help to improve your understanding of specific exam objectives and provide direction on how to carry out actions in real world scenarios.

Get Certified with WGS Career Academy today!

It’s simple, effective and affordable.

Units of Study

  • Getting Started with SQL Server
  • Working with T-SQL
  • Writing SELECT Queries
  • Working with SQL Data Types
  • Sorting and Filtering Data
  • Querying Data from Multiple Tables
  • Modifying Data
  • Working with SQL Server Built-in Functions
  • Programming in T-SQL
  • Implementing Stored Procedures
  • Working with Subqueries and Table Expressions
  • Working with Set Operators, Conditional Operators, and Window Functions
  • Working with PIVOT, UNPIVOT, and Grouping Sets
  • Managing Error Handling and Transactions
  • Querying SQL Server System
  • Optimizing Query Performance
  • Identifying the SQL Server Platform
  • Deploying SQL Server
  • Configuring SQL Server
  • Managing Databases in SQL Server
  • Managing SQL Server Security
  • Implementing Advanced Security Settings
  • Applying Encryption and Compression
  • Working with Indexes and Log Files
  • Working with Backup and Restore
  • Implementing High Availability
  • Optimizing Server Performance
  • Troubleshooting Issues and Recovering Databases
  • Performing Advanced Database Management Tasks
  • Introduction to Data Warehouse
  • Creating Dimensions and Changing Granularity of Dimensions
  • Creating Fact Tables and ColumnStore Indexes
  • Implementing Data Warehouse in SQL Server
  • Working with Integration Services
  • Managing Control Flow
  • Working with Dynamic Variables
  • Implementing Data Flow
  • Managing Data Flow
  • Managing SSIS Package Execution
  • Debugging and Troubleshooting
  • Deploying Packages
  • Securing Packages and Databases
  • Working with MDS and Windows
  • Course Intro
  • Social Media
  • Mobile Access
  • Business Intelligence- Part1
  • Business Intelligence- Part2
  • Share Point Licensing Overview
  • Organize Info
  • Share Your Insights
  • Minimal Download Strategy
  • Enhanced Social And Collaboration Features
  • Enhanced Search
  • Workflow
  • Enterprise Content Management
  • Web Content Management
  • What We Will Cover – Part1
  • What We Will Cover – Part2
  • What We Will Cover – Part3
  • What We Will Cover – Part4
  • What We Will Cover – Part5
  • What We Will Cover – Part6
  • What We Will Cover – Part7
  • What We Will Cover – Part8
  • What We Will Cover – Part9
  • Software Requirements
  • Service And Accounts
  • Physical Architecture
  • Physical Architecture Traditional Topologies
  • Physical Architecture Streamlined Topologies
  • Physical Architecture Search Architectures
  • Physical Architecture Enterprise Search Architecture
  • Physical Architecture Multi Farm
  • Logical Architecture
  • Logical Architecture Host Names Based Sites
  • Logical Architecture Path Based
  • Logical Architecture Extranet
  • Logical Architecture Mobile
  • Logical Architecture Single Farm Deployment
  • Databasis
  • Summary
  • Web Applications And Site Collections Intro
  • Logical Structure And Web Applications
  • Demo
  • Site Collections
  • Demo- Part1
  • Demo- Part2
  • Application Pools And Summary
  • Intro
  • Service Applications
  • Demo Of Configuring Excel Services
  • Sharepoint Management Shell Demo
  • Summary
  • Intro
  • Site Permissions
  • Terms
  • Demo
  • Authentication Modes
  • O Auth
  • Summary
  • Intro
  • Intro to Search
  • Search Logical Architecture
  • Crawling The Content
  • Content Processing
  • Analytics Processing Component
  • Summary
  • Intro
  • User Profile Service
  • User Profile Demo
  • Profile Synchronization Goals
  • Profile Synchronization Demo
  • Sync Performance Changes
  • Sync Performance Changes Demo
  • Profile Import Options
  • Intro
  • What To Look For
  • Course Intro
  • Intro To Plan Business Continuity Management- Part1
  • Intro To Plan Business Continuity Management- Part2
  • Describe High Availability
  • Degraded Availability
  • Qualifying Downtime
  • Qualifying Downtime Demo- Part1
  • Qualifying Downtime Demo- Part2
  • Qualifying Downtime Demo- Part3
  • Qualifying Downtime Demo- Part4
  • Qualifying Downtime Demo- Part5
  • Qualifying Downtime Demo- Part6
  • Disaster Recovery Plan- Part1
  • Disaster Recovery Plan- Part2
  • Measure Availability- Part1
  • Measure Availability- Part2
  • Measure Availability- Part3
  • Downtime Metrics- Part1
  • Downtime Metrics- Part2
  • Performance To Availability Relationship
  • Costs Of H A
  • H A Supports In A Farm
  • Fault Tolerant In Your H A Solution
  • Backup And Recovery In Share Point2013
  • Summary
  • Intro
  • Plan For Success
  • Model- Part1
  • Model- Part2
  • Model- Part3
  • Model- Part4
  • Model- Part5
  • Model- Part6
  • Model- Part1
  • Model- Part8
  • Design- Part1
  • Design- Part2
  • Design- Part3
  • Design- Part4
  • Design- Part5
  • Design- Part6
  • Design- Part7
  • Test- Part1
  • Test- Part2
  • Test- Part3
  • Test- Part4
  • Test- Part5
  • Test- Part6
  • Test- Part7
  • Deploy
  • Monitor And Maintain
  • Intro To Upgrade And Migrate TOShare Point2013
  • Upgrading TOShare Point2013- Part1
  • Upgrading TOShare Point2013- Part2
  • Upgrading TOShare Point2013- Part3
  • Upgrading TOShare Point2013- Part4
  • Upgrading TOShare Point2013- Part5
  • Upgrading TOShare Point2013- Part6
  • Upgrading TOShare Point2013- Part7
  • Intro To Create And Configure Service Applications
  • Create And Configure Service Applications
  • Create And Configure Service Applications Demo
  • Create And Configure Service Applications Summary
  • Intro To Manage Share Point Solution B I And System Integration
  • Manage S P Solutions B I And System Integration


Curriculum is empty

Review and Rating


Average Rating

0 rating
5 stars
4 stars
3 stars
2 stars
1 star

Course fee

14-days Money back
  • Lectures
    Warning: preg_match() expects parameter 2 to be string, array given in /home/wgscaree/public_html/wp-includes/class-wp-block-parser.php on line 417

    Warning: strlen() expects parameter 1 to be string, array given in /home/wgscaree/public_html/wp-includes/class-wp-block-parser.php on line 489
  • Quizzes
    Warning: preg_match() expects parameter 2 to be string, array given in /home/wgscaree/public_html/wp-includes/class-wp-block-parser.php on line 417

    Warning: strlen() expects parameter 1 to be string, array given in /home/wgscaree/public_html/wp-includes/class-wp-block-parser.php on line 489
  • Duration 45 hour
  • Skill level All levels
  • Max Students 1000
  • Language English




Online Course


1 Year







1 gigahertz (GHz)


1 GB


Windows 7 Windows 8 Windows 10 iOS


Internet Explorer 8 or above Google Chrome Safari 6 or above Mozilla Firefox


Windows, Mac, iPhone, iPad, Android
  • Contact via:


Forgot Password

Do not have an account? Register Now



Complete the form below to receive more details about this course.

Yes, I’d like wgscareeracademy.com to contact me via email.

0330 0240 989