SQL Server 2016 Administration
- Offered byPackt Publishing
SQL Server 2016 Administration at Packt Publishing Overview
Duration | 4 hours |
Total fee | ₹11,437 |
Mode of learning | Online |
Schedule type | Self paced |
Difficulty level | Intermediate |
Credential | Certificate |
SQL Server 2016 Administration at Packt Publishing Highlights
- This Course is offered by Packt Publishing
- Get Certificate of completion by the end of the course
- 4 Hours of Learning
- Start instantly and learn at your own schedule.
SQL Server 2016 Administration at Packt Publishing Course details
- IT Professionals
- How to install SQL Server
- Login and user security
- Creating user databases
- Administering database objects
- How to improve query performance
- 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.
SQL Server 2016 Administration at Packt Publishing Curriculum
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
Security Model Overview
Server Logins
Built-in Server Roles
User-DefinedServer Roles
Database Users
Built-in Database Roles
User-DefinedDatabase Roles
Object Level Permissions
Login and User Security
System Databases
User Databases
File Groups
Database Options
Database Space
Databases
Tables
Views
Stored Procedures
User-Defined Functions
Assemblies
Durable Memory-Optimized Tables
Non-Durable Memory-Optimized Tables
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