SQL Server 2012 Black Book
ISBN: 9789350043073
1068 pages
eBook also available for institutional users
For more information write to us at: acadmktg@wiley.com
Description
It covers the entire spectrum of SQL Server 2012-Transact-Structured Query Language (T-SQL), SQL Server Management Studio (SSMS), SQL Server Data Tools (SSDT), Integrated Full-Text Search, Database Mirroring, Policy-Based Management, AlwaysOn Availability Groups, Reporting Services, Analysis Services, Integration Services, Master Data Services, Data Quality Services, and PowerPivot.
· Introducing SQL Server 2012
· Introducing SQL Server 2012 Tools
· Building SQL Server Databases
· SQL Statements, Operators, and Functions
· Programming with T-SQL - I
· Programming with T-SQL - II
· Stored Procedures and User-Defined Functions
· Triggers in SQL Server 2012
· Cursors in SQL Server 2012
· Managing Transactions and Locking
· Error Handling in SQL Server 2012
· Monitoring, Auditing, and Maintaining SQL Server
· Data Replication
· Log Shipping and Database Mirroring
· Implementing Failover Clustering
· Performing Bulk Copy Operations
· SQL Server Service Broker
· Policy-Based Management
· Automating SQL Server 2012
· Performance Optimization with Query Execution Plans
· Indexing and Partitioning
· Working with Full-Text Search
· Data Compression
· Resource Governor
· Security in SQL Server 2012
· Backing Up and Restoring Databases
· SQL Server Reporting Services
· SQL Server Analysis Services
· SQL Server Integration Services
· SQL Server 2012 and XML
· SQL Server 2012 and Common Language Runtime
· SQL Server 2012 and Language-Integrated Query