Log In
Or create an account ->
Imperial Library
Home
About
News
Upload
Forum
Help
Login/SignUp
Index
Cover
Contents
Title
Copyright
Dedication
Acknowledgments
About the Author
Table of Exercises
Introduction
Part I: Introducing SQL Server 2012
Chapter 1: Understanding SQL Server’s Role
What Is Information Technology?
Introduction to Databases
Database Servers and Applications
SQL Server’s Role
Summary
Chapter Essentials
Chapter 2: Installing SQL Server 2012
Installation Planning
Installing a Default Instance
Installing Named Instances
Installing to a Cluster
Installing Extra Features
Upgrading from Previous Versions
Validating an Installation
Removing an Installation
Summary
Chapter Essentials
Chapter 3: Working with the Administration Tools
SQL Server Configuration Manager
SQL Server Management Studio
SQL Server Data Tools
SQL Server Profiler
Books Online
Windows Server Administration for the DBA
Summary
Chapter Essentials
Chapter 4: SQL Server Command-Line Administration
Introducing the Command Prompt
General Commands
Batch Files
Mastering SQLCMD
Introducing Windows PowerShell
Using SQL Server PowerShell Extensions
Summary
Chapter Essentials
Chapter 5: Querying SQL Server
Understanding the SQL Language
SQL Statement Types
SQL Syntactical Elements
Coding Recommendations
Using SELECT Statements
Advanced Query Techniques
Using DDL Statements
Using DCL Statements
Modifying Data
Tuning and Optimizing Queries
Summary
Chapter Essentials
Part II: Designing Database Solutions
Chapter 6: Database Concepts and Terminology
Relational Database Theory
Database Design Processes
Project Management for the DBA
Summary
Chapter Essentials
Chapter 7: ERD and Capacity Planning
Planning a Database
Understanding Entity Relationship Diagramming
Building an ERD
Capacity Planning
Summary
Chapter Essentials
Chapter 8: Normalization and Other Design Issues
Designing for Normalization
Designing for Performance
Designing for Availability
Designing for Security
Summary
Chapter Essentials
Part III: Implementing Database Solutions
Chapter 9: Creating SQL Server Databases
SQL Server Databases
Database Storage
Database Options and Properties
Creating Databases in the GUI
Creating Databases with T-SQL
Creating Databases with PowerShell
Attaching and Detaching Databases
Database Snapshots
Summary
Chapter Essentials
Chapter 10: Creating Tables
Data Types
Collations
Table Creation Process
Data Partitioning
Summary
Chapter Essentials
Chapter 11: Indexes and Views
Understanding Indexes
Creating Basic Indexes
Creating Advanced Indexes
Managing Indexes
Understanding Views
Creating Views
Summary
Chapter Essentials
Chapter 12: Triggers and Stored Procedures
Triggers Defined
Using Triggers
Creating Triggers
Understanding Stored Procedures
Creating Stored Procedures
Summary
Chapter Essentials
Chapter 13: Implementing Advanced Features
Understanding and Installing Analysis Services
Understanding Integration Services
Understanding and Installing Reporting Services
Implementing Database Mail
Configuring Full-Text Indexing
Implementing Transparent Data Encryption
Data Compression
Summary
Chapter Essentials
Part IV: Administering and Maintaining SQL Server 2012
Chapter 14: Creating Jobs, Operators, and Alerts
Standardize, Automate, and Update
Understanding SQL Server Jobs
Creating T-SQL Jobs
Creating SSIS Jobs
Creating Windows Command Jobs
Creating and Using Operators
Creating and Using Alerts
Using WSUS for SQL Server 2012
Summary
Chapter Essentials
Chapter 15: Performance Monitoring and Tuning
Performance Tuning Principles
Performance and Troubleshooting Tools
Blocks, Locks, and Deadlocks
SQL Server Profiler
Database Engine Tuning Advisor
Performance Monitoring with System Monitor
Using the Resource Governor
Performance Studio
Advanced Monitoring Tools
Summary
Chapter Essentials
Chapter 16: Policy-Based Management
Policy-Based Management
Centralized Server Management
Standardizing with PBM and CMS
Summary
Chapter Essentials
Chapter 17: Backup and Restoration
Backing Up a Database
Backing Up System Databases
Restoring a Database
Backing Up the Environment
Summary
Chapter Essentials
Part V: SQL Server Security
Chapter 18: Security Threats and Principles
Security Defined
Security Threats
Security Principles
Summary
Chapter Essentials
Chapter 19: Authentication and Encryption
Understanding Authentication
SQL Server Authentication Methods
Logins, Users, and Roles
Understanding Encryption
Summary
Chapter Essentials
Chapter 20: Security Best Practices
Establishing Baselines
Implementing Least Privilege
Auditing SQL Server Activity
Configuring the Surface Area
Understanding Common Criteria and C2
Summary
Chapter Essentials
Part VI: Implementing High Availability and Data Distribution
Chapter 21: AlwaysOn and High Availability
Introducing AlwaysOn Technology
Mirroring and AlwaysOn
Failover Solutions
Selecting Hardware for AlwaysOn
Summary
Chapter Essentials
Chapter 22: SQL Server Failover Clustering
Understanding Windows Failover Clustering Service
Implementing a Windows Cluster
Installing SQL Server 2012 to a Cluster
Monitoring and Managing a SQL Server Cluster
Summary
Chapter Essentials
Chapter 23: Database Mirroring and Snapshots
RAID-based Data Redundancy
Using Database Mirroring
Understanding Log Shipping
Implementing Database Snapshots
Summary
Chapter Essentials
Chapter 24: Implementing Replication
SQL Server Replication
Importing and Exporting Data
Summary
Chapter Essentials
Part VII: Implementing Business Intelligence and Reporting
Chapter 25: Data Warehousing
Understanding Data Warehouses
Implementing Fact Tables
Implementing Dimensions
Summary
Chapter Essentials
Chapter 26: SQL Server Integration Services
Integration Issues
Installing SSIS
Configuring SSIS Security Settings
Deploying Packages
SSIS Auditing and Event Handling
Extracting, Transforming, and Loading Data
Summary
Chapter Essentials
Chapter 27: Data Quality Solutions
Understanding Data Quality Concerns
Installing Data Quality Services
Using Master Data Services
Cleaning Data
Summary
Chapter Essentials
Appendices
Appendix A: Microsoft’s Certification Program
Appendix B: About the Additional Study Tools
← Prev
Back
Next →
← Prev
Back
Next →