Are you sure you want to cancel your subscription?
YES NO
Sorry to see you go

Your subscription will remain active until . If you change your mind, you may rectivate your subscription anytime before that date.

OK
Are you sure you want to reactivate?
YES NO
Welcome Back!

Your subscription has been reactivated and you will continue to be charged on .

OK
Reactivate Subscription

Thank you for choosing to reactivate your subscription. In order to lock in your previous subscription rate, you owe: .

Your Subscription term is from - .

Questions? Call Sales.

541-284-5522
Payment Due:

OK

To start a new subscription with new annual term CLICK HERE

Auto-Renew Subscription

To auto-renew your subscription you need to select or enter your payment method in "Your Account" under Manage Payments.

Click continue to set up your payments.
CONTINUE
CANCEL
Back

Microsoft Database PRO SQL Server 2008 Admin 70-450

Designing, Optimizing, and Maintaining a Database Administrative Solution

Don Jones

CBT Nuggets Trainer

"The first class I ever taught was a huge honor -- sharing my knowledge and experience with colleagues was like winning an award. I’m delighted that I’m still training more than a decade later, an... Read more.

Are you a database administrator who wants to add design and development skills to your toolkit? Then this CBT Nuggets SQL Server 2008 Exam-Pack 70-450 training series is for you.

SQL Server 2008 brings you lots of terrific features. Shared server-wide management capability allows you to automate processes, schedule tasks and set performance alerts. Plus you can edit and insert code and run reports.

Trainer Don Jones begins his video series with the basics: SQL terminology, how relational databases work, how they store and retrieve data and the fundamentals of the T-SQL language. Then he teaches you how to install, migrate, upgrade and consolidate your data from previous SQL versions to 2008 SQL Server. Plus, he shows you how some of the "handy" tips and tricks you may have used in earlier versions of SQL can trip you up in SQL Server 2008.

All trademarks and copyrights are the property of their respective holders.
  • Videos
Title Duration
 
Introduction and Overview
Review the table of contents for this series of nuggets, and introduction to the SQL Server 2008 tools.
 00:04:12
 
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.
 00:32:28
 
SQL Server 2008 Physical Concepts and Architecture
CPU, memory, and storage concerns; SQL Server services; database physical architecture; database file placement strategies.
 00:25:08
 
Planning a SQL Server 2008 Installation
Planning for instances; planning for storage; planning for security; planning for availability.
 00:28:32
 
Installing SQL Server 2008
Preparing for the installation; performing the installation; verifying the installation; and launching SQL Server management tools.
 00:18:00
 
Creating and Using a Database
Creating a database; database options; creating a table; executing a query; managing the database file.
 00:25:31
 
Migrating, Consolidating, and Upgrading
Generation migration and consolidation concerns; instance configuration options; database configuration options; SQL Server version upgrades.
 00:27:53
 
SQL Server Instance Security
Instance-level authentication; instance-level security, including service accounts, endpoint security, TCP ports and SSL certificates, etc.
 00:15:05
 
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).
 00:30:02
 
High Availability Overview
Goals of high availability; hardware; failover clustering; database mirroring; replication; and log shipping.
 00:24:50
 
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.
 00:17:42
 
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.
 00:38:17
 
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).
 00:33:10
 
Monitoring SQL Server
Monitoring options (system monitor, event logs, management views, WMI, remote monitoring, and triggers); data collectors; event notifications. NOTE: The website shown in this video redirects to a scripting forum. Please also see this site for more resources.
 00:22:41
 
SQL Server Performance Optimization
Dedicated Administrator Connection (DAC); locking and blocking, deadlocks, index utilization; Database Tuning Advisor.
 00:18:56
 
Maintaining SQL Server
Database maintenance plan; rebuilding and reorganizing indexes; how the Query Optimizer works; maintaining the Query Optimizer (statistics).
 00:29:49
 
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).
 00:22:02
 
Using SQL Server Agent
Creating and managing jobs, proxies, multi-server administration, scheduling jobs.
 00:16:40
 
Distributing Data with SQL Server Integration Services
Introducing SSIS, SSIS package security options, scheduling SSIS packages, deploying SSIS packages.
 00:17:18
 
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.
 00:28:58
Total Series Duration: 07:57:14
Bookmarks

No Bookmarks