MCSE SQL Server 2012 SharePoint

MCSE SQL Server 2012 SharePoint

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.

Microsoft 70-461: Querying SQL Server 2012
  • Getting Started with SQL Server 2012
  • 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
Microsoft 70-462: Administering SQL Server 2012 Databases
  • Identifying the SQL Server Platform
  • Deploying SQL Server
  • Configuring SQL Server
  • Managing Databases in SQL Server 2012
  • 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
Microsoft 70-463: Implementing a Data Warehouse with SQL Server 2012
  • Introduction to Data Warehouse
  • Creating Dimensions and Changing Granularity of Dimensions
  • Creating Fact Tables and ColumnStore Indexes
  • Implementing Data Warehouse in SQL Server 2012
  • 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
Learning Microsoft 70-331: SharePoint Server 2013 Core Solutions Course Curriculum
Comprehensive Introduction to Sharepoint
  • 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
Installing SharePoint
  • 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
SharePoint Architecture, Logical & Physical
  • 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
  • Web Applications And Site Collections Intro
  • Logical Structure And Web Applications
  • Demo
  • Site Collections
  • Demo- Part1
  • Demo- Part2
  • Application Pools And Summary
Configure Service Applications
  • 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
User Profiles
  • Intro
  • User Profile Service
  • User Profile Demo
  • Profile Synchronization Goals
  • Profile Synchronization Demo
  • Sync Performance Changes
  • Sync Performance Changes Demo
  • Profile Import Options
Ongoing Support and Maintenance
  • Intro
  • What To Look For
Learning Microsoft 70-332: SharePoint Server 2013 Advanced Solutions Course Curriculum
Business Continuity
  • 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
Model, Design, and Test
  • 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
Upgrade and Migrate
  • 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
Create and Configure Service Applications
  • Intro To Create And Configure Service Applications
  • Create And Configure Service Applications
  • Create And Configure Service Applications Demo
  • Create And Configure Service Applications Summary
SharePoint Management
  • Intro To Manage Share Point Solution B I And System Integration
  • Manage S P Solutions B I And System Integration
Course Code
Online Course
Course Access
1 Year
Exams Included
1 gigahertz (GHz)
1 GB
Operating Systems
Windows 7
Windows 8
Internet Explorer 8 or above
Google Chrome
Safari 6 or above
Mozilla Firefox
Windows, Mac, iPhone, iPad, Android
Test your PC's speed and Compatibility for Free
Click here


Your query is submitted.