|
|
|
Price: $397.00
ISBN #:
Format: CD Courseware
|
|
Our SQL Server 2008 Training teaches you SQL Profiler, SQL Server Agent, replication, optimized use of SQL Server file groups and much more.
If you want to develop hands-on experience as an SQL Server 2008 Administrator, or prepare for the 70-432 exam, this course is for you! 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! 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.
This course will help you prepare for the 70-432 Microsoft SQL Server 2008 Implementation and Maintenance exam.
SQL Server 2008 Administration Training Course Outline
Video 1: Introduction
Learn what's included in the course and who your instructor is.
Video 2: Welcome to Microsoft SQL Server 2008
Discover what SQL Server 2008 is and walk through the scenario we will be using throughout the course.
Video 3: Installing SQL Server 2008
There is more to configuring an SQL Server installation than you might think. You'll learn exactly what you need to do to prepare for installation and the requirements you will need to meet before installing SQL Server, so that your installation goes smoothly.
Video 4: An Introduction to SQL Server 2008 Tools
To fully make use of all of the features of SQL Server you need to know how to use the many tools it has to offer. Get an in-depth overview of the several tools available in SQL Server 2008.
Video 5: Creating SQL Server 2008 Databases
Walk through the planning process needed to create your database to meet your specific business and database management needs, and set up your very own SQL Server database.
Video 6: Configuring SQL Server 2008 Security
As a DBA, one of your most important responsibilities will be securing company data resources against unauthorized access and modification. In this video, you'll tackle SQL Server security from physical security to permissions and schemas--and everything in between.
Video 7: SQL Server 2008 Implementing Disaster Recovery
Having a disaster recovery plan is a necessity in today's computing landscape. Learn more about 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.
Video 8: SQL Server 2008 Performance
Discover the many tools you can use to monitor your SQL Server performance to anticipate problems before they occur.
Video 9: SQL Server 2008 Automating Administrative Tasks
Use the SQL Server Agent to automate administrative tasks, saving you time and allowing you to move on to more important work.
Video 10: SQL Server 2008 High Availability
Learn the benefits of the various high availability options and why you would use each one. Plus, learn how to keep your database always available by having multiple servers ready to go, so you're not depending on just one server.
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.
Video 12: Resource Governor
Learn how to manage server resources and control application access to system resources.
Video 13 Performing Data Management Tasks
Learn several data management skills focused on "rounding out" your SQL Server 2008 administration knowledge. A primary focus will be understanding and managing indexes.
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.
Video 15: SQL Server 2008 Common Commands:
As a database administrator you'll 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.
Video 16: Database Mail
Learn how to use SQL Server Database Mail and Microsoft's "built-in" SMTP server to send email notifications to operators, from SQL Server 2008.
Video 17: Certification 101
The path to certification will be clear once you watch this SQL Server 2008 certification road map. Learn more about certification levels, tracks and exams to get you certified in SQL Server 2008.
17 videos (10hrs : 12mins : 43secs) will be provided in high-quality .AVI and .WMV format. In other words, you get perfect quality and replication of your instructors' screens. An easy-to-use table of contents allows you to navigate to key areas you wish to focus on.
17 iPod video files to watch Train Signal on the go! A popular request amongst our students who wish to study while they commute (i.e. train, plane, bus). These 320x240 M4V files are compressed versions of the original course, and play on any iPod that supports video. Also great for reviewing and refreshing your mind "on the job."
17 MP3 audio files to listen to Train Signal anytime, anywhere. Some of our students have requested this option. Now, you can listen in the car or while working out. Our MP3 files can be burnt to a CD or copied to a portable device.
Instructor Notes - These PDF documents, which can be printed out, contain the slides used by the instructors throughout the videos. These documents allow the user a quick easy reference to the instructors' notes on the slides, and provides a place to make additional notes.
Plus, you'll receive a FREE full version of Transcender's Award-Winning "SQL Server 2008 Implementation and Maintenance" Practice Exam-- a $149 value!
|