TrainSignal Advanced SQL Server 2008 Database Administration

6th
DEC

Posted by ranxo under Database, Video Training

TrainSignal Advanced SQL Server 2008 Database Administration

Fomat: iSO | 2DVD | DVD1: 2.76GB | DVD2: 1.77GB

Genre: eLearning

If you want to develop hands-on experience as an SQL Server 2008 Administrator, or prepare for the 70-432 exam then this course is for you! We are excited to announce our long awaited SQL Server 2008 Administration Training course.
Whether you’re a beginner or experienced in SQL Server administration, this course covers SQL Server 2008 in depth as you configure and maintain your own enterprise data management system! Database Administration is one of the few jobs that seems to always be in demand. Follow along with the many real world examples in this course to work with your own database and lay the foundation towards becoming a DBA.
The course includes video and audio training on iPod, MP3, AVI and WAV (great for learning on-the-go) plus a full version of Transcender’s Award-Winning “SQL Server 2008 Implementation and Maintenance” practice exam.
emas
* Protecting Your Data Auditing SQL Server
* Remote Access
* File Security and SQL Server Data Encryption
* SQL Server SA Login and Certificat-Based SQL Server Login
* Public Database Role
* Information_Schema and Sys
* Best Practices

Video 7
SQL Server 2008 Implementing Disaster Recovery
Having a disaster recovery plan is a necessity in today’s computing landscape. I will show you the different disaster recovery models you can implement to make sure you are protected against data corruption, hardware failures, and anything else that would destroy data.
* SQL Server Recovery Models
* Full Recovery Model
* Bulk Logged Recovery Model
* Simple Recovery Model
* Backup Types
* Full Database Backups
* Restoring a Database
* Full File Backups
* Partial Backups
* Recovery Requirements
* Best Practices

Video 8
SQL Server 2008 Performance
In this Video I will show you the many tools you can use to monitor your SQL Server performance to anticipate problems before they occur.
* SQL Profiler/SQL Trace (T-SQL)
* Windows System Monitor
* Activity Monitor
* Transact-SQL
* Windows Logs
* Default Trace
* Dynamic Management Views
* Monitoring Tools Comparison

Video 9
SQL Server 2008 Automating Administrative Tasks
In this Video I will show you how to use the SQL Server Agent to automate administrative tasks, saving you time and allowing you to move on to more important work.
* SQL Server Agent
* Configuring SQL Server Agent
* Key Fixed Database Roles
* Creating and Running Jobs
* Subsystem
* Proxy
* Security Guidelines

Video 10
SQL Server 2008 High Availability
Learn the benefits of the various high availability options and why you would use each one. Plus, I’ll show you how to keep your database always available by having multiple servers ready to go, so you’re not depending on just one server.
* SQL Server Failover Clustering
* SQL Server Database Mirroring
* SQL Server Log Shipping
* SQL Server Replication
* Comparisons

Video 11
SQL Server 2008 Replication
Learn to implement SQL Server replication, making the necessary data available to various locations as it’s needed; in real time. Plus, see how to configure the necessary security including: user accounts, firwall settings, and administrative access.
* What’s the Problem to Solve?
* What is SQL Replication?
* SQL Server Replication Concepts
* Types of Replication
* SQL Server Roles
* Pieces of SQL Replication Model
* Players of SQL Replication Model
* Creating Replication Admin Account
* Creating Agent Accounts
* Changing Firewall Settings
* Giving Replication Admin Access to the SQL Server
* Installing SQL Server Replication Feature
* Adding Replication Accounts to Database
* Creating Publication
* Creating Push Subscription
* Best Practices

Video 12
Resource Governor
In this Video I will show you how to manage server resources and control application access to system resources.
* Troubleshooting SQL Server
* Managing Resource Utilization
* Resource Govenor
* Resource Pools
* Creating a Resource Pool
* Workload Groups
* Creating a Workload Group
* Classification
* Creating a Classifier Function

Video 13
Performing Data Management Task
In this Video you will learn several data management skills focused on “rounding out” your SQL Server 2008 administration knowledge. A primary focus will be understanding and managing indexes.
* Importing and Exporting
* Permissions for Importing and Exporting
* Maintaining Indexes
* Clustered vs. Nonclustered Indexes
* Creating Indexes
* Full-Text Indexing

Video 14
Data Compression
Learn how you can slow the effect of the data storage explosion by compressing SQL Server data while still maintaining performance requirements.
* Row Compression
* Page Compression
* Data Partitions
* Table Compression via T-SQL
* Compressing Backups

Video 15
SQL Server 2008 Common Commands
As a database administrator you will find the DBCC ‘family’ of commands and the myriad of applications for the sp_configure system stored procedure to be invaluable. These two commands touch every aspect of the DBA role and provide you with access to every configuration option available within SQL Server 2008.
* Database Console Commands (DBCC)
* Running DBCC CHECKTABLE and DBCC CHECKDB Commands
* Setting Server Configuration Options
* sp_configure clr enable Command
* sp_configure c2 audit mode Command
* sp_configure fill factor Command
* Final Thoughts on sp_configure

Video 16
Database Mail
In this Video I will show you how to use SQL Server Database Mail and Microsoft’s “built-in” SMTP server to send email notifications to operators, from SQL Server 2008.
* The Players…
* Simple Mail Transfer Protocol (SMTP) Server
* Database Mail Profiles and Accounts
* Configuring Database Mail
* Database Mail SMTP Authentication

Video 17
Certification 101
The path to certification will be clear once you watch this SQL Server 2008 certification road map. I cover all the certification levels, tracks and exams to get you certified in SQL Server 2008.
* The Certification Hierarchy
* Microsoft Certified Technology Specialist (MCTS)
* Microsoft Certified IT Professional (MCITP)
* Microsoft Certified Master (MCM)

SUPPLIER : TEAM LiBiSO
PACKAGER : TEAM LiBiSO
TYPE : ISO
TOTAL CDs : 2 DVD
LANGUAGE : ENGLISH
RELEASE : 04/26/2010