Microsoft 70-432: Sql Server 2008, Implementation And Maintenance

Module 1: Installing Microsoft SQL Server

• 1.1 Introduction
• 1.2 Installing Microsoft SQL Server-Part 1
• 1.3 Installing Microsoft SQL Server-Part 2
• 1.4 Choosing A Collation Setting
• 1.5 Installing Microsoft SQL Server Demo

Module 2: Navigating SQL Server

• 2.1 Navigating SQL Server
• 2.2 Management Studio Demo
• 2.3 SQL Server Configuration Manager
• 2.4 SQL Server Configuration Manager Demo

Module 3: Data Types

• 3.1 Data Types

Module 4: Databases

• 4.1 Databases
• 4.2 Creating A Database
• 4.3 Creating A Database Demo

Module 5: Tables

• 5.1 Tables
• 5.2 Sparse Columns
• 5.3 Creating A Table Demo

Module 6: Views

• 6.1 Views
• 6.2 Creating A View Demo

Module 7: Constraints

• 7.1 Constraints
• 7.2 Creating A Constraint Demo

Module 8: Store Procedures

• 8.1 Store Procedures
• 8.2 Common Language Runtime
• 8.3 Store Procedures Demo

Module 9: Functions

• 9.1 Functions
• 9.2 Three Function Types
• 9.3 Functions Demo

Module 10: Service Broker

• 10.1 Service Broker
• 10.2 Using Service Broker

Module 11: Data Integrity

• 11.1 Data Integrity
• 11.2 Planning and Education (demo to be recorded)

Module 12: Permissions

• 12.1 Permissions

Module 13: Logins, Roles, and Credentials

• 13.1 Logins and Roles
• 13.2 More Roles and Credentials
• 13.3 Users and Roles Demo
• 13.4 Assigning A Role Demo

Module 14: Additional Security Tools

• 14.1 Additional Security Tools
• 14.2 Some Security Tools Demo

Module 15: Backing Up and Restoring Databases

• 15.1 Backups
• 15.2 Restoring Databases
• 15.3 Backups Demo

Module 16: Endpoints

• 16.1 Endpoints
• 16.2 Endpoints Demo

Module 17: Linking Servers

• 17.1 Linking Servers

Module 18: Triggers

• 18.1 Triggers-Part 1
• 18.2 Triggers-Part 2
• 18.3 Triggers Demo

Module 19: Replication

• 19.1 Replication
• 19.2 Replication Coverage-Part 1
• 19.3 Replication Coverage-Part 2
• 19.4 Replication Demo

Module 20: Performing Indexing and Full-Text Searching

• 20.1 Indexing
• 20.2 SQL Searching
• 20.3 Searching and Indexing In SQL Demo

Module 21: Transactions and Locks

• 21.1 Transactions
• 21.2 Locks
• 21.3 Locks Demo

Module 22: Moving Data

• 22.1 Moving Data

Module 23: Handling Specialty Data

• 23.1 Handling Specialty Data
• 23.2 XML Demo

Module 24: High-Availability Methods

• 24.1 High-Availability-Part 1
• 24.2 High-Availability-Part 2
• 24.3 Creating A Snapshot Demo

Module 25: Maintaining and Automating a SQL Server

• 25.1 Maintaining and Automating A SQL Server-Part 1
• 25.2 Maintaining and Automating A SQL Server-Part 2
• 25.3 Setting Up A SQL Email Demo

Module 26: Monitoring and Optimizing SQL Server

• 26.1 Monitoring and Optimizing SQL Server
• 26.2 Monitoring and Optimizing SQL Server Demo

Module 27: SQL Server Management Tools

• 27.1 SQL Server Management Tools-Part 1
• 27.2 SQL Server Management Tools-Part 2

Module 28: Troubleshooting Techniques

• 28.1 Troubleshooting Techniques-Part 1
• 28.2 Troubleshooting Techniques-Part 2
• 28.3 Troubleshooting Utilities Demo
• 28.4 Conclusion

We've put together a list of relevant job titles you can apply for after achieving the Microsoft 70-432: SQL Server 2008, Implementation and Maintenance certification (note that some careers may require further study, training and/or work experience):

• SQL Server Engineer
• SQL Server Specialist
• SQL Server Administrator
• SQL Server Analyst

• 

  Flexible Learning

  Study247 anytime, anywhere on any device.

• 

  World Class E-learning Platform

  Study in a user friendly, state-of-the-art e-learning platform.

• 

  Expert Instructor-Led Training

  Access step-by-step video tutorials delivered by leading industry experts.

• 

  Visual Demonstrations & Multimedia Presentations

  Develop your skills based on real world scenarios.

• 

  Quizzes & Mock Exam

  Interactive quizzes after each module and a mock exam at the end of your course to ensure you're fully prepared for your final certification exam.

• 

  Flash Cards & Educational Games

  Allow you to train in ways that keep you engaged and focus.

• 

  Social Learning & Networking

  Interact and collaborate with other students, form study groups, engage in discussions, rate different courses and stay up to date with all the latest industry knowledge.

• 

  Navigation & Controls

  Allows you to study in bite-size chunks. You can pause, rewind or fast forward your tutorials, take study notes and more.

As a bolt-on option, we offer Practice Labs as it provides users with an online lab platform to develop their practical skills in IT technologies such as CompTIA, Microsoft, Cisco and VMWare.

In addition to the hardware you require, you also gain access to high quality practical exercises covering exam topics to help you to maximize your study time and increase your results. Practice Labs are highly effective and offer a cheaper alternative to setting up your own test environment.

You will gain unlimited access to the Practice Labs for 12 months- helping you to consolidate your learning and prepare you for work.Learn More

When you enrol on a course with us, you automatically qualify for an XO student discount card which will enable you to enjoy savings from not only high street retailers, bars and restaurants, but also travel companies across the United Kingdom. Learn More