Microsoft SQL Server 2012 Step by Step
Microsoft Press,U.S. (Verlag)
978-0-7356-6386-2 (ISBN)
- Titel ist leider vergriffen;
keine Neuauflage - Artikel merken
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 |
| Informatik ► Datenbanken ► SQL Server | |
| ISBN-10 | 0-7356-6386-6 / 0735663866 |
| ISBN-13 | 978-0-7356-6386-2 / 9780735663862 |
| Zustand | Neuware |
| Haben Sie eine Frage zum Produkt? |
aus dem Bereich
