MCSE SQL Server 2012 SharePoint

Course

Online

Save 77%
£ 135 VAT inc.

Description

  • Type

    Course

  • Level

    Intermediate

  • Methodology

    Online

  • Class hours

    45h

  • Duration

    1 Year

  • Start date

    Different dates available

  • Online campus

    Yes

  • Support service

    Yes

  • Virtual classes

    Yes

Master enterprise document and file management as a fully qualified MCSE SQL Server 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.

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

About this course

How to Install, configure, manage and maintain a SharePoint Server instance.
Using profiles and permissions to secure data stored in SharePoint.
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.
How to upgrade and migrate SharePoint Server installations.
How to configure and manage apps and solutions within the SharePoint Server 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 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, 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 platform, and how to build a data warehouse to support the intranet and other BI applications.

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, 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 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.

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

All the training and resources needed to sit and pass the MCSA SQL Server 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 for optimum performance and reliability.
Similar skills in installing, configuring and maintaining SharePoint Server in an enterprise computing context.
The techniques required to query and manipulate data directly using T-SQL.
Knowledge in advanced SQL Server data warehouse construction, deployment and management.
The ability to extend SharePoint Server 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 & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Server
  • Sharepoint
  • SQL
  • MCSE training
  • MCSE
  • SQL Server
  • T-SQL
  • Queries
  • Data Types
  • SQL Data Types
  • Filtering Data
  • Multiple tables
  • Modifying
  • Querying

Course programme

Units of Study

Microsoft 70-461: Querying SQL Server 2012
  • 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
Microsoft 70-462: Administering SQL Server 2012 Databases
  • 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
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
  • 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
Permissions
  • Intro
  • Site Permissions
  • Terms
  • Demo
  • Authentication Modes
  • O Auth
  • Summary
Search
  • 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

MCSE SQL Server 2012 SharePoint

£ 135 VAT inc.