O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Microsoft 70-432: SQL Server 2008 Implementation and Maintenance

Video Description

This course will cover the following topics to prepare students for the 70-432 SQL Server 2008 Implementation and Maintenance exam: how to install and configuring SQL Server 2008, maintaining SQL Server instances, managing SQL Server security, maintaining a SQL Server database, performing data management tasks, monitoring and troubleshooting SQL Server, optimizing SQL Server performance, and implementing high availability.while preparing for the CICD exam. Describe the components of a Cisco Collaboration solution, and identify call flows and signaling types Provide an overview interfaces for both administration and end-users in Cisco Unified Communications Manager, Cisco Unified Communications Manager Express, Cisco Unity Connection, and Cisco Unified Communications Manager IM and Presence Service. Understand call flows in Cisco Unified Communications Manager and Cisco Unified Communications Manager Express Perform endpoint and end-user administration tasks in Cisco Unified Communications Manager and Cisco Unified Communications Manager Express Describe telephony features supported in CUCM and CUCME Administer users in Cisco Unity Connection and Cisco Unified Communications Manager IM and Presence Service, and enable the most commonly used features Describe how to maintain a Cisco Collaboration Solution

Table of Contents

  1. Module 1: Installing Microsoft SQL Server
    1. Introduction 00:02:04
    2. Installing Microsoft SQL Server-Part 1 00:12:35
    3. Installing Microsoft SQL Server-Part 2 00:07:15
    4. Choosing A Collation Setting 00:07:15
    5. Installing Microsoft SQL Server Demo 00:08:15
  2. Module 2: Navigating SQL Server
    1. Navigating SQL Server 00:03:54
    2. Management Studio Demo 00:02:20
    3. SQL Server Configuration Manager 00:05:56
    4. SQL Server Configuration Manager Demo 00:02:17
  3. Module 3: Data Types
    1. Data Types 00:09:43
  4. Module 4: Databases
    1. Databases 00:16:24
    2. Creating A Database 00:07:13
    3. Creating A Database Demo 00:01:58
  5. Module 5: Tables
    1. Tables 00:09:14
    2. Sparse Columns 00:08:17
    3. Creating A Table Demo 00:03:23
  6. Module 6: Views
    1. Views 00:14:02
    2. Creating A View Demo 00:03:00
  7. Module 7: Constraints
    1. Constraints 00:10:17
    2. Creating A Contsraint Demo 00:02:06
  8. Module 8: Store Procedures
    1. Store Procedures 00:09:12
    2. Common Language Runtime 00:09:20
    3. Store Procedures Demo 00:03:01
  9. Module 9: Functions
    1. Functions 00:07:03
    2. Three Function Types 00:06:42
    3. Functions Demo 00:03:06
  10. Module 10: Service Broker
    1. Service Broker 00:10:35
    2. Using Service Broker 00:07:29
  11. Module 11: Data Integrity
    1. Data Integrity 00:16:07
    2. Planning And Education (demo to be recorded) 00:14:23
  12. Module 12: Permissions
    1. Permissions 00:10:50
  13. Module 13: Logins, Roles, and Credentials
    1. Logins And Roles 00:11:08
    2. More Roles And Credentials 00:06:45
    3. Users And Roles Demo 00:06:26
    4. Assigning A Role Demo 00:01:50
  14. Module 14: Additional Security Tools
    1. Additional Security Tools 00:12:42
    2. Some Security Tools Demo 00:02:58
  15. Module 15: Backing Up and Restoring Databases
    1. Backups 00:14:57
    2. Restoring Databases 00:14:16
    3. Backups Demo 00:04:46
  16. Module 16: Endpoints
    1. Endpoints 00:04:29
    2. Endpoints Demo 00:01:37
  17. Module 17: Linking Servers
    1. Linking Servers 00:08:57
  18. Module 18: Triggers
    1. Triggers-Part 1 00:09:59
    2. Triggers-Part 2 00:07:17
    3. Triggers Demo 00:03:25
  19. Module 19: Replication
    1. Replication 00:09:50
    2. Replication Coverage-Part 1 00:10:59
    3. Replication Coverage-Part 2 00:11:41
    4. Replication Demo 00:04:52
  20. Module 20: Performing Indexing and Full-Text Searching
    1. Indexing 00:12:44
    2. SQL Searching 00:10:12
    3. Searching And Indexing In SQL Demo 00:03:08
  21. Module 21: Transactions and Locks
    1. Transactions 00:08:45
    2. Locks 00:09:45
    3. Locks Demo 00:03:38
  22. Module 22: Moving Data
    1. Moving Data 00:06:41
  23. Module 23: Handling Specialty Data
    1. Handling Specialty Data 00:11:32
    2. XML Demo 00:03:51
  24. Module 24: High-Availability Methods
    1. High-Availability-Part 1 00:12:17
    2. High-Availability-Part 2 00:10:54
    3. Creating A Snapshot Demo 00:02:30
  25. Module 25: Maintaining and Automating a SQL Server
    1. Maintaining And Automating A SQL Server-Part 1 00:09:29
    2. Maintaining And Automating A SQL Server-Part 2 00:06:21
    3. Setting Up A SQL Email Demo 00:04:18
  26. Module 26: Monitoring and Optimizing SQL Server
    1. Monitoring And Optimizing SQL Server 00:09:03
    2. Monitoring And Optimizing SQL Server Demo 00:03:00
  27. Module 27: SQL Server Management Tools
    1. SQL Server ManagementTools-Part 1 00:06:05
    2. SQL Server ManagementTools-Part 2 00:07:51
  28. Module 28: Troubleshooting Techniques
    1. TroubleshootingTechniques-Part 1 00:09:59
    2. TroubleshootingTechniques-Part 2 00:07:32
    3. Troubleshooting Utilities Demo 00:06:07
    4. Conclusion 00:00:33