
Microsoft SQL Server 2012 Step by Step
Description
Alles über E-Books | Antworten auf Fragen rund um E-Books, Kopierschutz und Dateiformate finden Sie in unserem Info- & Hilfebereich.
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
More details
Other editions
Additional editions

Person
Content
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
System requirements
File format: ePUB
Copy protection: Watermark-DRM (Digital Rights Management)
System requirements:
- Computer (Windows; MacOS X; Linux): Use a reading software that can process the file format ePUB: e.g., Adobe Digital Editions or FBReader – both free (see eBook Help).
- Tablet/Smartphone (Android; iOS): Before downloading, install the free app Adobe Digital Editions (see eBook Help).
- E-reader: Bookeen, Kobo, Pocketbook, Sony, Tolino and many more (not Kindle).
The file format ePUB works well for novels and non-fiction books – i.e., „flowing” text without complex layout. On an e-reader or smartphone, line and page breaks automatically adjust to fit the small displays.
This eBook uses Watermark-DRM, a „soft” copy protection. This means that there are no technical restrictions to prevent illegal distribution. However, there is a personalised watermark embedded in the eBook that can be used to identify the purchaser of the eBook in the event of misuse and to provide evidence for legal purposes.
For more information, see our eBook Help page.