SQL Server 2005:(10 Hours) Backup SQL Server 2005, SQL Server Insert, SQL Server Training, SQL Server Profiler, Download SQL Server 2005, SQL Server Script, SQL Server Tutorial

• changes to the administration and management tools in SQL Server 2005
• the new Management Studio tool, which encompasses the Enterprise Manager, Query Analyzer and OLAP Analysis Manager from SQL 2000

3/21/2005 | Duration:60 Minutes

The monitoring tools available with SQL Server 2005 include:

• the SQL Profiler
• Database Tuning Advisor
• Database Maintenance Workflow
• Dynamic Management Views (DMVs)

3/28/2005 | Duration:60 Minutes

• Enhancements to enable greater concurrency and significantly reduce lock contention
• how to use Snapshot Isolation to reduce currency contention
• Gain an understanding of database snapshots and replication for scaling and read-only views
• learn how Dynamic Management Views can help you proactively monitor locking and avoid deadlocks

4/4/2005 | Duration:60 Minutes

• The security enhancements in SQL Server 2005
• authentication
• the Security model
• endpoint-based authentication
• the password policy
• authorization
• User Schema separation
• module execution context
• granular permission control
• Catalog security

4/11/2005 | Duration:60 Minutes

• the crypto support in SQL Server 2005
• introduction to the concepts of database encryption including encryption support, keys, certificates and key management.
• how SQL 2005 can protect sensitive data using data encryption and module signatures, and introduce sign modules, what these are and how they work.

4/18/2005 | Duration:60 Minutes

• table and index partitioning capabilities in SQL Server 2005
• features and benefits of partitioning
• explain how partitioning works
• illustrate how to implement and set up partitioning

4/25/2005 | Duration:60 Minutes

• enhancements to the indexing within SQL Server 2005
• basic changes to the indexing compared to previous versions
• index management
• how to use the Database Tuning Advisor as the main tool to analyze indexes

5/2/2005 | Duration:60 Minutes

• Troubleshooting methods
• tools in Microsoft SQL Server 2005 that you can use to recover from various scenarios
• database access problems, such as the database being marked as suspect during recovery
• backup and restore failures
• database runtime consistency failures, such as checksum
• DBCC CHECKDB errors

5/9/2005 | Duration:60 Minutes

• Database mirroring
• how to configure and use mirroring

5/16/2005 | Duration:60 Minutes

• SQL Server includes a suite of replication technologies that enable a wide range of distributed database applications

SQL Server 2005 introduces a few new scenarios that include:

• Web synchronization of merge replication for mobile and distributed data applications
• Oracle publishing for integration with Oracle databases
• peer-to-peer replication

5/18/2005 | Duration:60 Minutes