SQL Server 2017: A Practical Guide for Beginners

SQL Server 2017: A Practical Guide for Beginners

AUTHOR: Gregory Blake

PUBLISHER: CSIPP

PAGES: 60

ISBN-10: 1975875060; ISBN-13: 978-1975875060

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

Book Category

Android Developer / Asp.Net / Asp.Net MVC / Blockchain / C# / C++ / Computer Science / Database / Game Developer / Java / JavaScript / jQuery / Linux / Maven / MS Sql / MySQL / Networking / Oracle / PHP / Python / Spring / VB.Net / Visual Studio / Web Developer

Disclaimer

Programming books display here are property of respective owners. All information about the book published in this website is in good faith and for general information purpose only.

Please support author by buying hardcopy to the nearest book store in your place or order books in publisher websites.

HRMS & Payroll Web Application

Benefits of adopting to Paperless Management

Paperless office as a sustainable business practice in Human Resource Management System (HRMS) on daily routine task that the system can do it automatically. Creating online job application can easily and quickly gather information that HR looking a candidates to hired a vacant position needed by the company from centralized data source. read more »

Paperless Payroll Automation Process

Through automated processing, the time you would have spent doing those tedious tasks is freed up for other, and focus on addressing errors, improving processes and delivering a better payroll results that could dramatically impact the future of payroll in your organization. read more »

Timekeeping System and Timesheet Processing

Paper timesheets daily time record is to track when employees start and end their work hours a day, but today's technologies used biometric finger scanner or other digital device to record daily time attendance In/Out. read more »

HRMS Employee Shift Schedule

Fixed shift schedule in every employee from Monday to Sunday is required during the processing of timesheet to get man-hour distribution report. This module designed a flexible shift because rest day work can occur in any days, just example of working in Shopping Mall that operates 7 days a week. read more »

HRMS Employee Online Account

Employee can check their available vacation leave, sick leave, pay slip or ability to work at home. Filing of overtime work, request temporary shift schedule and leave benefits is a convenient way using a paperless online form. read more »