MCSE SQL 2012 Data Platform

WGS Career Academy

Course

Online

Save 77%
£ 135 VAT inc.

The best SQL Server courses

See all

See all

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

Go beyond the basic mechanics of SQL Server and learn how to create and deploy database solutions for an enterprise-class environment with the MCSE SQL Data Platform course. Once this intensive, hands-on course has been completed, database analysts and developers will have the knowledge and skills required to implement and develop robust and efficient SQL server solutions.

By completing this course students will fully understand the concepts behind Microsoft SQL Server and how to build and query complex database solutions in a real world environment. From the core fundamentals of installing and configuring SQL Server, through to querying data directly using T-SQL and on to building and developing enterprise class data platforms, students will gain a complete understanding of the database system and how it can be extended to meet the data needs of the modern enterprise.

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

About this course

Mastering data using Master Data Services.
Ensuring data accuracy using Data Quality Services to reduce instance of incomplete or duplicate data being collected and saved.
Managing, configuring and deploying SQL Server Integration Services (SSIS) packages to automate and extend BI functionality.
Perform data manipulation, transformation and integration operations to collate information from multiple sources, including custom applications and third party data stores.
Troubleshooting data integration and quality issues to ensure data accuracy for use in reports and line-of-business applications.

SQL Server database developers and analysts who need to know more about the advanced functions included in the platform.
Systems administrators and engineers who will be responsible for managing advanced SQL Server deployments.
Individuals who want to cross-train for a new career in database management and development.
Using a seamless blend of instructor led videos and self-study resources, the MCSE SQL Data Platform course is delivered online using the learning platform. All course materials are available anyplace anytime so that learners can study whenever and however best suits them. A built-in social networking platform also allows learners to ask questions and share knowledge and experience with their peers, providing additional opportunities for learning.

After completing the course students can expect to boost their job prospects and employability as they acquire new expert-level database management skills and experience in SQL Server.

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

An in-depth understanding of SQL Server design principles and how to build suitable database systems using Microsoft technologies.
The tools, techniques and knowledge required to access and manipulate data efficiently.
The knowledge, skills and techniques required to build powerful applications using SQL Server technologies.
Full understanding of the install, configuration and maintenance procedures required to deliver optimum SQL Server performance and reliability.
Design, deploy and manage an advanced SQL Server data warehouse that will meet the changing needs of a real world enterprise.
Completion of this course also fully prepares database designers and data analysts for the SQL MCSA/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

  • Monitoring
  • SQL
  • Database training
  • XML training
  • XML
  • MCSE training
  • Windows
  • Planning
  • Server
  • Database
  • MCSE

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
Microsoft 70-464: Developing Microsoft SQL Server 2012 Databases

SQL And The 464 Test
  • Introduction to SQL Server 2012
  • Intro To SQL Server 2012 Part1
  • Intro To SQL Server 2012 Part2
  • Management Studio Demo Part1
  • Management Studio Demo Part2
  • Management Studio Demo Part3
  • Other SQL Server Tools
Working with Data Types
  • Working with Data Types Part1
  • Working with Data Types Part2
  • Working with Data Types Part3
  • Other Data Types
Tables
  • Tables
  • Creating Tables
Data Constraints
  • Data Constraints Part1
  • Data Constraints Part2
Planning In Indexing
  • Planning In Indexing Part1
  • Planning In Indexing Part2
  • Planning In Indexing Part3
  • Planning In Indexing Part4
Table Structures
  • Table Structures
  • Working With Clustered Indexes
  • Clustered Indexes
  • Designing Effective Clustered Indexes
Improving Performance with NonClustered Indexes
  • Improving Performance with NonClustered Indexes Part1
  • Improving Performance with NonClustered Indexes Part2
  • Improving Performance with NonClustered Indexes Part3
Using Indexes And Execution Plans
  • Using Indexes
  • Execution Plans Part1
  • Execution Plans Demo
  • Execution Plans Part2
Working with Views
  • Working with Views Part1
  • Working with Views Part2
Designing and Implementing Stored Procedures
  • Designing and Implementing Stored Procedures Part1
  • Designing and Implementing Stored Procedures Part2
  • Designing and Implementing Stored Procedures Part3
Merging Data and Passing Tables
  • Merging Data and Passing Tables Part1
  • Merging Data and Passing Tables Part2
  • Merging Data and Passing Tables Part3
Designing and Implementing User Functions
  • DesigningAndImplementingUserFunctions
Creating Highly Concurrent SQL Server Applications
  • Creating Highly Concurrent SQL Server Applications Part1
  • Creating Highly Concurrent SQL Server Applications Part2
  • Creating Highly Concurrent SQL Server Applications Part3
Handling Errors in TSQL
  • Handling Errors in TSQL Part1
  • Handling Errors in TSQL Part2
Triggers
  • Triggers
Implementing Managed Code
  • Implementing Managed Code Part1
  • Implementing Managed Code Part2
  • Implementing Managed Code Part3
Storing XML in SQL
  • Storing XML in SQL Part1
  • Storing XML in SQL Part2
  • Storing XML in SQL Part3
Querying XML
  • Querying XML Part1
  • Querying XML Part2
  • Querying XML Part3
Working with the Spatial Data
  • Working with the Spatial Data Part1
  • Working with the Spatial Data Part2
  • Working with the Spatial Data Part3
Working With FullText Indexes and Queries
  • Working With FullText Indexes and Queries Part1
  • Working With FullText Indexes and Queries Part2
  • Working With FullText Indexes and Queries Part3
  • Outro
Microsoft 70-465: Designing Database Solutions for Microsoft SQL Server 2012

Designing A Database Server Infrastructure
  • Introduction
  • Designing A Database Server Infrastructure Part1
  • Designing A Database Server Infrastructure Part2
  • Designing A Database Server Infrastructure Part3
  • Designing A Database Server Infrastructure Part4
  • Considerations For Database Server Consolidation
  • Managing Server Resources
Designing A Logical Database Scheme
  • Designing A Logical Database Scheme Part1
  • Designing A Logical Database Scheme Part2
  • Designing A Logical Database Scheme Part3
  • Designing A Logical Database Scheme Part4
  • Designing A Logical Database Scheme Part5
Designing A Physical Database Implementation
  • Designing A Physical Database Implementation Part1
  • Designing A Physical Database Implementation Part2
  • Designing A Physical Database Implementation part3
Incorporating Data Files Into the Database
  • Incorporating Data Files Into the Database Part1
  • Incorporating Data Files Into the Database Part2
  • Incorporating Data Files Into the Database Part3
  • Incorporating Data Files Into the Database Demo
  • Searching Data Files
  • Searching Data Files Demo
Tuning Database Performance
  • Tuning Database Performance Part1
  • Tuning Database Performance Part2
  • Tuning Database Performance Part3
  • Working with Query Plans Part1
  • Working with Query Plans Part2
  • Working with Query Plans Part3
  • Working with Query Plans Part4
Desigining Database Security
  • Desigining Database Security Part1
  • Desigining Database Security Part2
  • Contained Databases
  • Protecting Data with Encryption
Policy Based Management
  • Policy Based Management
  • Policy Based Management Demo
Monitoring Server Health
  • Monitoring Server Health
  • Monitoring Server Health Demo
Designing Database Backup Solution
  • Designing Database Backup Solution Part1
  • Designing Database Backup Solution Part2
  • Designing Database Backup Solution Part3
  • Designing Database Backup Solution Part4
  • Disaster Recovery Plan Part1
  • Disaster Recovery Plan Part2
Automating Multi Server Maintenance
  • Automating Multi Server Maintenance
  • Managing Multiple Servers
Managing SQL Server With Windows Powershell
  • Managing SQL Server With Windows Powershell
  • Windows Powershell Lab
Replicating Data
  • Replicating Data Part1
  • Replicating Data Part2
  • Replicating Data Part3
Planning High Availability
  • Planning High Availability Part1
  • Planning High Availability Part2
Review of SQL Statements
  • Review of SQL Statements Part1
  • Review of SQL Statements Part2
  • Review of SQL Statements Part3
Eleven Rules Of Database Design
  • Eleven Rules Of Database Design
  • Conclusion

See related categories

MCSE SQL 2012 Data Platform

£ 135 VAT inc.

The best SQL Server courses

See all

See all