Microsoft 70-432: SQL Server 2008 Implementation and Maintenance
$49.00
Training for Microsoft exam 70-432, covering how to install, secure, back up and maintain SQL Server 2008 databases. It has 20 hours of training across 72 videos, for new and working DBAs.
- Login details sent straight after payment
- Self-paced. Study on any device
- StemBoss Certificate of Completion
- 14-day refund promise
Secure checkout. Pay by card, Apple Pay or Google Pay.
Microsoft 70-432: SQL Server 2008 Implementation and Maintenance teaches you how to install, run and look after SQL Server 2008 databases. It follows the topics of Microsoft exam 70-432 and is for database administrators and IT staff who keep SQL Server systems healthy. You get 20 hours of training across 72 videos, plus 58 test questions.
What you will learn
- How to install and configure SQL Server 2008
- How to secure a server and its databases with logins, users and permissions
- How to plan and run backups, and restore data when things go wrong
- How to monitor the server and fix common problems
- How to tune the server and queries for better performance
- How to set up high availability so databases stay online
- How to share data between servers with replication
- How to automate routine admin tasks
- How Integration Services fits into moving data
Topics covered
The course follows the main admin tasks tested in exam 70-432, from first install to day-to-day upkeep.
- Installation and configuration: setting up SQL Server 2008 and its services.
- Security: logins, users, roles and permissions.
- Backup and recovery: backup types, restore plans and recovery.
- Monitoring and troubleshooting: keeping the database server healthy.
- Performance: finding and fixing slow areas.
- High availability: keeping databases online.
- Data distribution: replication between servers.
- Automation: scheduling and maintaining admin tasks.
Who this course is for
- New database administrators who want a strong base
- Working DBAs who still support SQL Server 2008
- Systems administrators who look after SQL Server as part of their role
- Developers who want to understand how databases are run in production
- IT support staff who are asked to look after a SQL Server alongside other systems
Before you start
You should know what a database, a table and a query are. Some time using Windows Server or SQL Server will help. You do not need to be an expert, as the course explains each admin task step by step. If you are new to SQL, a short querying course first will make the lessons easier to follow. It also helps to have a test server, so you can try each task yourself without risk to live data.
About the 70-432 exam
Exam 70-432 was set by Microsoft. It tested your skills in installing, configuring and maintaining SQL Server 2008, and was one of two exams for the MCITP Database Administrator 2008 credential, alongside exam 70-450. Microsoft has since retired this exam, so you can no longer sit it. The admin skills it covers, such as backups, security and monitoring, still apply to later SQL Server versions, so the course remains a sound base for DBA work.
Jobs this course supports
- Database administrator
- SQL Server administrator
- Database support analyst
| Skill level | Intermediate |
|---|---|
| Duration | 20 Hours |
| Videos | 72 Course Videos |
| Questions | 58 Test Questions |
| Certification | MCITP: Database Administrator 2008 (retired) |
| Exam code | 70-432 |
| Certification body | Microsoft |
| Prerequisites | Basic database ideas and some time using Windows Server or SQL Server. |
| Best for | Database administrators, SQL Server support staff, systems administrators |
| Topics covered | Installation and configuration, security, backup and recovery, performance, high availability, replication, automation, monitoring |
| Format | Online video lessons, self-paced |
| Language | English |
| Certificate | StemBoss Certificate of Completion |
What is inside this course
31 modules and 73 lessons. Here is the full outline.
Module 15 lessons
- Introduction
- Installing Part 1
- Installing Part 2
- Installing Part 2 Demo 1
- Installing Part 2 Demo 2
Module 26 lessons
- Getting Familiar With SQL Part 1
- Getting Familiar With SQL Part 1 Demo
- Getting Familiar With SQL Part 2
- Getting Familiar With SQL Part 2 Demo
- Getting Familiar With SQL Part 3
- Getting Familiar With SQL Part 3 Demo
Module 32 lessons
- Data Types
- Data Types Demo
Module 45 lessons
- Databases Part 1
- Databases Part 1 Demo
- Databases Part 2
- Databases Part 2 Demo
- Databases Part 3
Module 52 lessons
- Tables
- Tables Demo
Module 6: Looking at Views5 lessons
- Views Part 1
- Views Part 1 Demo
- Views Part 2
- Views Part 2 Demo
- Views Part 3
Module 7: About Constraints3 lessons
- Constraints Part 1
- Constraints Part 1 Demo
- Constraints Part 2
Module 8: Looking at Stored Procedures3 lessons
- Stored Procedures Part 1
- Stored Procedures Part 1 Demo
- Stored Procedures Part 2
Module 9: Functions2 lessons
- Functions
- Functions Demo
Module 102 lessons
- Service Broker Part 1
- Service Broker Part 2
Module 112 lessons
- Data Integrity Part 1
- Data Integrity Part 2
Module 123 lessons
- Permissions Part 1
- Permissions Part 1 Demo
- Permissions Part 2
Module 132 lessons
- Logins Roles And Credentials
- Logins Roles And Credentials Demo
Module 142 lessons
- Additional Security Tools
- Additional Security Tools Demo
Module 153 lessons
- Backing Up And Restoring Databases Part 1
- Backing Up And Restoring Databases Part 2
- Backing Up And Restoring Databases Demo
Module 161 lessons
- Endpoints
Module 171 lessons
- Linking Servers
Module 181 lessons
- Triggers
Module 192 lessons
- Replication Part 1
- Replication Part 2
Module 201 lessons
- Performing Indexing And Full Text Searching
Module 211 lessons
- Transaction And Locks
Module 221 lessons
- Moving Data
Module 231 lessons
- Handling Specialty Data
Module 242 lessons
- High-Availability Methods Part 1
- High-Availability Methods Part 2
Module 251 lessons
- Maintaining And Automating SQL Server
Module 262 lessons
- Monitoring And Optimizing SQL Server
- Monitoring And Optimizing SQL Server Demo
Module 271 lessons
- SQL Server Management Tools
Module 28: Troubleshooting2 lessons
- Troubleshooting Techniques
- Troubleshooting Techniques Demo
Module 29: Course Review5 lessons
- Course Review Part 1
- Course Review Part 2
- Course Review Part 3
- Course Review Part 4
- Course Review Part 5
Module 30: Common Questions2 lessons
- Common Student Questions Part 1
- Common Student Questions Part 2
Module 31: Real World Scenarios2 lessons
- Real World Scenarios Part 1
- Real World Scenarios Part 2
Your learning path
Where Microsoft 70-432: SQL Server 2008 Implementation and Maintenance fits. Build your skills one step at a time.
Frequently asked questions
Can I still take Microsoft exam 70-432?
No. Microsoft has retired exam 70-432. The course is still useful for learning core SQL Server admin skills and for supporting SQL Server 2008 systems.
What does the 70-432 course cover?
It covers installing and configuring SQL Server 2008, security, backup and recovery, performance, high availability, replication and automating admin tasks.
Is this course for developers or administrators?
It is aimed at administrators. Developers can still benefit if they want to know how databases are run and protected.
What should I take after this course?
Move on to newer SQL Server courses, such as SQL Server 2019 Administration, to learn current versions.
How long is the course?
It runs for 20 hours across 72 videos and includes 58 test questions.
Do I get a certificate?
Yes. You get a StemBoss Certificate of Completion when you finish the course.
Can I get a refund?
Yes, within 14 days if you have completed less than 20% of the course. See our refund policy for details. Read the refund policy.
