Administering Microsoft SQL Server 2012/2014 Databases (Course & Lab)

Coming Soon:

This product will be available from 25-Feb-2019

Here's what you will get

Here's what you will learn

  • Evaluating Installation Requirements
  • Designing Installation of SQL Server
  • Installing Extra Features
  • Identifying Windows Level Security and Service Level Security
  • Benchmarking a Server
  • Selecting the Right Hardware
  • Testing Connectivity to SQL Server
  • Understanding Integration Services
  • Summary
  • Attaching and Detaching Databases
  • Migrating Logins
  • Understanding Migrations
  • Migrating to New Hardware
  • Migrating Data from Other Sources
  • Summary
  • Configuring Analysis Services
  • Configuring Reporting Services
  • Configuring SharePoint Integration
  • Configuring SSIS Security
  • Configuring Full-Text Indexing
  • Configuring FILESTREAM
  • Configuring FileTables
  • Summary
  • Creating a Job using SQL Server Management Studio
  • Creating T-SQL Jobs
  • Creating and Using Operators
  • Creating and Using Alerts
  • Summary
  • Designing Filegroups
  • Configuring and Standardizing Databases
  • Configuring Contained Databases
  • Using Data Compression
  • Configuring Transparent Data Encryption
  • Partitioning Tables and Indexes
  • Managing Log Files
  • Using Database Console Commands
  • Summary
  • Installing Default and Named Instances
  • Configuring SQL Server CPU Utilization
  • Configuring SQL Server
  • Virtualizing SQL Server
  • Configuring MSDTC in a Cluster
  • Setting a Fixed Amount of Memory
  • Setting up Database Mail
  • Introducing Fillfactor
  • Introducing sp_configure
  • Summary
  • Installing a Cluster
  • Removing an Installation
  • Monitoring and Managing a SQL Server Cluster
  • Patching Strategies for SQL Server
  • Managing Resource Utilization using Resource Governor
  • Cycling the SQL Server Error Log
  • Summary
  • Understanding Locks
  • Identifying Blocking
  • Detecting and Correcting Deadlocks
  • Monitoring via DMV
  • Monitoring via SQL Server Profiler
  • Monitoring Performance with System Monitor
  • Identifying Transactional Replication Problems
  • Working with Performance Monitor
  • Using SQL Server Data Collector
  • Summary
  • Implementing a Security Strategy in SQL Server
  • Configuring SQL Server Audit
  • Tracking Changes in SQL Server
  • Introducing Policy-Based Management
  • Summary
  • Backing Up a Database
  • Backing Up the Environment
  • Backing Up System Databases
  • Restoring a Database
  • Summary
  • Understanding Indexes
  • Implementing Basic Indexes
  • Understanding Statistics
  • Managing Indexes
  • Summary
  • Using bcp
  • Using BULK INSERT
  • Using SQL Server Integration Services
  • Summary
  • Understanding SQL Server Roles
  • Managing Logins, Users, and Roles
  • Understanding Encryption
  • Auditing SQL Server Activity
  • Summary
  • Introducing AlwaysOn Availability Groups
  • Deploying AlwaysOn Availability Groups
  • Using Availability Groups on Failover Cluster Instances
  • Understanding Failover Clustering
  • Installing a SQL Server Failover Cluster
  • Summary
  • Understanding Replication Architecture
  • Understanding Replication Types
  • Controlling Replication Behaviour
  • Monitoring Replication
  • Summary
2 2
70-462-v2
Administering Microsoft SQL Server 2012/2014 Databases (Course & Lab)