SQL Server 2016 Administration
Microsoft SQL Server 2016 is a powerful data platform that will help you quickly build solutions and insights across the organisation. With the further development of SQL Server Always On technologies, it provides near zero downtime. To benefit from such a powerful product, you will need to be able to identify, configure, and support all major aspects of Microsoft SQL Server 2016 databases.
Book your team training at your premises
- Date
- Venue
- Cost
- More info
- Date and time to suit you
- VenueWe will train your team
at your offices - CostContact us for price
- Fill in the form and we'll be in touch
within a working day.
Book your place
- There are no public, Worcester-based events for this course scheduled at the moment, but you can contact us to request a date or call 0800 018 5597
- Request dates at
Worcester Training Centre
The course covers essential topics in SQL Server Administration including installation, using policies, security, backup, recovery, availability management and monitoring. The course will include lectures, demonstrations and exercises to consolidate the topics covered.
Database administrators and support technicians who need to be able to implement and manage Microsoft SQL Server 2016 databases.
- Install an instance of SQL Server
- Create and Configure databases
- Backup and restore databases
- Maximise the availability of SQL Server
- Create logins
- Manage user and role permissions
- Prevent transaction logs from using unlimited disk space
- Monitor SQL Server databases
SQL Server has become a popular choice for enterprise wide applications. This course will give your organisation the confidence to exploit, manage and support this product both safely and securely. It will help ensure best practices are being followed with SQL Server
Many roles now require knowledge of SQL Server. This course will equip you with the skills to manage and support Microsoft SQL Server 2016. You will have confidence in the major topics for SQL Server administration.
- SQL Server 2016 Features
- Server Components
- Architecture
- Administering SQL Server 2016
- Installing SQL Server 2016
- SQL Server 2016 Editions
- System Requirements
- Performing SQL Server 2016 Setup
- Installing SQL Server 2016
- Installing SQL Server Management Studio
- Upgrading From Previous Versions of SQL Server
- Post-Installation Configuration
- Dedicated Administrator Connection
- Organising Data
- Post-Installation Databases
- Multiple Database Files for Tempdb
- Data Files and Transaction Logs
- Planning a Database
- Creating Databases
- Working with Filegroups
- Filestream Data
- File Tables
- Database Options
- Managing Databases
- SQL Server Security Terminology
- Authentication Modes
- Database Access Security
- Permissions and Securable
- Row-Level Security
- Policy-Based Management
- Data Encryption
- Auditing
- Simple Auditing
- Security Checklists
- Importing and Exporting Data
- Copying Databases with Management Studio
- Using the Import/Export Wizard
- Introduction to Integration Services
- Linked Servers
- Other Data Transfer Methods
- Disaster Recovery Fundamentals
- Basic Backup and Restore Operations
- Further Backup Concepts
- Further Recovery Concepts
- Backup Compression
- Backup Encryption
- Recovering System Databases
- SQL Server 2016 Database Availability
- Clustering SQL Server
- Database Snapshots
- AlwaysOn Availability Groups
- AlwaysOn Basic Availability Groups
- Database Mirroring
- Replication
- Configuration Replication
- Log Shipping
- Monitoring Systems
- Database Mail
- Using Operators and Alerts
- SQL Server Profiler and Extended Events
- Using Windows Performance Monitor
- SQL Server Logs
- Activity Monitor
- Performance Data Collection
- SQL Server Utility
- Managing Jobs
- Database Maintenance Plans
- Implementing Multi-Server Jobs
- Viewing the Execution Plan
- Using the Database Tuning Advisor
- Index Fragmentation
Delegates must have a good working knowledge of Microsoft SQL Server. This can be obtained by attending our SQL Server Essentials course. Delegates must have a basic knowledge of Microsoft Windows.