Frequently Asked Questions

What is this course about? This course provides a comprehensive introduction to Microsoft SQL Server 2000. You learn how to use the various tools included with SQL Server. The extensive hands-on exercises provide you with valuable opportunities to explore the database developer and administrator capabilities of SQL Server and the accompanying components. This course provides the stepping stone to begin your SQL Server 2000 career. What is SQL Server 2000? Microsoft's SQL Server is a full-featured relational database management system with support for robust server-side development and data replication. It is part of the Windows Server System. Who will benefit from this course? Typical participants include: Programmers, application designers, developers and system architects who design and write Microsoft SQL Server applications and who require an introduction to the big picture of what SQL Server can do Database administrators looking to explore the various capabilities of SQL Server Project managers who will be leading a team of developers in constructing a database application Data processing professionals who may have many years of experience working with traditional database systems (hierarchical or network) and who are now moving to the client/server world Evaluators of database servers who will be making a decision about whether the product is right for their company or department What background knowledge do I need? Tools used in the hands-on exercises assume a familiarity with the Windows user interface. Familiarity with relational database constructs such as tables, rows, columns and referential integrity is helpful. Prior experience with SQL Server is not required. I am a database developer. Is this course sufficient, or should I also attend Course 532? This course provides an overview of the capabilities of SQL Server in general. Although Course 530 touches on some development activities, Course 532, SQL Server Transact-SQL® Programming: Hands-On, focuses specifically on database development. I am a database administrator. Is this course sufficient, or should I also attend Course 531? Again, this course provides an overview of the capabilities of SQL Server in general. While Course 530 touches on some database administration activities, Course 531, SQL Server 2000 Database Administration: Hands-On, is designed specifically for database administrators. How much time is spent on each topic? Content Hours Fundamental concepts 2.0 Creating database objects 2.5 Retrieving and maintaining data 3.5 Basic database administration 3.5 Data migration 2.0 Merge replication 2.5 Analysis Services 3.0 Publishing data on the Web 2.0 SQL Server 2000 Reporting Services 1.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 course? The course includes hands-on workshops that provide immediate reinforcement of material covered in the preceding lecture. Hands-on exercises featuring SQL Server 2000 capabilities include: retrieving and replicating data; using the appropriate tools to move data between legacy systems and SQL Server; and implementing access from the Web to data stored in a SQL Server database. What platform is used for the hands-on exercises? We use Microsoft's SQL Server 2000, running on Windows 2000. Why should I take this course instead of one offered by Microsoft? Learning Tree is dedicated to accelerating the careers of our clients by providing them with world-class technology and management training. Our independence from Microsoft (and any other vendor) allows us to offer an unbiased view of what works and what does not. This course is objective in its approach, having been developed independently of Microsoft by industry experts who bring their real-world experience to the classroom. 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 organisation. 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. 531, SQL Server 2000 Database Administration: Hands-On provides a detailed coverage of SQL Server 2000 from a DBA perspective. The course 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 provides hands-on experience using Transact-SQL to accomplish the task of building stored procedures and triggers. It also covers query performance optimisation. 382, Relational Database Design, Tools and Techniques: Hands-On emphasises the concepts and addresses the "whys" of databases. It deals with what relational databases are, why they are used, how to design and set up a relational database. It would be an appropriate predecessor to this course. 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 2000 and 2005. 535, Developing High-Performance SQL Server® Databases: Hands-On provides the skills needed to achieve a high-performance SQL Server 2000 or 2005 database solution. 539, Deploying Clusters on Windows Server® 2003: Hands-On provides the practical knowledge and skills necessary to plan, implement, configure and test a Windows Server 2003 cluster.

SQL Server is a registered trademark of Microsoft Corporation.