|
Invest
in Your Career
Learn Performance Tuning from a top industry expert.
High Performance SQL Server 2005 is now
available on full-motion CD-ROMs with narration. Learn the
fun way! Multimedia training is far more effective than
classroom training. It simulates the real-world environment providing excellent
retention. You can replay the video and audio instructional
units as many times as you needed.
Learn Troubleshooting, Performance Tuning and Optimization with this easy-to-follow CD-ROM
collection from Silico-Magnetic Intelligence. Whether you
are learning Performance Tuning for
the first time or adding to your professional skills set,
you will find that SMI’s High Performance SQL Server 2005 Training
via CD-ROM™ contains thorough, outstanding, well-prepared
content that is second to none.
7 CD-ROMs with Over 18 Hours of Instruction 
The instructor is Kalman
Toth, video MCDBA, MCITP, Senior SQL Server Database, Data Warehouse
and Business Intelligence Architect. By mastering one CD-ROM
a day, you can become an Performance Tuning professional in just 7 days. You can also proceed
at your own pace. The thorough CD-ROM course is focused
on practical solutions to real-world Performance, Capacity Plannning and Optimization issues. Full-motion screen video and rich
audio make the subject matter understandable, and reusable
as reference material.
Audience
DBAs, database developers, business intelligence developers, software engineers, data warehouse architects,
systems analysts, IT managers and project managers who design,
develop, implement and manage Microsoft SQL Server 2005
based applications. Network and Database
Administrator candidates, VB, Java, C++, ASP.NET and database
developers who need to know more about applying sophisticated optimization techniques in business environment.
Prerequisites
High Performance SQL Server 2005 students must have a solid working
knowledge of the Windows environment. SQL Server 2005 administration and
programming experience in SQL, and the knowledge of at least one computer language
are helpful. This is best SQL Server 2005 Performance Tuning
multimedia training currently available in North America,
or anywhere in the World.
Objectives
Learn to master the numerous aspects of Performance Tuning & Optimization from this essential video guide. Multimedia course makes learning Performance Tuning easy through the use of extensive practical, real-world ( a table with over 7 million rows used for demonstration) exercises structured around every component within Management Studio, SQL Server Profiler and other sophisticated tools. Learn Performance Tuning from a comprehensive perspective. Start with techniques to detect performance problems and to configure SQL Server 2005 to 24/7 continuous diagnostics. Understand how performance tuning fits into the different stages of a projects life cycle. Identify the most common issues DBAs face day to day and provide solutions which actually work in enterprise environments to resolve common and specialized problems to optimization issues. Study performance problems that have been introduced by the new features of SQL Server 2005 which can enhance developer productivity but reduce performance. See live demonstration of how to detect and improve the performance of poorly performing queries. Expand your knowledge on high performance table design, index architecture and maintenance, query filtering, sorting, operators, conditionals, joins, cross apply operator, aggregate grouping functions, correlated subqueries and stored procedure optimization. Study transaction isolation levels, locking, blocking and deadlocks. Master the use of troubleshooting, tuning and monitoring tools. (See full list below).
About the Trainer
Kalman
Toth, MCDBA,
is an IT professional with over 16 years of database design, administration
and development experience with SQL server 4.2, 6.5, 7.0,
2000 and 2005. Kalman Toth was a developer on IBM's marketing
Data Warehouse project operated by Dun & Bradstreet.
He has designed OLTP databases, OLAP data warehouses and Performance Tuning
solutions for major finance, online dating, health, diet and fitness websites.
His clients include: Citibank, Bank of Sweden, Deloitte-Touche,
Swiss Bank, Reuters, Lehman Brothers, Salomon Brothers, Merrill Lynch,
and IBM. He holds M.Phil degree in Physics and M.Phil. degree
in Computing Science from Columbia University, where he
had taught computer science.
CD-ROM Features
SMI's CD-based training is like training one-on-one with
an expert -- full motion video allows you to see the steps,
hear the explanations, and perform the critical tasks. You can pause the video at any time and practice along. This
is the complete training solution for passing a certification
exam, excelling on an interview and performing well in the
workplace. It is convenient, giving you the freedom to learn
at your own pace, wherever and whenever it suits your schedule.
CD-ROM is easy to use, with streamlined interface featuring
one-click navigation. 100% guaranteed.
Bonus Book 1: Pro SQL Server 2005 Database Design and Optimization 
Pro SQL Server 2005 Database Design and Optimization will teach you
effective strategies for designing proper databases. It covers everything
from how to gather business requirements to logical data modeling and
normalization. It then shows you how to implement your design on SQL.
The authors also describe how to optimize and secure access to this data,
covering indexing strategies, SQL design and optimization, and strategies
for increased scalability to support large numbers of concurrent users.
They provide in-depth advice on optimal code distribution in SQL Server
2005 applications, in the wake of innovations to be able to use .NET code
in the database itself. This essential book will ensure that projects
have a well-designed database and secure, optimized data access
strategies right from the start. A professional developer's guide to SQL Server 2005 describes the latest features of the program as related to physical database design, covering everything from establishing database requirements and data modeling to implementation, and discussing how to optimize and secure access to data, indexing strategies, SQL optimization and scalability procedures, and optimal code distribution.
Bonus Book 2: Inside Microsoft SQL Server 2005: The Storage Engine 
Kalen Delaney's practical, hands-on book offers deep, thorough coverage of the internals of architecture and resource management in SQL Server 2005, focusing on the Storage Engine. The book features extensive code samples and table examples. Key Book Benefits:
- Delivers practical, hands-on guidance for understanding and making the most of the architecture of SQL Server storage, including logging and recovery, indexes, tables, transactions and locking, and security
- Provides deep background information that helps
developers better understand how to build more responsive databases that have fewer vulnerabilities
- Features numerous code samples, table examples, practical advice, and best practices
Take an in-depth look at the internals of the SQL Server Storage Engine with advice from a popular author and SQL Server expert. Database developers and administrators get best practices, pragmatic advice, and code samples to help master the intricacies of creating and maintaining enterprise relational databases.
Discover how to:
• Upgrade or migrate to SQL Server 2005 and choose configuration options
• Control space allocation for databases and files manually or automatically
•Manage transaction logs to maximize efficient restore operations and data consistency
•Observe the internal structures of clustered and nonclustered indexes
• Build and partition relational indexes and tables
•Explore internal storage issues and compare fixed- and variable-length datatypes
•Detect and correct index fragmentation
•Implement and manage an appropriate concurrency model using locking or row versioning
|
