CBT Nuggets - Microsoft SQL Server 2008 Exam Pack 70-432 Date: 23 May 2011, 02:34
|
Video 1: Series Overview|18:12 Understanding this Series. Tackling the 70-642 Exam Video 2: Installing and Configuring SQL Server 2008 Part 1|50:14 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? Video 3: Installing and Configuring SQL Server 2008 Part 2|51:48 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. Video 4: Managing the SQL Server Agent Service|41:54 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. Video 5: Managing SQL Server Agent Jobs|43:49 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. Video 6: Administering SQL Server Agent alerts|44:56 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. Video 7: Implementing Policy-Based Management|47:44 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. Video 8: Managing SQL Server 2008 Security Part 1|52:06 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. Video 9: Managing SQL Server 2008 Security Part 2|53:15 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. Video 10: Managing SQL Server 2008 Security Part 3|47:07 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. Video 11: Administering SQL Server 2008 Disaster Recovery Part 1|45:11 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. Video 12: Administering SQL Server 2008 Disaster Recovery Part 2|42:25 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. Video 13: Administering SQL Server 2008 Disaster Recovery Part 3|41:20 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. Video 14: Administering SQL Server 2008 Disaster Recovery Part 4|47:09 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. Video 15: Importing and Exporting Data|51:02 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. Video 16: Implementing Data Partitions|26:13 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. Video 17: Managing Indexes and Collations|47:19 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. Video 18: Monitoring and Troubleshooting SQL Server 2008 Part 1|45:41 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. Video 19: Monitoring and Troubleshooting SQL Server 2008 Part 2|52:07 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. Video 20: Optimizing SQL Server 2008 Performance Part 1|44:14 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. Video 21: Optimizing SQL Server 2008 Performance Part 2|47:30 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. Video 22: Implementing High Availability Part 1|38:30 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). Video 23: Implementing High Availability Part 2|54:06 Implementing Log Shipping. Implementing Replication
|
DISCLAIMER:
This site does not store CBT Nuggets - Microsoft SQL Server 2008 Exam Pack 70-432 on its server. We only index and link to CBT Nuggets - Microsoft SQL Server 2008 Exam Pack 70-432 provided by other sites. Please contact the content providers to delete CBT Nuggets - Microsoft SQL Server 2008 Exam Pack 70-432 if any and email us, we'll remove relevant links or contents immediately.
|
|
|