Available:*
Library | Item Barcode | Call Number | Material Type | Item Category 1 | Status |
|---|---|---|---|---|---|
Searching... | 30000010319122 | QA76.9.C55 L43 2013 | Open Access Book | Book | Searching... |
On Order
Summary
Summary
Your hands-on, step-by-step guide to building applications with Microsoft SQL Server 2012
Teach yourself the programming fundamentals of SQL Server 2012--one step at a time. Ideal for beginning SQL Server database administrators and developers, this tutorial provides clear guidance and practical, learn-by-doing exercises for building database solutions that solve real-world business problems.
Discover how to:
Install and work with core components and tools Create tables and index structures Manipulate and retrieve data Secure, manage, back up, and recover databases Apply techniques for building high-performing applications Use clustering, database mirroring, and log shippingAuthor Notes
Patrick LeBlanc is a Data Platform Technical Solution Professional at Microsoft, working directly with customers on the business value of SQL Server. He co-authored SharePoint 2010 Business Intelligence 24-Hour Trainer and Knight's Microsoft Business Intelligence 24-Hour Trainer, and founded www.sqllunch.com, a website devoted to teaching SQL Server technologies.
Table of Contents
| Introduction |
| 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 |
| Designing databases |
| Chapter 4 Designing SQL Server databases |
| Chapter 5 Creating your first table |
| Chapter 6 Building and maintaining indexes |
| Advanced database design topics |
| Chapter 7 Table compression |
| Chapter 8 Table partitioning |
| Chapter 9 Database snapshots |
| Chapter 10 The SELECT statement |
| Using Transact-SQL (T-SQL) |
| Chapter 11 Advanced data retrieval topics |
| Chapter 12 Modifying data |
| Chapter 13 Built-in scalar functions |
| Creating other database objects |
| Chapter 14 Advanced T-SQL topics |
| Chapter 15 Views |
| Chapter 16 User-defined functions |
| Chapter 17 Stored procedures |
| Chapter 18 Data manipulation triggers |
| SQL Server replication |
| Chapter 19 Replication |
| Database maintenance |
| Chapter 20 Backups |
| Chapter 21 Managing and maintaining indexes and statistics |
| Chapter 22 Maintenance plans |
| Database management |
| Chapter 23 SQL Server Profiler |
| Chapter 24 Extended Events |
| Chapter 25 SQL Server security |
| Chapter 26 Resource Governor |
| Chapter 27 SQL Server Agent |
| Chapter 28 Database Mail |
| Chapter 29 Data definition triggers |
| Chapter 30 Dynamic management objects |
| High-availability solutions |
| Chapter 31 AlwaysOn |
| Chapter 32 Log shipping |
| About the Author |
