SQL Server 2012 Black Book

Kogent Learning Solutions Inc.

ISBN: 9789350043073

1068 pages

INR 699

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