پیشنهاد فرادرس

آموزش شروع کار با مدیریت SQL Server 2016

دسته بندی ها: آموزش SQL Server ، پایگاه داده ، آموزش های Packtpub
آیا این نوشته را دوست داشتید؟
Getting Started with SQL Server 2016 Administration [Video] Publisher:Packtpub Author:Steve Jones Duration:3 hours and 49 minutes

Configure, administer, and deploy a high-performance, highly available SQL Server
Getting Started with SQL Server 2016 Administration [Video]
Released: Friday, April 28, 2017

Installing SQL Server 2016
The Course overview
Recommendations and Requirements
Installing SQL Server from the GUI
Installing SQL Server from the Command Line
Upgrading SQL Server

Login and User Security
Security Model Overview
Server Logins
Built-in Server Roles
User-DefinedServer Roles
Database Users
Built-in Database Roles
User-DefinedDatabase Roles
Object Level Permissions

Databases
System Databases
User Databases
File Groups
Database Options
Database Space

Administering Database Objects
Tables
Views
Stored Procedures
User-Defined Functions
Assemblies
Durable Memory-Optimized Tables
Non-Durable Memory-Optimized Tables

Improving Query Performance
Tables
Clustered Indexes
Non-clustered Indexes
Columnstore Indexes
Nonclustered Columnstore Indexes
Indexed Views

پیشنهاد فرادرس

لینک های دانلود حجم فایل: 986.0MB Packtpub Getting Started with SQL Server 2016 Administration [Video]_git.ir.rar