Microsoft SQL Server 2012 Step by Step

Patrick LeBlanc (Autor)

Buch | Softcover

480 Seiten

2013
Microsoft Press,U.S. (Verlag)
978-0-7356-6386-2 (ISBN)

Titel ist leider vergriffen;
keine Neuauflage

Artikel merken

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.

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

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.

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

Erscheint lt. Verlag	15.2.2013
Reihe/Serie	Step by Step Developer
Verlagsort	Redmond
Sprache	englisch
Maße	189 x 228 mm
Gewicht	808 g
Themenwelt	Informatik ► Datenbanken ► Data Warehouse / Data Mining
Themenwelt	Informatik ► Datenbanken ► SQL Server
ISBN-10	0-7356-6386-6 / 0735663866
ISBN-13	978-0-7356-6386-2 / 9780735663862
Zustand	Neuware