Product Details

About the Book: Microsoft SQL Server 2012 Step by Step Your hands-on, step-by-step guide to designing and managing databases with Microsoft SQL Server 2012. Teach yourself how to use SQL Server 2012-one step at a time. Ideal for beginning database administrators and developers, this tutorial provides practical, learn-by-doing exercises to help you design and manage databases, develop reports, and employ business intelligence systems. Discover how to: Install, configure, and upgrade SQL Server Work with core components and tools Save disk space and get better performance with compression Use TSQL to make changes to your data Simplify query writing and improve data access with reusable code Manage workload and resource consumption Maintain, back up, recover, and help secure databases Begin building efficient database solutions for your organization Build your first Windows? Store app andnbsp; Content Introduction Part I Getting started with Microsoft SQL Server 2012 Chapter 1 Overview of Microsoft SQL Server 2012 Chapter 2 Installing, Configuring, and Upgrading Microsoft SQL Server 2012 Chapter 3 Using SQL Server 2012 administration and development tools Part II Designing databases Chapter 4 Designing SQL Server databases Chapter 5 Creating your first table Chapter 6 Building and maintaining indexes Part III Advanced database design topics Chapter 7 Table compression Chapter 8 Table partitioning Chapter 9 Database snapshots Chapter 10 The SELECT statement Part IV Using Transact-SQL (T-SQL) Chapter 11 Advanced data retrieval topics Chapter 12 Modifying data Chapter 13 Built-in scalar functions Part V Creating other database object s Chapter 14 Advanced T-SQL topics Chapter 15 Views Chapter 16 User-defined functions Chapter 17 Stored procedures Chapter 18 Data manipulation triggers Part VI SQL Server replication Chapter 19 Replication Part VII Database maintenance Chapter 20 Backups Chapter 21 Managing and maintaining indexes and statistics Chapter 22 Mainte