Microsoft 70-450: SQL Server 2008 PRO

What You'll Learn

• Video 1: Introduction and Overview|04:12

  Review the table of contents for this series of nuggets, and introduction to the SQL Server 2008 tools.

• Video 2: SQL Server 2008 Functional Concepts and Architecture|32:28

  Terminology; the purpose of SQL Server; the T-SQL language; Data Definition Language vs. Data Manipulation Language; and how databases work; How data is stored in pages, how filestreams and blobs work; other data types; the function of the transaction log; how database indexes work; and how database triggers work.

• Video 3: SQL Server 2008 Physical Concepts and Architecture|25:08

  CPU, memory, and storage concerns; SQL Server services; database physical architecture; database file placement strategies.

• Video 4: Planning a SQL Server 2008 Installation|28:32

  Planning for instances; planning for storage; planning for security; planning for availability.

• Video 5: Installing SQL Server 2008|18:00

  Preparing for the installation; performing the installation; verifying the installation; and launching SQL Server management tools.

• Video 6: Creating and Using a Database|25:31

  Creating a database; database options; creating a table; executing a query; managing the database file.

• Video 7: Migrating, Consolidating, and Upgrading|27:53

  Generation migration and consolidation concerns; instance configuration options; database configuration options; SQL Server version upgrades.

• Video 8: SQL Server Instance Security|15:05

  Instance-level authentication; instance-level security, including service accounts, endpoint security, TCP ports and SSL certificates, etc.

• Video 9: SQL Server Database Security|30:01

  Database and object security; ownership chains; designing security policies and audit plans; SQL Server encryption options, including Transparent Data Encryption (TDE).

• Video 10: High Availability Overview|24:50

  Goals of high availability; hardware; failover clustering; database mirroring; replication; and log shipping.

• Video 11: Backing up SQL Server|17:41

  Selecting a recovery model; backup compression options; selecting a backup type; scheduling backups; file and filegroup backup schemes; verifying backups; mirrored backups.

• Video 12: Restoring SQL Server|38:17

  Page, file, filegroup, and online restores; orphaned users; rebuilding a complete instance; encryption and recovery; recovery paths and forks; point-in-time and mark recovery; testing your recovery plan.

• Video 13: Database Mirroring and Clustering|33:10

  Mirroring: High performance, high protection, high availability; differences between mirroring and clustering; setting up mirroring; how clustering works; setting up clustering (differences from regular setup).

• Video 14: Monitoring SQL Server|22:41

  Monitoring options (system monitor, event logs, management views, WMI, remote monitoring, and triggers); data collectors; event notifications.

• Video 15: SQL Server Performance Optimization|18:56

  Dedicated Administrator Connection (DAC); locking and blocking, deadlocks, index utilization; Database Tuning Advisor.

• Video 16: Maintaining SQL Server|29:49

  Database maintenance plan; rebuilding and reorganizing indexes; how the Query Optimizer works; maintaining the Query Optimizer (statistics).

• Video 17: Managing SQL Server|22:02

  Managing resource utilization (Resource Governor and Query Governor); policy-based management; data compression strategies; automating SQL Server management (PowerShell, Agent, DDL triggers, etc).

• Video 18: Using SQL Server Agent|16:40

  Creating and managing jobs, proxies, multi-server administration, scheduling jobs.

• Video 19: Distributing Data with SQL Server Integration Services|17:18

  Introducing SSIS, SSIS package security options, scheduling SSIS packages, deploying SSIS packages.

• Video 20: Linked Servers and Replication|28:58

  Linked servers and connection strings; introducing replication, replication types; understanding replication conflicts; health monitoring for replication; horizontal and virtual partitioning in replication.