Up-to-date Microsoft SQL Server 2019 skills made easy! Get up and running on Microsoft SQL Server 2019 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 machine learning, BI, reporting, and security features. Filled with new examples and hands-on exercises, Microsoft SQL Server 2019: A Beginner's Guide, Seventh Edition, starts by explaining fundamental relational database system concepts. From there, you will learn how to write Transact-SQL statements; execute simple…mehr
Up-to-date Microsoft SQL Server 2019 skills made easy! Get up and running on Microsoft SQL Server 2019 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 machine learning, BI, reporting, and security features. Filled with new examples and hands-on exercises, Microsoft SQL Server 2019: A Beginner's Guide, Seventh 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 management, backup, and security; and use the powerful analysis and BI tools. XML, spatial data, and full-text search are also covered in this complete and rigorous introductory guide. . Revised from the ground up to cover the latest version of SQL Server . Designed for new users as well as experienced users who are migrating to SQL Server 2019 . Written by a prominent professor and best-selling author
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: Installation of SQL Server Chapter 3: Front-end Systems of SQL Server 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: 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 ROLAP Chapter 27: Columnstore Indices Chapter 28: Intelligent Query Processing PART 5: Beyond Relational Data Chapter 29: SQL/JSON Support Chapter 30: Spatial and Temporal Data Chapter 31: Graph Databases PART 6: Machine Learning Chapter 31: Support for R Chapter 32: Support for the Python Language
PART 1: Basic Concepts Chapter 1: Relational Database Systems: An Introduction Chapter 2: Installation of SQL Server Chapter 3: Front-end Systems of SQL Server 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: 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 ROLAP Chapter 27: Columnstore Indices Chapter 28: Intelligent Query Processing PART 5: Beyond Relational Data Chapter 29: SQL/JSON Support Chapter 30: Spatial and Temporal Data Chapter 31: Graph Databases PART 6: Machine Learning Chapter 31: Support for R Chapter 32: Support for the Python Language
Es gelten unsere Allgemeinen Geschäftsbedingungen: www.buecher.de/agb
Impressum
www.buecher.de ist ein Shop der buecher.de GmbH & Co. KG Bürgermeister-Wegele-Str. 12, 86167 Augsburg Amtsgericht Augsburg HRA 13309