Dusan Petkovic

Microsoft SQL Server 2016: A Beginner's Guide, Sixth Edition

• Broschiertes Buch

Produktbeschreibung

Up-to-date Microsoft SQL Server 2016 skills made easy!

Produktdetails

• Verlag: McGraw-Hill Education
• 6 ed
• Seitenzahl: 896
• Erscheinungstermin: 16. November 2016
• Englisch
• Abmessung: 231mm x 189mm x 48mm
• Gewicht: 1298g
• ISBN-13: 9781259641794
• ISBN-10: 1259641791
• Artikelnr.: 44891657

Autorenporträt

Dusan Petkovic (Germany) is a professor in the Department of Computer Science at the Polytechnic in Rosenheim, Germany. He frequently contributes to SQL Server Magazine and has published 8 other computer books in Germany for Addison Wesley and McGraw-Hill.

Inhaltsangabe

Part 1: Basic Concepts
Chapter 1: Relational Database Systems: An Introduction
Chapter 2: Planning the Installation and Installing SQL Server
Chapter 3: SQL Server Management Studio
Part 2: Transact-SQL Language
Chapter 4: SQL Components
Chapter 5: Data Definition Language
Chapter 6: Queries
Chapter 7: Modification of a Table's Contents
Chapter 8: Stored Procedures and User-Defined Functions
Chapter 9: System Catalog
Chapter 10: Indices
Chapter 11: Views
Chapter 12: Security System of the Database Engine
Chapter 13: Concurrency Control
Chapter 14: Triggers
Part 3: System Administration
Chapter 15: System Environment of the Database Engine
Chapter 16: Backup, Recovery and System Availability
Chapter 17: Automating System Administration
Chapter 18: Data Replication
Chapter 19: Query Optimizer
Chapter 20: Performance Tuning
Chapter 21: In-Memory OLTP
Part 4: SQL Server and Business Intelligence
Chapter 22: Business Intelligence: An Introduction
Chapter 23: SQL Server Analysis Services
Chapter 24: Business Intelligence and Transact-SQL
Chapter 25: SQL Server Reporting Services
Chapter 26: Optimizing Techniques for Data Warehousing
Chapter 27: Columnstore Indices
Part 5: Beyond Relational Data
Chapter 28: XML and JSON Support
Chapter 29: Spatial and Temporal Data
Chapter 30: SQL Server Full-Text Search