Opis: Microsoft SQL Server 2012 Step by Step - Patrick LeBlanc

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 shipping* * 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

Szczegóły: Microsoft SQL Server 2012 Step by Step - Patrick LeBlanc

Tytuł: Microsoft SQL Server 2012 Step by Step
Autor: Patrick LeBlanc
Producent: Microsoft Press
ISBN: 9780735663862
Rok produkcji: 2013
Ilość stron: 432
Oprawa: Miękka
Waga: 0.81 kg

Recenzje: Microsoft SQL Server 2012 Step by Step - Patrick LeBlanc