官术网_书友最值得收藏!

What this book covers

Chapter 1, Linux Distributions, covers the basics of supported Linux distributions. You will learn about openSUSE and Ubuntu distributions and will be prepared for the installation procedure.

Chapter 2, Installation and Configuration, covers key points about the installation and initial configuration of SQL Server on Linux. You will learn how to install SQL Server on Linux on the openSUSE and Ubuntu distributions.

Chapter 3, SQL Server Basics, is about the SQL Server architecture and concepts, and how they differ from other database platforms.

Chapter 4, Database in the Sandbox, is about using DDL and DML sets of SQL statements in the SQL Server environment. You will learn how to create, modify, and delete a database and its objects, and how to implement INSERT, SELECT, DELETE, and update statements.

Chapter 5, Sample Databases, teaches you how to find and install SQL Server samples. You will learn how to restore a sample database and browse through its structure and objects.

Chapter 6, Crash Course in Querying, shows you how to write efficient queries on SQL Server samples. The readers will learn to write SELECT statements on one or more tables in combination with different sets of operators and functions.

Chapter 7, Backup and Recovery Operations, is about understanding and creating backup procedures inside your database environment. The process of restoring is equally as important as backing up. This chapter will also teach you how to create and implement an efficient restore procedure.

Chapter 8, User Management, focusses on the user management process using the security features of SQL Server. You will learn how to implement new logins and map procedures to specific assets on SQL Server.

Chapter 9, Implementing Data Protection, is focused on data protection using the built-in support for encryption. If you want to prevent and minimize the consequences of data breaches, then this is the right chapter for you.

Chapter 10, Indexing, explains how to use different types of indexing to achieve better performance for your SQL code. The reader will learn how to recognize bottlenecks inside databases and apply the appropriate indexing methods.

Chapter 11, In-Memory OLTP, shows the readers how to implement different types of in-memory OLTP features.

Chapter 12, Beyond SQL Server, takes you on a beautiful journey through the rest of the features and tools that can be used in SQL Server development.

主站蜘蛛池模板: 时尚| 青川县| 元谋县| 文安县| 小金县| 南城县| 静海县| 城口县| 即墨市| 佛学| 花莲县| 蓬莱市| 额敏县| 卢氏县| 巴中市| 凌海市| 仁化县| 双峰县| 措勤县| 庐江县| 南平市| 万载县| 福海县| 特克斯县| 周口市| 汶川县| 嘉峪关市| 刚察县| 泸水县| 子长县| 东港市| 南投市| 阿荣旗| 定襄县| 长岛县| 平顶山市| 乐清市| 德惠市| 工布江达县| 宁陵县| 姜堰市|