Microsoft SQL Server 2016

Name: Microsoft SQL Server 2016
Author: Dusan Petkovic

A Beginner's Guide

Paperback Engels 2016 1e druk 9781259641794

51,92

In winkelwagen

Verwachte levertijd ongeveer 8 werkdagen

Samenvatting

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

Get up and running on Microsoft SQL Server 2016 in no time with help from this thoroughly revised, practical resource. The book offers thorough coverage of SQL management and development and features full details on the newest business intelligence, reporting, and security features.

Filled with new real-world examples and hands-on exercises, Microsoft SQL Server 2016: A Beginner's Guide, Sixth Edition, starts by explaining fundamental relational database system concepts. From there, you will learn how to write Transact-SQL statements, execute simple and complex database queries, handle system administration and security, and use the powerful analysis and BI tools. XML, spatial data, and full-text search are also covered in this step-by-step tutorial.

- Revised from the ground up to cover the latest version of SQL Server
- Ideal both as a self-study guide and a classroom textbook
- Written by a prominent professor and best-selling author

Specificaties

ISBN13:9781259641794

Trefwoorden:Database applicatie, Database Server, SQL Server 2016

Taal:Engels

Bindwijze:paperback

Aantal pagina's:896

Uitgever:McGraw-Hill

Druk:1

Verschijningsdatum:1-11-2016

Hoofdrubriek:IT-management / ICT

Lezersrecensies

Wees de eerste die een lezersrecensie schrijft!

Schrijf een recensie

Uw cijfer

?

Log in om te stemmen

Inhoudsopgave

Part 1: Basic Concepts
1. Relational Database Systems: An Introduction
2. Planning the Installation and Installing SQL Server
3. SQL Server Management Studio

Part 2: Transact-SQL Language
4. SQL Components
5. Data Definition Language
6. Queries
7. Modification of a Table's Contents
8. Stored Procedures and User-Defined Functions
9. System Catalog
10. Indices
11. Views
12. Security System of the Database Engine
13. Concurrency Control
14. Triggers

Part 3: System Administration
15. System Environment of the Database Engine
16. Backup, Recovery and System Availability
17. Automating System Administration
18. Data Replication
19. Query Optimizer
20. Performance Tuning
21. In-Memory OLTP

Part 4: SQL Server and Business Intelligence
22. Business Intelligence: An Introduction
23. SQL Server Analysis Services
24. Business Intelligence and Transact-SQL
25. SQL Server Reporting Services
26. Optimizing Techniques for Data Warehousing
27. Columnstore Indices

Part 5: Beyond Relational Data
28. XML and JSON Support
29. Spatial and Temporal Data
30. SQL Server Full-Text Search