MCSE SQL 2012 DATA PLATFORM (LIVE LABS INCLUDED)

Greater Brighton Metropolitan College

Course

Online

Price on request

The best SQL Server courses

See all

See all

Description

  • Type

    Course

  • Methodology

    Online

Supporting database analysts and designers to go beyond simply understanding the mechanics of SQL Server 2012, this course shows how to create and deploy database solutions for an enterprise-class environment.

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

  • MCSE
  • MCSE training
  • Database training
  • SQL
  • Database
  • Server
  • XML
  • XML training

Course programme

  • 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
  • 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
  • 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
  • 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 Part1
  • Working with Data Types Part2
  • Working with Data Types Part3
  • Other Data Types
  • Tables
  • Creating Tables
  • Data Constraints Part1
  • Data Constraints Part2
  • Planning In Indexing Part1
  • Planning In Indexing Part2
  • Planning In Indexing Part3
  • Planning In Indexing Part4
  • Table Structures
  • Working With Clustered Indexes
  • Clustered Indexes
  • Designing Effective Clustered Indexes
  • Improving Performance with NonClustered Indexes Part1
  • Improving Performance with NonClustered Indexes Part2
  • Improving Performance with NonClustered Indexes Part3
  • Using Indexes
  • Execution Plans Part1
  • Execution Plans Demo
  • Execution Plans Part2
  • Working with Views Part1
  • Working with Views Part2
  • Designing and Implementing Stored Procedures Part1
  • Designing and Implementing Stored Procedures Part2
  • Designing and Implementing Stored Procedures Part3
  • Merging Data and Passing Tables Part1
  • Merging Data and Passing Tables Part2
  • Merging Data and Passing Tables Part3
  • DesigningAndImplementingUserFunctions
  • 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 Part1
  • Handling Errors in TSQL Part2
  • Triggers
  • Implementing Managed Code Part1
  • Implementing Managed Code Part2
  • Implementing Managed Code Part3
  • Storing XML in SQL Part1
  • Storing XML in SQL Part2
  • Storing XML in SQL Part3
  • Querying XML Part1
  • Querying XML Part2
  • Querying XML Part3
  • Working with the Spatial Data Part1
  • Working with the Spatial Data Part2
  • Working with the Spatial Data Part3
  • Working With FullText Indexes and Queries Part1
  • Working With FullText Indexes and Queries Part2
  • Working With FullText Indexes and Queries Part3
  • Outro
  • 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 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 Part1
  • Designing A Physical Database Implementation Part2
  • Designing A Physical Database Implementation part3
  • 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 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 Part1
  • Desigining Database Security Part2
  • Contained Databases
  • Protecting Data with Encryption
  • Policy Based Management
  • Policy Based Management Demo
  • Monitoring Server Health
  • Monitoring Server Health Demo
  • 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
  • Managing Multiple Servers
  • Managing SQL Server With Windows Powershell
  • Windows Powershell Lab
  • Replicating Data Part1
  • Replicating Data Part2
  • Replicating Data Part3
  • Planning High Availability Part1
  • Planning High Availability Part2
  • Review of SQL Statements Part1
  • Review of SQL Statements Part2
  • Review of SQL Statements Part3
  • Eleven Rules Of Database Design
  • Conclusion

    • Additional information

    Mastering data using Master Data Services. Ensuring data accuracy using Data Quality Services. 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. Troubleshoot data integration and quality issues to ensure accuracy for reporting and line-of-business applications.

    See related categories

    MCSE SQL 2012 DATA PLATFORM (LIVE LABS INCLUDED)

    Price on request

    The best SQL Server courses

    See all

    See all