Exam-Pack 70-432: Microsoft SQL Server 2008, Implementation and Maintenance
Includes 23 Videos
Trainer: Timothy L. Warner (Trainer Comments)
Running Time: 17 Hours
Data is the foundation of all networks, and how we access that data is the critical function of every IT system. As a database administrator you're the critical go-to person in your organization's IT department, because you're the one who manages and protects data access.
Becoming a great database designer and problem solver -- and having the certification to prove it -- means getting the right training. Whether you're an experienced SQL Server professional or a new database administrator, this CBT Nuggets video series is the perfect place to start.
Ace trainer Tim Warner gives you a broad overview of SQL Server 2008, including a full discussion of new features and comparison between SQL Server 2008 and earlier editions of the product (this information will be useful to upgraders).
But regardless of whether you're a new or existing database administrator (DBA), Tim provides you with a deep understanding of Microsoft's latest version of its enterprise relational database management system (RDBMS), SQL Server 2008.
Every video nugget in this series is loaded with practical tips, tricks, and Web/product references that both DBA newcomers and veterans will find valuable.
Plus, Tim has carefully mapped his training to Microsoft's 70-432 exam. Passing this exam earns you MCTS certification, and moves you just one test away from prestigious MCITP certification.
Microsoft Windows 2008 Network Infrastructure, Configuring contents:
- Series Overview
- Installing and Configuring SQL Server 2008 Part 1
- Installing and Configuring SQL Server 2008 Part 2
- Managing the SQL Server Agent Service
- Managing SQL Server Agent Jobs (free video)
Administering SQL Server Agent Alerts
Implementing Policy-Based Management
Managing SQL Server 2008 Security Part 1
Managing SQL Server 2008 Security Part 2
Managing SQL Server 2008 Security Part 3
Administering SQL Server 2008 Disaster Recovery Part 1
Administering SQL Server 2008 Disaster Recovery Part 2
Administering SQL Server 2008 Disaster Recovery Part 3
Administering SQL Server 2008 Disaster Recovery Part 4
Importing and Exporting Data
Implementing Data Partitions
Managing Indexes and Collations
Monitoring and Troubleshooting SQL Server 2008 Part 1
Monitoring and Troubleshooting SQL Server 2008 Part 2
Optimizing SQL Server 2008 Performance Part 1
Optimizing SQL Server 2008 Performance Part 2
Implementing High Availability Part 1
Implementing High Availability Part 2Exam pack 70-432 contains the following videos:
Video 1 - "Series Overview"
- Understanding this Series
- Tackling the 70-642 Exam
Video 2 - "Installing and configuring SQL Server 2008 part 1"
- In this nugget we gain our initial "sea legs" with the Microsoft SQL Server 2008 product. We cover the SQL Server 2008 installation process, service configuration, and answer the perennial question of every new (and sometimes seasoned) DBA? 'What exactly is an instance, and how is one configured?
- Installing SQL Server 2008 and Related Services
- Configuring SQL Server 2008 Services
- Configuring SQL Server 2008 Instances
Relevant Exam Objectives
Installing and Configuring SQL Server 2008Video 3 - "Installing and configuring SQL Server 2008 part 2"
- In this nugget we take a fresh install of SQL Server 2008 and manage that installation. We cover adding and removing product features, implementing Database Mail functionality, and enabling full-text indexing support for the Database Engine.
- Configuring Additional SQL Server Components
- Implementing Database Mail
- Configuring Full-Text Indexing and Free-Text Searching
Relevant Exam Objectives
Installing and Configuring SQL Server 2008Video 4 - "Managing the SQL Server agent service"
- In this nugget we undertake a detailed consideration of the SQL Server Agent, which represents the automation engine in SQL Server 2008. We cover the theoretical underpinnings of Agent, how to create operators, and how to manage operators for maximum administrative efficiency.
- Understanding the SQL Server Agent Service
- Creating Schedules
- Managing Operators
Relevant Exam Objectives
Maintaining SQL Server InstancesVideo 5 - "Managing SQL Server agent jobs"
- In this nugget we continue our journey through the wild and wooly world of SQL Server Agent. We cover the creation and management of SQL Server Agent jobs, and we learn how tightly integrated Agent is with the SQL Server Integration Services (SSIS) engine.
- Creating SQL Server Agent Jobs
- Understanding SSIS Integration with the SQL DB Engine
Relevant Exam Objectives
Maintaining SQL Server InstancesVideo 6 - "Administering SQL Server agent alerts"
- In this nugget we complete our meditation on SQL Server Agent, although this service will reappear several times throughout the remainder of this nugget series. We cover creating and administering SQL Server Agent alerts, and we learn how to centrally manage Agent jobs by leveraging the Master/Target (MSX/TSX) Agent architecture in SQL Server 2008.
- Creating and Managing SQL Server Agent Alerts
- Administering Multi-Server Agent Jobs
Relevant Exam Objectives
Maintaining SQL Server InstancesVideo 7 - "Implementing policy-based management"
- In this nugget we introduce of the most compelling new features in SQL Server 2008: Policy-Based Management. We cover the basics of this new feature, how to create policies, and how to centralize policy management across multiple SQL Server 2008 instances.
- Introducing Policy-Based Management
- Creating and Deploying Policies
- Centralizing Policy Management
Relevant Exam Objectives
Maintaining SQL Server InstancesVideo 8 - "Managing SQL Server 2008 security part 1"
- In this nugget we begin a three-part excursion into that most crucial of DBA topics: security. We cover SQL Server 2008 authentication planning, creating logins and server roles, and creating database users and database roles. We also explore the often-confused linkage between the login and the database user.
- Planning SQL Server Authentication
- Creating Logins and Server Roles
- Creating Users and Database Roles
Relevant Exam Objectives
Managing SQL Server SecurityVideo 9 - "Managing SQL Server 2008 security part 2"
- In this nugget we continue our "haunted hayride" through the mystical, magical world of SQL Server security. We cover such technologies as the logon trigger, the use of schema to assign object permissions, and the controversial tactic of enabling cross-database ownership chaining.
- Implementing Logon Triggers
- Using Schemas to Assign Object Permissions
- Administering Cross-Database Ownership Chaining and Impersonation
Relevant Exam Objectives
Managing SQL Server SecurityVideo 10 - "Managing SQL Server 2008 security part 3"
- In this nugget we complete our SQL Server 2008 security triptych. We cover how to audit a SQL Server 2008 instance and how to implement Transparent Data Encryption, or TDE. TDE is another much-anticipated new feature in SQL Server 2008, and is an extremely impressive technology.
- Auditing SQL Server 2008
- Implementing Transparent Data Encryption (TDE)
Relevant Exam Objectives
Managing SQL Server SecurityVideo 11 - "Administering SQL Server 2008 disaster recovery part 1"
- In this nugget we take on a subject that receives wide coverage on the 70-432 exam: disaster recovery. We cover the creation and configuration of databases, data files, transaction logs, and filegroups. We also learn how to set database options, configure database recovery models (this is another topic we revisit several times in upcoming nuggets), and attach/detach databases from the database engine.
Managing and Configuring SQL Server Databases
- Understanding Files and Filegroups
- Setting Database Options
- Configuring the Recovery Model
- Attaching and Detaching Databases
Relevant Exam Objectives
Maintaining a SQL Server DatabaseVideo 12 - "Administering SQL Server 2008 disaster recovery part 2"
- In this nugget we undertake the process of database backup in SQL Server 2008. We cover backup architecture, database backup, transaction log backup, data file backup, and filegroup backup.
- Understanding SQL Server Backup Strategies
- Performing Database and Log Backups
- Performing File and Filegroup Backups
Relevant Exam Objectives
Maintaining a SQL Server DatabaseVideo 13 - "Administering SQL Server 2008 disaster recovery part 3"
- In this nugget we examine the other side of the backup equation: data restoration. We cover the architectural and theoretical fundamentals of SQL Server 2008 restore and recovery. We then learn how to perform online and offline database restores.
- Understanding SQL Server 2008 Restore and Recovery
- Performing Online and Offline Restores
Relevant Exam Objectives
Maintaining a SQL Server DatabaseVideo 14 - "Managing SQL Server 2008 disaster recovery part 4"
- In this nugget we finish up our treatment of SQL Server disaster recovery. We cover database snapshots, ensuring database integrity, and we reintroduce maintenance plans (which we originally discussed in our nuggets on SQL Server Agent), this time applying them to disaster recovery.
- Managing Database Snapshots
- Maintaining Database Integrity
- Revisiting Maintenance Plans
Relevant Exam Objectives
Maintaining a SQL Server DatabaseVideo 15 - "Importing and exporting data"
- In this nugget we learn a crucial job function for most SQL Server DBAs: data import and export. We cover the mechanics of data import and data export, and then review the major import/export tools included in SQL Server 2008: the bcp utility, the BULK INSERT statement, the OPENROWSET function, the Import and Export Wizard, and the SSIS Import/Export tools.
- About Bulk Importing and Export Operations
- Using the BCP Utility
- Using the BULK INSERT T-SQL Statement
- Using the OPENROWSET T-SQL Function
- Using the Import and Export Wizard
- Introducing the SSIS Import/Export Tools
Relevant Exam Objectives
Performing Data Management TasksVideo 16 - "Implementing partitioned tables"
- In this nugget we tackle the subject of horizontally partitioning tables. We cover the theory of partitioned tables and indexes, creating partition functions and partition schemes, and managing partition operations.
- Understanding Partitioned Tables
- Creating Partition Functions
- Creating Partition Schemes
- Managing Partition Operations
Relevant Exam Objectives
Performing Data Management TasksVideo 17 - "Managing indexes and collations"
- In this nugget we turn our attention to what is perhaps the most important element to high-performance querying: indexes. We cover index architecture, index types (including the often-confused difference between clustered and non-clustered indexes), creating indexes, optimizing indexes, and, as a special bonus, a brief consideration on administering collations in SQL Server 2008.
- Understanding Indexes
- Creating Indexes
- Optimizing Indexes
- Administering Collations in SQL Server 2008
Relevant Exam Objectives
Performing Data Management TasksVideo 18 - "Monitoring and troubleshooting SQL Server 2008 part 1"
- In this nugget we will learn how to monitor and troubleshoot SQL Server 2008. We cover how transactions work (the ACID model, etc.), the SQL Server locking architecture, how to use Activity Monitor to diagnose and resolve concurrency problems, and using transaction-oriented DMVs.
- How Transactions Work
- Understanding SQL Server 2008 Locking Architecture
- Using Activity Monitor to Identify Concurrency Problems
- Leveraging Dynamic Management Views (DMVs)
Relevant Exam Objectives
Monitoring and Troubleshooting SQL ServerVideo 19 - "Monitoring and troubleshooting SQL Server 2008 part 2"
- In this nugget we carry over our discussion of monitoring and troubleshooting SQL Server 2008. We cover how to locate SQL Server 2008 event and error information. We also learn how to profile and monitor SQL Server 2008 by using tools such as SQL Server Profiler, the Performance Studio, System Monitor, and the Reliability and Performance Monitor.
- Locating SQL Server Error Information
- Profiling and Monitoring SQL Server 2008
Relevant Exam Objectives
Monitoring and Troubleshooting SQL ServerVideo 20 - "Optimizing SQL Server 2008 performance part 1"
- In this nugget we examine a couple ways in which we can dramatically improve the performance of our SQL Server Database Engine. We cover the Resource Governor, a brand-new feature in SQL Server 2008 that allows us to throttle and prioritize CPU and memory resources among SQL Server processes. We also learn how to tune databases using the DTA utility.
- Implementing Resource Governor
- Using the Database Engine Tuning Advisor (DTA)
Relevant Exam Objectives
Optimizing SQL Server PerformanceVideo 21 - "Optimizing SQL Server 2008 performance part 2"
- In this nugget we conclude our two-part mini-series on optimizing SQL Server 2008 performance. We cover using the brand-new Data Collection feature (called ??Performance Studio?? in pre-RTM), and the Windows Server 2008 Reliability and Performance Monitor tool.
- Using Performance Studio/Data Collection
- Using Reliability and Performance Monitor
Relevant Exam Objectives
Optimizing SQL Server PerformanceVideo 22 - "Implementing high availability part 1"
- In this nugget we examine another big 70-432 subject: high availability. We cover the basics of high availability services, configuring database mirroring (which protects a single database), and implementing failover clustering (which protects the entire SQL Server instance).
- Understanding High Availability
- Configuring Database Mirroring
- Implementing Failover Clustering
Relevant Exam Objectives
Implementing High AvailabilityVideo 23 - "Implementing high availability part 2"
:
- Implementing Log Shipping
- Implementing Replication
|
SetHome
Bookmark
Contact
Size:956 MB 
