Microsoft 70-432: SQL Server 2008, Implementation and Maintenance with Practice Lab

My Training Academy
My Training Academy

Course

Online

Save 49%

Special Emagister price

£ 99 £ 195 VAT inc.

Description

  • Type

    Course

  • Methodology

    Online

  • Start date

    Different dates available

"Course Description

The MCTS 70-432 Training Course TS: Microsoft SQL Server 2008, Implementation and Maintenance teaches students how to install and configure SQL Server 2008, maintain SQL Server instances and databases, manage SQL Server security, perform data management, optimize performance, monitor and troubleshoot SQL Server and implement high availability with SQL Server 2008.

As part of this course package, learners will also have access to an online Practice Lab to develop their practical skills whilst learning. Practice Labs makes studying for an exam or learning new technologies an engaging experience, as It offers:

Exam based practical tasks
Real equipment, absolutely no simulations
Access to the latest industry technologies
Available anytime, anywhere on any device
Break and Reset functionality
No hardware or licensing costs

After completing this course, you will learn the skills and knowledge required to work effectively in a professional IT environment and prepared for the Microsoft 70-432 exam. Get the skills employers are currently looking for, enrol today!"

Important information

Price for Emagister users:

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

About this course

"Who Is This Course For?

IT professionals that want to learn how to install, configure and maintain Microsoft SQL Server 2008.

By choosing online learning instead of a classroom based course, it eliminates the need for time away from work, saving you valuable time and money. It is ideal for those with tight schedules as our online courses give you 12 months unlimited access to all the course materials, so you can study at a pace that suits you. Allowing you to easily resume your studies whenever you have the time. All you need is internet connection to study, so you can study from the comfort of your home or any environment that suits you."

"Requirements

Our training works on all devices including Mobile phones, IPad’s, Android tablets, Macs and PC’s.

For the best viewing experience on our state-of-the-art eLearning platform we recommend an internet connection of 10Mbps or better. Please also use Google Chrome or Mozilla Firefox as your browser with Adobe Flash Player."

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Monitoring
  • Access
  • Transactions
  • XML training
  • XML
  • Server
  • Email
  • Database
  • SQL
  • Database training
  • Planning

Course programme

"

Course Outline


Course Outline

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


Module 1: Installing Microsoft SQL Server


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

  • 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


    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

  • 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


    Module 3: Data Types
    • 3.1 Data Types

  • 3.1 Data Types

    • Module 4: Databases


    Module 4: Databases
    • 4.1 Databases
    • 4.2 Creating A Database
    • 4.3 Creating A Database Demo

  • 4.1 Databases

  • 4.2 Creating A Database

  • 4.3 Creating A Database Demo

    • Module 5: Tables


    Module 5: Tables
    • 5.1 Tables
    • 5.2 Sparse Columns
    • 5.3 Creating A Table Demo

  • 5.1 Tables

  • 5.2 Sparse Columns

  • 5.3 Creating A Table Demo

    • Module 6: Views


    Module 6: Views
    • 6.1 Views
    • 6.2 Creating A View Demo

  • 6.1 Views

  • 6.2 Creating A View Demo

    • Module 7: Constraints


    Module 7: Constraints
    • 7.1 Constraints
    • 7.2 Creating A Constraint Demo

  • 7.1 Constraints

  • 7.2 Creating A Constraint Demo

    • Module 8: Store Procedures


    Module 8: Store Procedures
    • 8.1 Store Procedures
    • 8.2 Common Language Runtime
    • 8.3 Store Procedures Demo

  • 8.1 Store Procedures

  • 8.2 Common Language Runtime

  • 8.3 Store Procedures Demo

    • Module 9: Functions


    Module 9: Functions
    • 9.1 Functions
    • 9.2 Three Function Types
    • 9.3 Functions Demo

  • 9.1 Functions

  • 9.2 Three Function Types

  • 9.3 Functions Demo

    • Module 10: Service Broker


    Module 10: Service Broker
    • 10.1 Service Broker
    • 10.2 Using Service Broker

  • 10.1 Service Broker

  • 10.2 Using Service Broker

    • Module 11: Data Integrity


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

  • 11.1 Data Integrity

  • 11.2 Planning and Education (demo to be recorded)

    • Module 12: Permissions


    Module 12: Permissions
    • 12.1 Permissions

  • 12.1 Permissions

    • Module 13: Logins, Roles, and Credentials


    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

  • 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


    Module 14: Additional Security Tools
    • 14.1 Additional Security Tools
    • 14.2 Some Security Tools Demo

  • 14.1 Additional Security Tools

  • 14.2 Some Security Tools Demo

    • Module 15: Backing Up and Restoring Databases


    Module 15: Backing Up and Restoring Databases
    • 15.1 Backups
    • 15.2 Restoring Databases
    • 15.3 Backups Demo

  • 15.1 Backups

  • 15.2 Restoring Databases

  • 15.3 Backups Demo

    • Module 16: Endpoints


    Module 16: Endpoints
    • 16.1 Endpoints
    • 16.2 Endpoints Demo

  • 16.1 Endpoints

  • 16.2 Endpoints Demo

    • Module 17: Linking Servers


    Module 17: Linking Servers
    • 17.1 Linking Servers

  • 17.1 Linking Servers

    • Module 18: Triggers


    Module 18: Triggers
    • 18.1 Triggers-Part 1
    • 18.2 Triggers-Part 2
    • 18.3 Triggers Demo

  • 18.1 Triggers-Part 1

  • 18.2 Triggers-Part 2

  • 18.3 Triggers Demo

    • Module 19: Replication


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

  • 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


    Module 20: Performing Indexing and Full-Text Searching
    • 20.1 Indexing
    • 20.2 SQL Searching
    • 20.3 Searching and Indexing In SQL Demo

  • 20.1 Indexing

  • 20.2 SQL Searching

  • 20.3 Searching and Indexing In SQL Demo

    • Module 21: Transactions and Locks


    Module 21: Transactions and Locks
    • 21.1 Transactions
    • 21.2 Locks
    • 21.3 Locks Demo

  • 21.1 Transactions

  • 21.2 Locks

  • 21.3 Locks Demo

    • Module 22: Moving Data


    Module 22: Moving Data
    • 22.1 Moving Data

  • 22.1 Moving Data

    • Module 23: Handling Specialty Data


    Module 23: Handling Specialty Data
    • 23.1 Handling Specialty Data
    • 23.2 XML Demo

  • 23.1 Handling Specialty Data

  • 23.2 XML Demo

    • Module 24: High-Availability Methods


    Module 24: High-Availability Methods
    • 24.1 High-Availability-Part 1
    • 24.2 High-Availability-Part 2
    • 24.3 Creating A Snapshot Demo

  • 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


    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

  • 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


    Module 26: Monitoring and Optimizing SQL Server
    • 26.1 Monitoring and Optimizing SQL Server
    • 26.2 Monitoring and Optimizing SQL Server Demo

  • 26.1 Monitoring and Optimizing SQL Server

  • 26.2 Monitoring and Optimizing SQL Server Demo

    • Module 27: SQL Server Management Tools


    Module 27: SQL Server Management Tools
    • 27.1 SQL Server Management Tools-Part 1
    • 27.2 SQL Server Management Tools-Part 2

  • 27.1 SQL Server Management Tools-Part 1

  • 27.2 SQL Server Management Tools-Part 2

    • Module 28: Troubleshooting Techniques


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

  • 28.1 Troubleshooting Techniques-Part 1

  • 28.2 Troubleshooting Techniques-Part 2

  • 28.3 Troubleshooting Utilities Demo

  • 28.4 Conclusion

    • "

    See related categories

    Microsoft 70-432: SQL Server 2008, Implementation and Maintenance with Practice Lab

    Special Emagister price

    £ 99 £ 195 VAT inc.