» » » PACKT PUBLISHING GETTING STARTED WITH SQL SERVER 2016 ADMINISTRATION TUTORIAL-OXBRiDGE

Bookmarks PACKT PUBLISHING GETTING STARTED WITH SQL SERVER 2016 ADMINISTRATION TUTORIAL-OXBRiDGE

PACKT PUBLISHING GETTING STARTED WITH SQL SERVER 2016 ADMINISTRATION TUTORIAL-OXBRiDGE
Name:
PACKT PUBLISHING GETTING STARTED WITH SQL SERVER 2016 ADMINISTRATION TUTORIAL-OXBRiDGE
Rating:
Users voted: 0
Language:
PACKT PUBLISHING GETTING STARTED WITH SQL SERVER 2016 ADMINISTRATION TUTORIAL-OXBRiDGE

PACKT PUBLISHING GETTING STARTED WITH SQL SERVER 2016 ADMINISTRATION TUTORIAL-OXBRiDGE|972.0 MB


Video Description
Configure, administer, and deploy a high-performance, highly available SQL Server

About This Video

Install and configure your SQL Server instance in a production environment

Optimize the performance of queries

Configure and monitor various High Availability solutions

A comprehensive, example-filled tutorial covering SQL Server 2016 administration in depth

In Detail

SQL Server DBAs enable efficient administration of its SQL Server solution to get breakthrough performance and top-notch security. This video will teach you basic as well as advanced administration tasks for handling, managing, and monitoring your SQL Server 2016 efficiently. After setting up and configuring your virtual machine for SQL Server 2016, you will implement various techniques to improve query performance, create indexes, and perform activity monitoring. You will learn how to secure your SQL Server solution by implementing various authentication techniques. Finally, you'll ensure your database is always available and ready for any catastrophe.

This comprehensive tutorial is packed with real-world examples and tips to solve the trickiest of challenges. By the end of this course, you will have a solid foundation in all SQL Server administration concepts and will be able to implement them in a production environment.

Table of Contents
Chapter 1 : Installing SQL Server 2016
The Course overview 00:02:04
Requirements and Recommendations 00:04:10
Installing SQL Server from the GUI 00:09:21
Installing SQL Server from the Command Line 00:04:05
Upgrading SQL Server 00:09:03
Chapter 2 : Login and User Security
Security Architecture 00:04:13
Server Logins 00:05:55
Built-in Server Roles 00:03:30
User-Defined Server Roles 00:04:56
Database Users 00:09:53
Built-in Database Roles 00:04:27
User-Defined Database Roles 00:09:53
Object Level Permissions 00:05:22
Chapter 3 : Databases
System Databases 00:05:39
User Databases 00:06:22
FileGroups 00:09:04
Database Options 00:05:44
Database Space 00:10:12
Chapter 4 : Administering Database Objects
Tables 00:08:16
Views 00:06:44
Stored Procedures 00:08:22
User-Defined Functions 00:15:56
Assemblies 00:07:18
Durable Memory-Optimized Tables 00:15:18
Non-Durable Memory-Optimized Tables 00:09:16
Chapter 5 : Improving Query Performance
Row Store Indexes 00:07:23
Clustered Indexes 00:06:27
Non-clustered Indexes 00:13:00
Columnstore Indexes 00:07:44
Nonclustered Columnstore Indexes 00:04:40
Indexed Views 00:05:38
Download link:


Links are Interchangeable - No Password - Single Extraction
UploadGIG.com
InformationWould you like to leave your comment and see hide contents ? Please Login to your account to leave comments. Don't have an account? You can create a free account now.