Course Content
- Introduction
- Overview of Microsoft SQL Server 2012
- Business Intelligence Overview
- Database Engine
- T-SQL Programming Interface
- Security subsystem
- Replication
- Installing, Configuring, and Upgrading Microsoft SQL Server 2012
- Editions of SQL Server 2012
- Before Installation
- Installing SQL Server
- After Installation
- How to Upgrade to SQL Server 2012
- Using SQL Server 2012 Administration and Development Tools
- Using SQL Server Books Online
- Using SQL Server Management Studio
- Using SQL Server Data Tools
- Using SQL Server Configuration Manager
- Designing SQL Server Databases
- Understanding SQL Server System Databases
- Understanding the SQL Server Database Structure
- Creating Databases
- Adding Files and Filegroups
- Detaching and Attaching Databases
- Understanding Database Recovery Models
- Creating your First Table
- Understanding Schemas
- Understanding SQL Server Data Types
- Creating and Altering Tables
- Adding Constraints
- Building and Maintaining Indexes
- Index Structure Overview
- Creating Indexes
- Adding Index Options
- Disabling and Dropping Indexes
- Table Compression
- Understanding Row Compression
- Understanding Page Compression
- Estimating Effects of Compressions
- Compression Considerations
- Backups
- Understanding Backup Devices
- Full Database Backups
- Differential Database Backups
- Transaction Log Database Backups
- Restoring Databases
- Managing and Maintaining Indexes and Statistics
- Checking Index Fragmentation
- Defragmenting Indexes
- Creating and Updating Database Statistics
- Maintenance Plans
- Performing Database Consistency Checks
- Creating Maintenance Plans
- SQL Server Profiler and Extended Events
- Understanding SQL Server Profiler
- Creating Traces
- Understanding the Extended Event Architecture
- Creating and Configuring an Extended Events Session
- SQL Server Security
- Understanding Principals
- Creating Server Logins
- Creating User-defined Server Roles
- Creating Database Users
- Creating Database Roles
- Assigning Permissions
- Configuring Contained Databases
- SQL Server Agent
- SQL Server Agent Components
- Creating Operators
- Configuring Alerts
- Creating Jobs
- Working with Proxies
- Database Snapshots
- Understanding Database Snapshots
- Creating and Viewing Database Snapshots
- Dropping Database Snapshots
- Reverting t a Database Snapshot
- Dynamic Management Objects
- Retrieving SQL Server Metadata from DMOs
- Querying SQL Server Performance Statistics
- Querying Server Information
- Querying Indexing Statistics
- Overview of Views, User-defined Functions, and Stored Procedures (If Time Permits)
- What are Views
- Creating Indexed Views
- Understanding Scalar Functions
- Understanding Table-Valued Functions
- Working with Stored Procedures
- Using the EXECUTE Keyword
- Replication (If Time Permits)
- Types of Replication
- Replication Agents
- Configuring Replication
- Monitoring Replication
- Conclusion