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

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.

主站蜘蛛池模板: 贵州省| 耒阳市| 山阴县| 武汉市| 临颍县| 京山县| 镇平县| 平原县| 华阴市| 卓尼县| 奎屯市| 日喀则市| 丽江市| 五常市| 富顺县| 安图县| 鄱阳县| 舞阳县| 莲花县| 吐鲁番市| 义马市| 交城县| 大田县| 武强县| 永州市| 崇左市| 望江县| 乌拉特后旗| 东港市| 桐柏县| 荣昌县| 新和县| 沙河市| 鄂托克前旗| 刚察县| 柳州市| 吕梁市| 旅游| 同仁县| 锡林浩特市| 鄱阳县|