Send us your message.
XWe have your course. Please kindly fill below your contact details to receive full course information and pricing.
Send us your message.
X
Project Management (17)
Business Analysis (7)
Business Improvement (10)
IT Service Management (10)
IT Security (12)
Data Protection & Compliance (15)
Office Applications (10)
Business Skills (16)
Programming & Database (12)
Microsoft Technical (13)
Technical IT (13)
Advanced Technology (8)
Available delivery methods for this course
Online Instructor-Led
Online Self-Paced
In-house
Classroom
Many people are switching to our Home Virtual Classes so they can keep on learning just like they would in a classroom.
Our live classroom courses have many advantages compared to other methods of learning.
Ask questions, share documents and communicate with your trainer and peers.
All you need is a computer, webcam and microphone and you’re all set.
No need to leave where you live or work.
An affordable way to boost your career.
With an incredibly easy to use interface, our chosen platform has been designed to make learning online simple and enjoyable. It’s amazing video & audio quality means you won’t miss a thing.
Works on all devices
Recording & transcripts
See your trainer’s screen
Share documents
Virtual whiteboard
Select your preferred delivery method
All Online Instructor-Led courses are delivered in real-time
Easy 1 click access
Works on all devices
Duration: 5 Days*
Accredited: Yes
Support: 24/7
This 5-day official Microsoft classroom course teaches delegates the knowledge and skills required to administer a SQL Server database infrastructure. Delegates will also learn the basics of servers and how they are connected.
Many other skills such as creating authorisation for users and using custom database roles and application roles to manage database-level security are also taught during this Microsoft technical certification.
The following modules are covered during this course:
Module 1: SQL Server Security
Lab: Authenticating Users
Module 2: Assigning Server and Database Roles
Lab: Assigning server and database roles
Module 3: Authorizing Users to Access Resources
Lab: Authorizing users to access resources
Module 4: Protecting Data with Encryption and Auditing
Lab: Using Auditing and Encryption
Module 5: Recovery Models and Backup Strategies
Lab: Understanding SQL Server recovery models
Module 6: Backing Up SQL Server Databases
Lab: Backing Up Databases
Module 7: Restoring SQL Server 2016 Databases
Lab: Restoring SQL Server Databases
Module 8: Automating SQL Server Management
Lab: Automating SQL Server Management
Module 9: Configuring Security for SQL Server Agent
Lab: Configuring Security for SQL Server Agent
Module 10: Monitoring SQL Server with Alerts and Notifications
Lab: Monitoring SQL Server with Alerts and Notifications
Module 11: Introduction to Managing SQL Server by using PowerShell
Lab: Using PowerShell to Manage SQL Server
Module 12: Tracing Access to SQL Server with Extended events
Lab: Extended Events
Module 13: Monitoring SQL Server
Module 14: Troubleshooting SQL Server
Lab: Troubleshooting Common Issues
Module 15: Importing and Exporting Data
Lab: Importing and Exporting Data
The course is aimed at those who can administer and maintain SQL Server databases as part of their daily responsibilities. It is also suitable for those who develop applications which deliver content from SQL Server databases.
You should have the following knowledge and experience before attending this course:
This course prepares you for Exam 70-764, which is not included. This exam measures ability to accomplish technical tasks in the following areas:
You won't find better value in the marketplace. If you do find a lower price, we will beat it.
Trusted & Approved
Microsoft Silver Learning Partner
Various delivery methods
Flexible delivery methods are available depending on your learning style.
Resources
Resources are included for a comprehensive learning experience.
"Really good course and well organised. Trainer was great with a sense of humour - his experience allowed a free flowing course, structured to help you gain as much information & relevant experience whilst helping prepare you for the exam"
Joshua Davies, Thames Water
"...the trainer for this course was excellent. I would definitely recommend (and already have) this course to others."
Diane Gray, Shell
Due to the high volume of calls, please call *+61 1-800-150644* for new sales or log a ticket here for existing bookings. Courses are planned as normal unless you have been told otherwise. Thank you for your patience.
Call now