Course Duration
5 Days
Microsoft
Authorized Training
IT
Course cost:
was £3,425
£2,561
IT Certification Overview
This five-day, instructor-led course provides students who wish to administer and maintain SQL Server databases with the knowledge and skills to administer a SQL server database infrastructure.
Additionally, it will be of use to individuals who develop applications that deliver content from SQL Server databases.
Newto Training Reviews
What Our Happy Alumni Say About Us
I had absolutely no experience in this field, but Newto Training recognised my potential and supported me every step of the way. The real-life scenarios were invaluable in making me job-ready.
The tutors at Newto are consistently patient, clear and more than willing to help. I couldn't have asked for a better learning environment.
From day one I felt welcomed and supported. The live sessions were interactive and the resources well thought-out. I passed my exam on the first attempt thanks to them.
I was nervous about switching careers but the practical approach and continual 1-to-1 support gave me the confidence I needed to succeed."
The training material was excellent, and the instructors really brought the subject to life with hands-on lab work. I feel fully prepared for the workplace."
What impressed me most was the flexibility and responsiveness of the support team. Whenever I had a question, they were there even outside of normal hours.
The course structure was superb. A great mix of theory and practice delivered at a pace that made sense even for beginners. Highly recommended.
Switching into IT felt overwhelming, but Newto Training made the journey manageable and quite enjoyable. Their coaching style is top class.
I particularly appreciated the way complex topics were broken down into manageable chunks, and the tutor actively encouraged questions at every stage.
The live-taught interactive classes set Newto apart from other providers. It wasn't just video-based learning and the real engagement made all the difference.
The cyber course exceeded my expectations. They've been on hand for everything and are constantly in touch with me
The resources provided were spot on and the teaching style made everything easy to understand. I particularly appreciated the extra help offered when needed.
Enrolling with Newto was one of the best decisions I've made. The job-readiness focus, strong teaching and excellent support all stood out.
I completed my SQL course and now feel confident in my skills. The real-world examples and supportive tutors made it all click.
I've just passed my AZ-900 exam thanks to the support received from Ken in the boot camp and his exam preparation sessions.
I've gained a qualification and the confidence to use it in real-world scenarios.
Their commitment to student success is obvious from the personalised guidance to the quality of delivery. I'd recommend them without hesitation.
Every tutor I encountered was professional, encouraging and keen to see me succeed. That personal touch made a big difference.
I'm now in a role I once thought was out of reach, thank you to the all the team
The bootcamps were excellent, we were given practical projects to complete and I feel so much more confident with my coding skills
I had absolutely no experience in this field, but Newto Training recognised my potential and supported me every step of the way. The real-life scenarios were invaluable in making me job-ready.
The tutors at Newto are consistently patient, clear and more than willing to help. I couldn't have asked for a better learning environment.
From day one I felt welcomed and supported. The live sessions were interactive and the resources well thought-out. I passed my exam on the first attempt thanks to them.
I was nervous about switching careers but the practical approach and continual 1-to-1 support gave me the confidence I needed to succeed."
The training material was excellent, and the instructors really brought the subject to life with hands-on lab work. I feel fully prepared for the workplace."
What impressed me most was the flexibility and responsiveness of the support team. Whenever I had a question, they were there even outside of normal hours.
The course structure was superb. A great mix of theory and practice delivered at a pace that made sense even for beginners. Highly recommended.
Switching into IT felt overwhelming, but Newto Training made the journey manageable and quite enjoyable. Their coaching style is top class.
I particularly appreciated the way complex topics were broken down into manageable chunks, and the tutor actively encouraged questions at every stage.
The live-taught interactive classes set Newto apart from other providers. It wasn't just video-based learning and the real engagement made all the difference.
I had absolutely no experience in this field, but Newto Training recognised my potential and supported me every step of the way. The real-life scenarios were invaluable in making me job-ready.
The tutors at Newto are consistently patient, clear and more than willing to help. I couldn't have asked for a better learning environment.
From day one I felt welcomed and supported. The live sessions were interactive and the resources well thought-out. I passed my exam on the first attempt thanks to them.
I was nervous about switching careers but the practical approach and continual 1-to-1 support gave me the confidence I needed to succeed."
The training material was excellent, and the instructors really brought the subject to life with hands-on lab work. I feel fully prepared for the workplace."
What impressed me most was the flexibility and responsiveness of the support team. Whenever I had a question, they were there even outside of normal hours.
The course structure was superb. A great mix of theory and practice delivered at a pace that made sense even for beginners. Highly recommended.
Switching into IT felt overwhelming, but Newto Training made the journey manageable and quite enjoyable. Their coaching style is top class.
I particularly appreciated the way complex topics were broken down into manageable chunks, and the tutor actively encouraged questions at every stage.
The live-taught interactive classes set Newto apart from other providers. It wasn't just video-based learning and the real engagement made all the difference.
The cyber course exceeded my expectations. They've been on hand for everything and are constantly in touch with me
The resources provided were spot on and the teaching style made everything easy to understand. I particularly appreciated the extra help offered when needed.
Enrolling with Newto was one of the best decisions I've made. The job-readiness focus, strong teaching and excellent support all stood out.
I completed my SQL course and now feel confident in my skills. The real-world examples and supportive tutors made it all click.
I've just passed my AZ-900 exam thanks to the support received from Ken in the boot camp and his exam preparation sessions.
I've gained a qualification and the confidence to use it in real-world scenarios.
Their commitment to student success is obvious from the personalised guidance to the quality of delivery. I'd recommend them without hesitation.
Every tutor I encountered was professional, encouraging and keen to see me succeed. That personal touch made a big difference.
I'm now in a role I once thought was out of reach, thank you to the all the team
The bootcamps were excellent, we were given practical projects to complete and I feel so much more confident with my coding skills
The cyber course exceeded my expectations. They've been on hand for everything and are constantly in touch with me
The resources provided were spot on and the teaching style made everything easy to understand. I particularly appreciated the extra help offered when needed.
Enrolling with Newto was one of the best decisions I've made. The job-readiness focus, strong teaching and excellent support all stood out.
I completed my SQL course and now feel confident in my skills. The real-world examples and supportive tutors made it all click.
I've just passed my AZ-900 exam thanks to the support received from Ken in the boot camp and his exam preparation sessions.
I've gained a qualification and the confidence to use it in real-world scenarios.
Their commitment to student success is obvious from the personalised guidance to the quality of delivery. I'd recommend them without hesitation.
Every tutor I encountered was professional, encouraging and keen to see me succeed. That personal touch made a big difference.
I'm now in a role I once thought was out of reach, thank you to the all the team
The bootcamps were excellent, we were given practical projects to complete and I feel so much more confident with my coding skills
Prerequisites
In addition to their professional experience, students who attend this training should already have the following technical knowledge:
Essential:
- Basic knowledge of the Microsoft Windows operating system and its core functionality.
- Working knowledge of Transact-SQL (equivalent knowledge to QATSQL and QATSQLPLUS).
Nice to have:
- Working knowledge of relational databases.
- Some experience with database design.
Target audience
The primary audience for this course is individuals who administer and maintain SQL Server databases. These individuals perform database administration and maintenance as their primary area of responsibility, or work in environments where databases play a key role in their primary job.
Learning Objectives
By the end of this course, learners will be able to:
- Design and implement SQL Instances.
- Work with SQL databases.
- Describe recovery models and backup strategies.
- Backup SQL Server databases.
- Restore SQL Server databases.
- Authenticate and authorize users.
- Assign server and database roles.
- Authorize users to access resources.
- Protect data with encryption and auditing.
- Automate database management.
- Configure security for the SQL Server agent.
- Manage alerts and notifications.
Administering Microsoft SQL Server Course Content
SQL Overview
- This module introduces the main terms and concepts used within the administration of SQL Server instances and discusses the features of SQL architecture.
SQL Server Installation
- This module examines installing a SQL instance (default or named), selecting the services required, and reviewing installation options. The lessons covered include the considerations for installation, configuration of the tempdb database, default file locations, unattended installation using the GUI or command line, and upgrading SQL Server instances.
Working with SQL Databases
- This module covers data storage in SQL and the processes involved in creating and managing databases, including an introduction to the concepts of data integrity and indexes.
Backup and Restore SQL Databases
- This module covers all aspects of backing up and restoring databases.
SQL Server Authentication
- This module covers the setup and maintenance of logins and users, at both the instance and database levels, along with linked server authentication.
Server and Database Roles
- This module covers the creation and maintenance of security roles at the server and database level.
Database Object Security
- This module covers security for objects at the database level, such as tables, views, stored procedures, and functions.
Data Security
- This module covers additional methods of securing data, such as row and column security, data masking, auditing, and encryption.
Automating SQL Server management
- This module covers the automation of administration with the SQL Server instance.
Exams and assessments
There are no formal exams included in this course. Participants will complete interactive labs and knowledge checks to reinforce learning outcomes.
Hands-on learning
This course includes:
- Hands-on labs to apply key concepts in a real-world environment.
Administering Microsoft SQL Server Dates
Next 5 available training dates for this course
OFFER!
VIRTUAL
QA On-Line Virtual Centre
5 DAYS
|
ALL DAY
Mon 13 Apr 2026
FULL
was £3,425
£2,561
OFFER!
BOOK NOW
VIRTUAL
QA On-Line Virtual Centre
5 DAYS
|
ALL DAY
Mon 01 Jun 2026
AVAILABLE
was £3,425
£2,561
OFFER!
BOOK NOW
VIRTUAL
QA On-Line Virtual Centre
5 DAYS
|
ALL DAY
Mon 10 Aug 2026
AVAILABLE
was £3,425
£2,561
OFFER!
BOOK NOW
VIRTUAL
QA On-Line Virtual Centre
5 DAYS
|
ALL DAY
Mon 26 Oct 2026
AVAILABLE
was £3,425
£2,561
OFFER!
BOOK NOW
VIRTUAL
QA On-Line Virtual Centre
5 DAYS
|
ALL DAY
Mon 07 Dec 2026
AVAILABLE
was £3,425
£2,561
Advance Your Career with Administering Microsoft SQL Server
Gain the skills you need to succeed. Enrol in Administering Microsoft SQL Server with Newto Training today.