Skulschus, M: MS SQL Server 2014. Implementierung - Softcover

Marco Skulschus; Marcus Wiederstein

Softcover

ISBN 10: 3939701955 ISBN 13: 9783939701958

Publisher: Comelio Medien, 2015

Synopsis

Content The MS SQL Server is the standard DB for .NET applications and Microsoft-based systems. This book shows DB developers and DB administrators how to build and manage a database and DB objects using T-SQL and MS SQL Server tools, as well as implement DB internal logic with procedures, functions, and triggers. Administration tasks such as optimization and tuning, security and backup/recovery are also covered. Target group The book is aimed at IT professionals and DB developers who want to set up and administrate the MS SQL Server as well as create programmable objects such as procedures, functions and triggers in the database with T-SQL. You can already perform queries and analytics with T-SQL and have basic knowledge of the SQL Server and the relational model. Topics overview of the MS SQL Server system and its tools T-SQL for DB objects, their management and their storage structures T-SQL for functions, procedures and triggers Optimization and tuning of queries and structures Administration, operation and security Backup and recovery administration via tools and T-SQL Internet On the website for the book you will find all T-SQL files for download. The example DB AdventureWorks is available from the Codeplex portal.

About this title

About the Author

Marco Skulschus und Marcus Wiederstein arbeiten als Projektleiter, Trainer und Berater bei der Comelio GmbH. Sie haben zusammen im Datenbankbereich bereits Bücher zu MS SQL Server und zu Oracle veröffentlicht. Sie beschäftigen sich seit der Version 2000 mit dem MS SQL Server für betriebswirtschaftliche Anwendungen und Business Intelligence-Systeme.

Edition details

• Publisher: Comelio Medien
• Publication date: 2015
• Language: German
• ISBN 10: 3939701955
• ISBN 13: 9783939701958
• Binding: Paperback
• Edition number: 1
• Number of pages: 504