Developing High-Performance SQL Server Databases: Hands-On

Frequently Asked Questions

What is this course about? In this course you learn to use the tools and techniques you need to achieve high-performance databases. You take away with you a detailed knowledge of Microsoft SQL Server's storage engine, query optimizer and lock manager. Who will benefit from this course? This course is designed for people whose work involves or will involve the development of SQL Server data-bases. Typical participants include: Programmers, application designers, developers and systems analysts who design and implement Microsoft SQL Server databases Database designers who need to know how to prevent performance problems on the SQL Server platform Database administrators who need to know how to improve the performance of the databases for which they are responsible Those who have worked extensively with some other database management systems and want specific coverage of Microsoft SQL Server internals What background knowledge do I need? You should have a solid background in SQL. Knowledge of SQL at the level of Course 532, SQL Server Transact-SQL® Programming: Hands-On, Course 130, SQL Server 2005 Programming: Hands-On Skills Upgrade, or Course 133, SQL Server 2005 Server-Side Programming: Hands-On, is assumed. An understanding of logical database design principles is helpful. Course 382, Relational Database Design, Tools and Techniques: Hands-On, offers that knowledge. If Course 534, Developing SQL Queries for SQL Server: Hands-On, is your only exposure to Transact-SQL, you may find some parts of this course difficult, particularly those dealing with data maintenance and procedural programming. That is why we recommend that you take Course 532 or 133 first, or have equivalent knowledge or experience. If Course 131, SQL Server 2005 Comprehensive Introduction: Hands-On, is your only exposure to SQL and database development in general, you should take Course 532 or 133 before taking this course. Is this course for administrators or developers? Both database administrators with database design responsibility and developers who write SQL statements benefit from this course. Which versions of SQL Server are covered? This course covers both SQL Server 2000 and 2005. The similarities between 2000 and 2005 are strong enough that if you have not yet upgraded to SQL Server 2005, approximately 90 percent of the course material is still applicable. If you are already working with SQL Server 2005, you will benefit from the instructor's demonstrations of important new 2005 features. I have already attended Course 532 and/or 534. They covered performance. What extra benefit will this course give me? Courses 532 and 534 do contain some performance tuning content. However, this course provides the thorough grounding in SQL Server internals that you need in order to design and implement high-performance databases. Course 535 provides detailed information about how the query optimizer works and allows you to apply this knowledge to the design of your queries. In addition, it covers physical database design, the storage engine and storage structures, and memory management. How much time is spent on each topic? Content Hours Fundamental concepts 6.0 Managing storage 6.0 Memory and locking 6.0 Optimizing queries 8.0 Physical design 3.0 Times, including the workshops, are estimates; exact times may vary according to the needs of each class. What kinds of hands-on exercises are included? In this class, you analyze and repair a variety of performance problems. The hands-on exercises include selecting the right tool for monitoring, analyzing query optimizer plans, designing physical data structures, creating indexes for different query types, improving performance with indexed views, using rollup tables, and managing statistics. What platform is used for the hands-on exercises? The course runs on SQL Server 2000 and 2005 Developer Editions on a Windows Server 2003 platform. Students do their hands-on exercises on the version of SQL Server they use at work. Does this course cover logical database design? No. This course assumes that you have knowledge of logical database design. In this course, you start with the logical design and transform it into a physical design. Course 382 covers logical database design and is an excellent predecessor to this course. I am a Windows systems administrator with responsibility for overall SQL Server administration. Is this course useful for me? No. This course does not cover administrative tasks such as backup and recovery and security management. You might want to consider Course 132, SQL Server 2005 Database Administration: Hands-On. How does this course relate to other Learning Tree courses? The SQL Server courses you take vary depending on the role you play in your organization. Please refer to the SQL Server 2005 Curriculum Q&A for details on which courses are most appropriate to your role and the order in which you should take them. 382, Relational Database Design, Tools and Techniques: Hands-On emphasizes the concepts and addresses the "whys" of databases. It deals with what relational databases are, why they are used, and how to design and set up a relational database. It is an appropriate predecessor to this course. 131, SQL Server 2005 Comprehensive Introduction: Hands-On is strongly recommended for anyone who is not familiar with the basics of SQL Server. In the course, you explore many of the SQL Server 2005 capabilities using the graphical tools provided by Microsoft. 132, SQL Server 2005 Database Administration: Hands-On provides detailed coverage of SQL Server 2005 from a DBA perspective. It covers issues such as backup and recovery, database storage, jobs and alerts, and other administrative tasks. 532, SQL Server Transact-SQL® Programming: Hands-On focuses on SQL Server from a developer perspective. The course details using Transact-SQL to accomplish the task of building stored procedures and triggers. It also covers query performance optimization and provides the knowledge of Transact-SQL required for Course 535. 133, SQL Server 2005 Server-Side Programming: Hands-On focuses on SQL Server from a developer perspective. The course provides in-depth knowledge of creating stored procedures, triggers and functions in both Transact-SQL and the .NET languages. It gives you the Transact-SQL knowledge you need for Course 535. 534, Developing SQL Queries for SQL Server: Hands-On provides the knowledge and skills you need to develop complex and robust SQL queries for SQL Server.

SQL Server is a trademark of Sybase, Inc.