Back

Microsoft Database PRO SQL Server 2008 Admin 70-450

Designing, Optimizing, and Maintaining a Database Administrative Solution
IT TRAINING
The 24-Hour Solution
Try it out,
24 hrs for $24

Prepare for an upcoming exam. Make corporate training decisions without risk. Access all of our IT training for 24 hours. Learn 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 pack 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
  • Purchase Options
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.
 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: 7 hours
Which option is right for you?
Buy a Single Series
"Focus your training on one series, for one month, for one low price."
StreamOne
StreamOne SUBSCRIPTION
Includes ExamPrep
StreamOne is your monthly option for streaming access to Microsoft Database PRO SQL Server 2008 Admin 70-450. One multi-user license gives you and a small team access to one full series. Cancel at any time. A StreamOne subscription gives you plenty of time to explore the benefits of CBT Nuggets, while paying for just the specific series you want.
MULTI-USER
$199
per license
Add to Cart
$499
EDM
Download
Download Microsoft Database PRO SQL Server 2008 Admin 70-450.
$499
DVD
DVD
Have Microsoft Database PRO SQL Server 2008 Admin 70-450 delivered on DVD.
 
Buy a Certification Package
"Secure your future with professional recognition via industry certification. Certification Packages give you the training you need to pass those certification exams."
Get Certified. Cisco, Microsoft, CompTIA and more.
Inclusive pricing. Package includes training videos and any relevant and available exam-prep.
Image
Certification Packages
Professional Recognition from Renowned IT Organizations
CBT Nuggets offers certification packages to help you achieve valuable professional recognition. Get the most popular certifications from Cisco, Microsoft and others. IT certification after training with CBT Nuggets will help you do a lot more than put letters after your name. Begin your path to a better job and a better future today!
  • Certification Package
    $599
    4 MONTHS STREAMING
    Add to Cart
    MCITP: SQL Server 2008 Database Administrator Certification Package
    Microsoft's SQL Server 2008 Database Administrator MCITP Certification tells your employer -- or prospective employer -- that you're a database administrator (DBA) who really knows what he's doing. And once you've become this trusted, certified DBA, you'll be on your way to increased respect and heightened job security. Earning this MCITP ce... Learn more...
Buy an Annual Subscription to Everything IT
"Eliminate your limitations. An IT Nuggets streaming subscription puts our complete IT training library at the fingertips of IT pros."
All topics. From admin to programming.
Image
IT Nuggets
Productivity for Companies and IT Advancement for Professionals
Get access to better training, and never lose it, with an IT Nuggets subscription. IT Nuggets is a multi-user product that supports all levels of your IT department, even as employees come and go. One locked-in rate gets you access to our IT training catalog, which is updated regularly and automatically at no additional charge. As long as your subscription is maintained, the rate won't change, and neither will your budget. Our full IT library is designed for Pros to keep current for career advancement and companies that want their IT Pros to reach their full potential.
YEARLY
MULTI-USER
$1999
per license
Add to Cart
Bookmarks

No Bookmarks