SQL Server 2017: A Practical Guide for Beginners

Gregory Blake

ISBN 10: 1975875060 / ISBN 13: 9781975875060

Editore: Createspace Independent Publishing Platform, 2017

Riguardo questo articolo

This item is printed on demand. New copy - Usually dispatched within 5-9 working days 121. Codice articolo C9781975875060

Dati bibliografici

Titolo: SQL Server 2017: A Practical Guide for ...

Casa editrice: Createspace Independent Publishing Platform

Data di pubblicazione: 2017

Legatura: Paperback

Condizione: New

Descrizione articolo

Riassunto:

This book is a guide for you on how to use SQL Server 2017. It begins by guiding you on how to get SQL Server 2017 installed on the various operating systems, including the Server Core. After a successful installation of SQL Server 2017, it comes with only a number of features enabled, while the other features are disabled. This is for the reduction of the features which can be attacked by any potential attacker. This book guides you on how to enable, disable, and perform a number of configurations on the various SQL Server 2017 features. You are then guided on how to create a new database in SQL Server 2017. You will also learn how to play around with this database by adding data to it, adding log files to the database, changing the size of the database, and even modifying the data contained in the database. Note that the book guides you on how to do this by use of both SQL Server Management Studio and Transact-SQL. The process of creating User-defined Data Type Aliases in SQL Server 2017 is also discussed. The process of backing a SQL Server 2017 database is explored. You will learn the various ways to do this, as well how to restore the database. The following topics are discussed in this book:-Installing Microsoft SQL Server 2017-Surface Area Configuration-Creating a Database-Creating User-Defined Data Type Alias-Creating a Full Database Backup-Restoring a Database