SQL Server 2012 DBA
Chapter 1
Planning and Installing SQL
Server 2012
Lesson 1: Planning Your Installation
- Evaluating
Installation Requirements
- Designing
the Installation
- Planning
Scale Up versus Scale out Basics
- Shrinking
and Growing Databases
- Designing
the Storage for New Databases
- Remembering
Capacity Constraints
- Identifying a Standby
Database for Reporting
- Identifying
Windows-Level Security and Service-Level Security
- Performing a Core Mode
Installation
- Benchmarking
a Server
Chapter 2
Configuring and Managing SQL
Server Instances
Lesson 1: Configuring
SQL Server Instances . . . . .
- Instance-Level
Settings
- Database
Configuration and Standardization
- Distributed Transaction
Coordinator
- Configuring
Database Mail
Chapter 3
Configuring SQL Server 2012 Components
Lesson
1: Configuring Additional SQL Server Components
- Deploying
and Configuring Analysis Services
- Deploying
and Configuring Reporting Services
- Deploying
and Configuring SharePoint Integration
- Configuring
SQL Server Integration Services Security
- Managing
Full-Text Indexing
- Configuring
FILESTREAM
- Configuring
File Tables
Lesson
2: Managing and Configuring Databases
- Designing
and Managing File groups
- Configuring
and Standardizing Databases
- Understanding
Contained Databases
- Using
Data Compression
- Encrypting
Databases with Transparent Data Encryption
- Partitioning
Indexes and Tables
- Managing
Log Files
- Using Database Console
Commands
Chapter 4
Migrating, Importing, and
Exporting
Lesson 1: Migrating to
SQL Server 2012
- Upgrading
an Instance to SQL Server 2012
- Migrating
a Database to a SQL Server 2012 Instance
- Copying Databases to
Other Servers
- Migrating
SQL Logins
Lesson
2: Exporting and Importing Data
- Copying
and Exporting Data
- Using the SQL Server
Import and Export Wizard
- Using
BCP to Import and Export Data
- Importing
Data by Using BULK INSERT
- Importing Data by Using
OPENROWSET (BULK)
- Using Format Files
- Preparing
Data for Bulk Operations
- SELECT
INTO
Chapter 5a
SQL Server Logins, Roles, and
Users
Lesson
1: Managing Logins and Server Roles
- SQL
Logins
- Server
Roles
- User-Defined
Server Roles
- Credentials
Lesson
2: Managing Users and Database Roles
- Database
Users
- Database
Roles
- Contained
Users
- Least
Privilege
- Application
Roles
Chapter 5b
SQL Server Agent, Backup, and
Restore
Lesson
1: Managing SQL Server Agent
- Executing
Jobs by Using SQL Server Agent
- Managing Alerts
- Managing
Jobs
- Monitoring Multi-Server
Environments
Lesson
2: Configuring and Maintaining a Backup Strategy.
- Understanding
Backup Types
- Backing
up System Databases
- Backing up Replicated
Databases
- Backing
up Mirrored Databases
- Backing
up AlwaysOn Replicas
- Using
Database Checkpoints
- Using Backup Devices
- Backing
Up Media Sets
- Performing
Backups
- Viewing Backup History
Lesson 3: Restoring SQL
Server Databases
- Restoring
Databases
- Performing
File Restores
- Performing
Page Restores
- Restoring a Database
Protected with Transparent Data
- Encryption
- Restoring
System Databases
- Restoring
Replicated Databases
- Checking
Database Status
Chapter 6
Securing SQL Server 2012
Lesson
1: Managing Database Permissions
- Understanding
Securable
- Assigning
Permissions on Objects
- Managing
Permissions by Using Database Roles
- Protecting
Objects from Modification
- Using
Schemas
- Determining
Effective Permissions
Lesson
2: Troubleshooting SQL Server Security
- Troubleshooting
Authentication
- Troubleshooting
Certificates and Keys
- Troubleshooting
Endpoints
- Using
Security Catalog Views
Lesson
3: Auditing SQL Server Instances
- Using
SQL Server Audit
- Configuring
Login Auditing
- Using c2
Audit Mode
- Common
Criteria Compliance
- Policy-Based Management
Chapter 7
Mirroring and Replication
Lesson 1: Mirroring
Databases
- Database Mirroring
- Mirroring
Prerequisites
- Configuring
Mirroring with Windows Authentication
- Configuring
Mirroring with Certificate Authentication
- Changing Operating Modes
- Role
Switching and Failover
- Monitoring
Mirrored Databases
- Upgrading
Mirrored Databases
Lesson 2: Database
Replication
- Replication
Architecture
- Replication
Types
- Snapshot
Replication
- Transactional
Replication
- Peer-to-Peer
Transactional Replication
- Merge
Replication
- Replication
Monitor
- Controlling Replication
of Constraints, Columns, and Triggers
- Heterogeneous
Data
Chapter 8
Clustering and Always On
Lesson
1: Clustering SQL Server 2012.
- Fulfilling
Edition Prerequisites
- Creating
a Windows Server 2008 R2 Failover Cluster
- Installing
a SQL Server Failover Cluster
- Multi-Subnet
Failover Clustering
- Performing
Manual Failover
- Troubleshooting
Failover Clusters
Lesson
2: AlwaysOn Availability Groups.
- What Are
AlwaysOn Availability Groups?
- Meeting
Availability Group Prerequisites
- Configuring
Availability Modes
- Selecting
Failover Modes
- Configuring
Readable Secondary Replicas
- Deploying
AlwaysOn Availability Groups
- Using
Availability Groups on Failover Cluster Instances
Chapter 9
Troubleshooting SQL Server
2012
Lesson 1: Working with
Performance Monitor
- Getting
Started with Performance Monitor
- Capturing
Performance Monitor Data
- Creating Data Collector
Sets
Lesson
2: Working with SQL Server Profiler
- Capturing
Activity with SQL Server Profiler
- Understanding
SQL Trace
- Reviewing Trace Output
- Capturing
Activity with Extended Events Profiler
Lesson
3: Monitoring SQL Server.
- Monitoring
Activity
- Working with Activity
Monitor
Lesson
4: Using the Data Collector Tool.
- Capturing
and Managing Performance Data
- Analyzing
Collected Performance Data
Lesson 5: Identifying
Bottlenecks
- Monitoring
Disk Usage
- Monitoring
Memory Usage
- Monitoring CPU Usage
Chapter 10
Indexes and Concurrency
Lesson
1: Implementing and Maintaining Indexes
- Understanding
the Anatomy of a Balanced Tree (B-Tree)
- Understanding
Index Types and Structures
- Designing
Indexes for Efficient Retrieval
- Understanding
Statistics
- Creating
and Modifying Indexes
- Tracking
Missing Indexes
- Reviewing
Unused Indexes
Lesson
2: Identifying and Resolving Concurrency Problems
- Defining
Transactions and Transaction Scope
- Understanding
SQL Server Lock Management
- Using
AlwaysOn Replicas to Improve Concurrency
- Detecting
and Correcting Deadlocks
- Using
Activity Monitor
- Diagnosing
Bottlenecks
- Using
Reports for Performance Analysis
Review and practice on all above
mentioned training.