Press esc to close
Press esc to close
Fill out your contact details below and our training experts will be in touch.
If you wish to make any changes to your course, please log a ticket and choose the category ‘booking change’
Back to Course Information
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 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.
This course prepares you for Exam 70-764, which is not included. This exam measures ability to accomplish technical tasks in the following areas:
Why choose us
Our easy to use Virtual platform allows you to sit the course from home with a live instructor. You will follow the same schedule as the classroom course, and will be able to interact with the trainer and other delegates.
Our fully interactive online training platform is compatible across all devices and can be accessed from anywhere, at any time. All our online courses come with a standard 90 days access that can be extended upon request. Our expert trainers are constantly on hand to help you with any questions which may arise.
This is our most popular style of learning. We run courses in 1200 locations, across 200 countries in one of our hand-picked training venues, providing the all important ‘human touch’ which may be missed in other learning styles.
All our trainers are highly qualified, have 10+ years of real-world experience and will provide you with an engaging learning experience.
We only use the highest standard of learning facilities to make sure your experience is as comfortable and distraction-free as possible
We limit our class sizes to promote better discussion and ensuring everyone has a personalized experience
Get more bang for your buck! If you find your chosen course cheaper elsewhere, we’ll match it!
This is the same great training as our classroom learning but carried out at your own business premises. This is the perfect option for larger scale training requirements and means less time away from the office.
Our courses can be adapted to meet your individual project or business requirements regardless of scope.
Cut unnecessary costs and focus your entire budget on what really matters, the training.
This gives your team a great opportunity to come together, bond, and discuss, which you may not get in a standard classroom setting.
Keep track of your employees’ progression and performance in your own workspace.
Course was run very smoothly, Richard our trainer was extremely knowledgeable and delivered the course in a succinct fashion with a twist of humour thrown in.
The course was great and the so was the trainer - brilliantly delivered and I would certainly recommend this course to my colleagues. Thanks to Richard for a great course and delivering it a tough environment virtually.
Richard was very knowledgeable and explained well
You won't find better value in the marketplace. If you do find a lower price, we will beat it.
Microsoft Silver Learning Partner
Flexible delivery methods are available depending on your learning style.
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
Retired: Administering a SQL Database Infrastructure M20764AUD5995
Retired: Provisioning SQL Databases M20765AUD5995
Total without package: AUD11990
Package price: AUD7195 (Save AUD4795)