Home ◊ Books ◊ Training Seminars  ◊ Registration

Training Seminar: Essential SQL Server 2008 Administrator Boot Camp

◊ Build your career
◊ Learn SQL Server 2008
◊ Expand your knowledge
◊ Take your skills to the next level
 
 
 
 
 
 
 

Register ◊ Seminars/Locations  ◊ Seminars/Daily Schedule ◊ Seminars Registration/Payment
Who's Teaching ◊ Course Materials ◊ Parking/Misc. ◊ Cancellations/Refunds
Onsite Seminar/Training ◊ Group Discounts

Sign up Now -- 5-day training seminar -- plenty of hands-on!
Seating is limited. Reserve now to guarantee your seat.

Why attend? What you'll get out of training? What your boss needs to know?

 

Trip Planning: Total Package 5-day training/air/hotel/transportation from $2295
Looking for self-study training?

Course Objectives

Expert-led training on SQL Server 2008. This training course is meant to introduce SQL Server 2008 and its features to new SQL Server administrators, SQL Server developers and anyone else wanting to learn about SQL Server 2008. It's meant to get you started, expand your knowledge, and can also help you take your first step toward an exam.
 
This course is best for:
 
Current Windows Administrators who want to learn SQL Server 2008
Administrators upgrading to SQL Server 2008 from SQL Server 2000 or SQL Server 2005
Administrators transferring from other database servers
 
Anyone else who wants to learn SQL Server 2008 and already knows Windows essentials will also benefit from the training course. However, it is important that you have some Windows administration or support experience beforehand.

What Will I Learn?

This class provides the essential core knowledge of SQL Server 2008 needed to be a successful administrator. It covers everything from selecting hardware to database configuration to database backups and recovery.

Want to know what people have said about my work and training courses? Read the testimonials...

Why take my training courses? Read about my effective training techniques and guarantees...

What Training Path Does This Course Relate To?

This training seminar is not meant as an examine prep but does cover most of the same skills tested on the Microsoft exams.

 
Installing, Configuring, and Administering Microsoft SQL Server 2008
Key to the matrix:
  The course includes material to prepare you for this task.
  The course includes some material to prepare you for this task. You will need to supplement the course with additional work.
  The course provides a general introductory overview of this task. You will need to supplement the course with additional work.
Skills measured by exam  
Installing and Configuring SQL Server 2008
Install SQL Server 2008. Considerations include clustering, default collation, file locations, number of instances, and service accounts.
Upgrade to SQL Server 2008.
Create a linked server.
Configure SQL Mail and SQLAgentMail.
Configure network libraries.
Troubleshoot failed installations.
Creating SQL Server 2008 Databases
Configure database options for performance. Considerations include capacity, network connectivity, physical drive configurations, and storage locations.
Attach and detach databases.
Create and alter databases.
  • Add filegroups.
  • Configure filegroup usage.
  • Expand and shrink a database.
  • Set database options by using the ALTER DATABASE or CREATE DATABASE statements.
  • Size and place the transaction log.
Create and manage objects. Objects include constraints, indexes, stored procedures, triggers, and views.
Managing, Monitoring, and Troubleshooting SQL Server 2008 Databases
Optimize database performance. Considerations include indexing, locking, and recompiling.
Optimize data storage.
  • Optimize files and filegroups.
  • Manage database fragmentation.
Modify the database schema.
Perform disaster recovery operations.
  • Perform backups.
  • Recover the system state and restore data.
  • Configure, maintain, and troubleshoot log shipping.
Perform integrity checks. Methods include configuring the Database Maintenance Plan Wizard and using the Database Consistency Checker (DBCC).
Troubleshoot transactions and locking by using SQL Profiler, SQL Server Enterprise Manager, or Transact-SQL.
Extracting and Transforming Data with SQL Server 2008
Set up IIS virtual directories to support XML.
Import and export data. Methods include the Bulk Insert task, the bulk copy program, Data Transformation Services (DTS), and heterogeneous queries.
Develop and manage DTS packages.
Manage linked servers.
  • Manage OLE DB Providers.
  • Configure security mapping.
Convert data types.
Configure, maintain, and troubleshoot replication services.
Managing and Monitoring SQL Server 2008 Security
Configure mixed security modes or Windows Authentication. Considerations include client connectivity, client operating system, and security infrastructure.
Create and manage log ons.
Create and manage database users.
Create and manage security roles. Roles include application, database, and server.
  • Add and remove users from roles.
  • Create roles to manage database security.
Enforce and manage security by using stored procedures, triggers, views, and user-defined functions.
Set permissions in a database. Considerations include object permissions, object ownership, and statement permissions.
Manage security auditing. Methods include SQL Profiler and C2 auditing.
Managing, Monitoring, and Troubleshooting SQL Server 2008
Create, manage, and troubleshoot SQL Server Agent jobs.
Configure alerts and operators by using SQL Server Agent.
Optimize hardware resource usage. Resources include CPU, disk I/O, and memory.
  • Monitor hardware resource usage by using System Monitor.
  • Resolve system bottlenecks by using System Monitor.
Optimize and troubleshoot SQL Server system activity. Activities include cache hits, connections, locks, memory allocation, recompilation, and transactional throughput.
  • Monitor SQL Server system activity by using traces.
  • Monitor SQL Server system activity by using System Monitor.

Who's Teaching?

Instruction by one of the world's leading experts:
William R. Stanek -- no substitutes, no second-stringers.

I teach all classes. There will never be a substitute. Here's the bio blurb if you need to know more:

William R. Stanek (williamstanek@aol.com) has over 20 years of hands-on experience with advanced programming and development. He is a leading technology expert and an award-winning author. Over the years, his practical advice has helped millions of programmers, developers and network engineers all over the world. He has written over 50 computer books, which are sold all over the world and there are more than 3 million copies of his books in print. Current or forthcoming books include Windows Server 2008 Inside Out, Windows Command-Line Administrator's Pocket Consultant, Windows Server 2003 Administrator's Pocket Consultant 2nd Edition, Windows Server 2008 Administrator's Pocket Consultant, Windows Vista Administrator's Pocket Consultant and IIS 7.0 Administrator's Pocket Consultant.

William has been involved in the commercial Internet community since 1991. His core business and technology experience comes from over 11 years of military service. He has substantial experience in developing server technology, encryption, and Internet solutions. He has written many technical white papers and training courses on a wide variety of topics. He is widely sought after as a subject matter expert.

William has an MS in Information Systems degree with distinction and a BS Computer Science degree magna cum laude. He is proud to have served in the Persian Gulf War as a combat crewmember on an electronic warfare aircraft. He flew on numerous combat missions into Iraq and was awarded nine medals for his wartime service, including one of the United States of America's highest flying honors, the Air Force Distinguished Flying Cross. Currently, he resides in the Pacific Northwest with his wife and children.

More Details...

About the Related Book

Speed and ease of reference are essential parts of this hands-on guide. The book has an expanded table of contents and an extensive index for finding answers to problems quickly. Many other quick reference features have been added to the book as well. These features include quick step-by-steps, lists, tables with fast facts, and cross-references. The book is broken down into both parts and chapters. The parts contain a part-opener paragraph or two about the chapters grouped in that part.

Part I, “Microsoft SQL Server 2008 Administration Fundamentals,” covers the fundamental tasks you need for SQL Server administration. Chapter 1 provides an overview of SQL Server administration tools, techniques, and concepts. Chapter 2 discusses deploying SQL Server. Chapter 3 shows you how to configure SQL Server’s services, components and networking capabilities. Chapter examines the structures available for configuring and tuning SQL Server. The chapter looks at SQL Server 2008’s system catalog then continues with a discussion of catalog queries and stored procedures.

In Part II, “Microsoft SQL Server 2008 Administration,” you’ll find the essential tasks for administering SQL Server. Chapter 5 details management techniques for server groups and servers. Chapter 6 explores configuring and tuning SQL Server using SQL Server Management Studio. You’ll learn about optimizing memory usage, parallel processing, authentication, auditing, and more. The core administration tasks for creating and managing databases are covered in Chapter7 with a logical follow-up Chapter 8 on SQL Server security. To manage server security, you’ll create user logins, configure login permissions, and assign roles. The permissions and roles you assign determine the actions users can perform as well as what types of data they can access.

SQL Server data administration is the subject of Part III. Chapter 9 covers techniques for creating, managing, and optimizing schemas, tables, indexes, and views. In Chapter 10, you’ll find tasks for importing and exporting data as well as the old standby bulk copy program (BCP). Chapter 11 focuses on integrating SQL Server databases with other SQL Server databases and with other data sources. You’ll find detailed discussions on distributed queries, distributed transactions, Microsoft Distributed Transaction Coordinator (MS DTC), and linked servers. Chapter 12 explores data replication. You’ll learn all about the latest replication techniques, including merge replication and immediate-updating subscribers.

Part IV, “Performance, Optimization, and Maintenance,” covers administration tasks you’ll use to enhance and maintain SQL Server. Chapter 13 provides the essentials for working with server logs, monitoring SQL Server performance, and solving performance problems. Chapter 14 starts by explaining how to create a backup and recovery plan. Afterward, the chapter dives into common tasks for creating and restoring backups. Chapter 15 explores database automation and maintenance, showing how to create alerts, schedule jobs, handle operator notifications, and more. You’ll also learn how to create maintenance plans and resolve database consistency problems.

About Ordering the Book

This book is available everywhere Microsoft books are sold. I hope you'll order the book from your favorite bookstore. All on-line bookstores carry the book as well. Here's the direct link to order the book at these bookstores:

Amazon.com
BarnesAndNoble.com

 

Books ◊ Training Seminars/Locations  ◊ Training Registration   ◊ Self-Study Training

The obligatory copyright statement:
©William R. Stanek 2004-2008. All Rights Reserved.