puer_dux
27-02-2009, 04:35 PM
http://www.cbtnuggets.com/images/products/920.jpgCBT Nuggets Microsoft SQL Server 2008: Exam-Pack 70-450
Elearning | Video | 487 MB ( 655 MB unpacked)
Exam Information:
This video series is mapped to Microsoft's 70-450 exam. Passing this exam moves you closer to being a fully-certified Database Administrator (DBA). When combined with MCTS SQL Server 2008, Implementation and Maintenance certification (exam 70-432), you earn prestigious MCITP Certification for SQL Server 2008. (Training for MCTS exam 70-432 will be available from CBT Nuggets later this year.)
Exam pack 70-450 contains the following videos:
* Introduction and Overview
* SQL Server 2008 Functional Concepts and Architecture
* SQL Server 2008 Physical Concepts and Architecture
* Planning a SQL Server 2008 Installation
* Installing SQL Server 2008
* Creating and Using a Database
* Migrating, Consolidating, and Upgrading
* SQL Server Instance Security
* SQL Server Database Security
* High Availability Overview
* Backing up SQL Server
* Restoring SQL Server
* Database Mirroring and Clustering (free video)
* Monitoring SQL Server
* SQL Server Performance Optimization
* Maintaining SQL Server
* Managing SQL Server
* Using SQL Server Agent
* Distributing Data with SQL Server Integration Services
* Linked Servers and Replication
Here's what you'll learn in each video of the Microsoft SQL Server 2008: Exam-Pack 70-450 Series:
Video 1 - "Introduction and Overview" - 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" - 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" - CPU, memory, and storage concerns; SQL Server services; database physical architecture, database file placement strategies.
Video 4 - "Planning a SQL Server 2008 Installation" - Planning for instances, planning for storage, planning for security, planning for availability.
Video 5 - "Installing SQL Server 2008" - Preparing for the installation, performing the installation, verifying the installation, and launching SQL Server management tools.
Video 6 - "Creating and Using a Database" - Creating a database, database options, creating a table, executing a query, managing the database file.
Video 7 - "Migrating, Consolidating, and Upgrading" - Generation migration and consolidation concerns, instance configuration options, database configuration options, SQL Server version upgrades.
Video 8 - "SQL Server Instance Security" - Instance-level authentication, instance-level security - including service accounts, endpoint security, TCP ports and SSL certificates, etc.
Video 9 - "SQL Server Database Security" - 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" - Goals of high availability, hardware, failover clustering, database mirroring, replication, and log shipping.
Video 11 - "Backing up SQL Server" - 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" - 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" - 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" - Monitoring options (system monitor, event logs, management views, WMI, remote monitoring, and triggers), data collectors, event notifications.
Video 15 - "SQL Server Performance Optimization" - Dedicated Administrator Connection (DAC), locking and blocking, deadlocks, index utilization, Database Tuning Advisor.
Video 16 - "Maintaining SQL Server" - Database maintenance plans, rebuilding and reorganizing indexes, how the Query Optimizer works, maintaining the Query Optimizer (statistics).
Video 17 - "Managing SQL Server" - 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" - Creating and managing jobs, proxies, multi-server administration, scheduling jobs.
Video 19 - "Distributing Data with SQL Server Integration Services" - Introducing SSIS, SSIS package security options, scheduling SSIS packages, deploying SSIS packages.
Video 20 - "Linked Servers and Replication" - Linked servers and connection strings, introducing replication, replication types, understanding replication conflicts, health monitoring for replication, horizontal and virtual partitioning in replication.
http://rapidshare.com/files/202909235/agcnmsqls2k8.nfo
http://rapidshare.com/files/202909800/agcnmsqls2k8.part01.rar
http://rapidshare.com/files/202909447/agcnmsqls2k8.part02.rar
http://rapidshare.com/files/202909828/agcnmsqls2k8.part03.rar
http://rapidshare.com/files/202909794/agcnmsqls2k8.part04.rar
http://rapidshare.com/files/202909803/agcnmsqls2k8.part05.rar
http://rapidshare.com/files/202909839/agcnmsqls2k8.part06.rar
http://rapidshare.com/files/202909403/agcnmsqls2k8.part07.rar
http://rapidshare.com/files/202909797/agcnmsqls2k8.part08.rar
http://rapidshare.com/files/202909879/agcnmsqls2k8.part09.rar
http://rapidshare.com/files/202909823/agcnmsqls2k8.part10.rar
http://rapidshare.com/files/202909816/agcnmsqls2k8.part11.rar
http://rapidshare.com/files/202909573/agcnmsqls2k8.part12.rar
http://rapidshare.com/files/202909843/agcnmsqls2k8.part13.rar
http://rapidshare.com/files/202909592/agcnmsqls2k8.part14.rar
http://rapidshare.com/files/202909738/agcnmsqls2k8.part15.rar
http://rapidshare.com/files/202909871/agcnmsqls2k8.part16.rar
http://rapidshare.com/files/202909422/agcnmsqls2k8.part17.rar
http://rapidshare.com/files/202909821/agcnmsqls2k8.part18.rar
http://rapidshare.com/files/202909624/agcnmsqls2k8.part19.rar
http://rapidshare.com/files/202909621/agcnmsqls2k8.part20.rar
http://rapidshare.com/files/202914592/agcnmsqls2k8.part21.rar
http://rapidshare.com/files/202914612/agcnmsqls2k8.part22.rar
http://rapidshare.com/files/202914322/agcnmsqls2k8.part23.rar
http://rapidshare.com/files/202914581/agcnmsqls2k8.part24.rar
http://rapidshare.com/files/202914633/agcnmsqls2k8.part25.rar
http://rapidshare.com/files/202914591/agcnmsqls2k8.part26.rar
http://rapidshare.com/files/202914311/agcnmsqls2k8.part27.rar
http://rapidshare.com/files/202914455/agcnmsqls2k8.part28.rar
http://rapidshare.com/files/202914571/agcnmsqls2k8.part29.rar
http://rapidshare.com/files/202914506/agcnmsqls2k8.part30.rar
http://rapidshare.com/files/202914570/agcnmsqls2k8.part31.rar
http://rapidshare.com/files/202914580/agcnmsqls2k8.part32.rar
http://rapidshare.com/files/202914604/agcnmsqls2k8.part33.rar
http://rapidshare.com/files/202914348/agcnmsqls2k8.part34.rar
http://rapidshare.com/files/202914151/agcnmsqls2k8.part35.rar
http://rapidshare.com/files/202914118/agcnmsqls2k8.sfv
Elearning | Video | 487 MB ( 655 MB unpacked)
Exam Information:
This video series is mapped to Microsoft's 70-450 exam. Passing this exam moves you closer to being a fully-certified Database Administrator (DBA). When combined with MCTS SQL Server 2008, Implementation and Maintenance certification (exam 70-432), you earn prestigious MCITP Certification for SQL Server 2008. (Training for MCTS exam 70-432 will be available from CBT Nuggets later this year.)
Exam pack 70-450 contains the following videos:
* Introduction and Overview
* SQL Server 2008 Functional Concepts and Architecture
* SQL Server 2008 Physical Concepts and Architecture
* Planning a SQL Server 2008 Installation
* Installing SQL Server 2008
* Creating and Using a Database
* Migrating, Consolidating, and Upgrading
* SQL Server Instance Security
* SQL Server Database Security
* High Availability Overview
* Backing up SQL Server
* Restoring SQL Server
* Database Mirroring and Clustering (free video)
* Monitoring SQL Server
* SQL Server Performance Optimization
* Maintaining SQL Server
* Managing SQL Server
* Using SQL Server Agent
* Distributing Data with SQL Server Integration Services
* Linked Servers and Replication
Here's what you'll learn in each video of the Microsoft SQL Server 2008: Exam-Pack 70-450 Series:
Video 1 - "Introduction and Overview" - 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" - 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" - CPU, memory, and storage concerns; SQL Server services; database physical architecture, database file placement strategies.
Video 4 - "Planning a SQL Server 2008 Installation" - Planning for instances, planning for storage, planning for security, planning for availability.
Video 5 - "Installing SQL Server 2008" - Preparing for the installation, performing the installation, verifying the installation, and launching SQL Server management tools.
Video 6 - "Creating and Using a Database" - Creating a database, database options, creating a table, executing a query, managing the database file.
Video 7 - "Migrating, Consolidating, and Upgrading" - Generation migration and consolidation concerns, instance configuration options, database configuration options, SQL Server version upgrades.
Video 8 - "SQL Server Instance Security" - Instance-level authentication, instance-level security - including service accounts, endpoint security, TCP ports and SSL certificates, etc.
Video 9 - "SQL Server Database Security" - 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" - Goals of high availability, hardware, failover clustering, database mirroring, replication, and log shipping.
Video 11 - "Backing up SQL Server" - 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" - 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" - 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" - Monitoring options (system monitor, event logs, management views, WMI, remote monitoring, and triggers), data collectors, event notifications.
Video 15 - "SQL Server Performance Optimization" - Dedicated Administrator Connection (DAC), locking and blocking, deadlocks, index utilization, Database Tuning Advisor.
Video 16 - "Maintaining SQL Server" - Database maintenance plans, rebuilding and reorganizing indexes, how the Query Optimizer works, maintaining the Query Optimizer (statistics).
Video 17 - "Managing SQL Server" - 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" - Creating and managing jobs, proxies, multi-server administration, scheduling jobs.
Video 19 - "Distributing Data with SQL Server Integration Services" - Introducing SSIS, SSIS package security options, scheduling SSIS packages, deploying SSIS packages.
Video 20 - "Linked Servers and Replication" - Linked servers and connection strings, introducing replication, replication types, understanding replication conflicts, health monitoring for replication, horizontal and virtual partitioning in replication.
http://rapidshare.com/files/202909235/agcnmsqls2k8.nfo
http://rapidshare.com/files/202909800/agcnmsqls2k8.part01.rar
http://rapidshare.com/files/202909447/agcnmsqls2k8.part02.rar
http://rapidshare.com/files/202909828/agcnmsqls2k8.part03.rar
http://rapidshare.com/files/202909794/agcnmsqls2k8.part04.rar
http://rapidshare.com/files/202909803/agcnmsqls2k8.part05.rar
http://rapidshare.com/files/202909839/agcnmsqls2k8.part06.rar
http://rapidshare.com/files/202909403/agcnmsqls2k8.part07.rar
http://rapidshare.com/files/202909797/agcnmsqls2k8.part08.rar
http://rapidshare.com/files/202909879/agcnmsqls2k8.part09.rar
http://rapidshare.com/files/202909823/agcnmsqls2k8.part10.rar
http://rapidshare.com/files/202909816/agcnmsqls2k8.part11.rar
http://rapidshare.com/files/202909573/agcnmsqls2k8.part12.rar
http://rapidshare.com/files/202909843/agcnmsqls2k8.part13.rar
http://rapidshare.com/files/202909592/agcnmsqls2k8.part14.rar
http://rapidshare.com/files/202909738/agcnmsqls2k8.part15.rar
http://rapidshare.com/files/202909871/agcnmsqls2k8.part16.rar
http://rapidshare.com/files/202909422/agcnmsqls2k8.part17.rar
http://rapidshare.com/files/202909821/agcnmsqls2k8.part18.rar
http://rapidshare.com/files/202909624/agcnmsqls2k8.part19.rar
http://rapidshare.com/files/202909621/agcnmsqls2k8.part20.rar
http://rapidshare.com/files/202914592/agcnmsqls2k8.part21.rar
http://rapidshare.com/files/202914612/agcnmsqls2k8.part22.rar
http://rapidshare.com/files/202914322/agcnmsqls2k8.part23.rar
http://rapidshare.com/files/202914581/agcnmsqls2k8.part24.rar
http://rapidshare.com/files/202914633/agcnmsqls2k8.part25.rar
http://rapidshare.com/files/202914591/agcnmsqls2k8.part26.rar
http://rapidshare.com/files/202914311/agcnmsqls2k8.part27.rar
http://rapidshare.com/files/202914455/agcnmsqls2k8.part28.rar
http://rapidshare.com/files/202914571/agcnmsqls2k8.part29.rar
http://rapidshare.com/files/202914506/agcnmsqls2k8.part30.rar
http://rapidshare.com/files/202914570/agcnmsqls2k8.part31.rar
http://rapidshare.com/files/202914580/agcnmsqls2k8.part32.rar
http://rapidshare.com/files/202914604/agcnmsqls2k8.part33.rar
http://rapidshare.com/files/202914348/agcnmsqls2k8.part34.rar
http://rapidshare.com/files/202914151/agcnmsqls2k8.part35.rar
http://rapidshare.com/files/202914118/agcnmsqls2k8.sfv