This course is for developers coming from Microsoft Access, Visual Basic, Active Server Pages or other development backgrounds who want to learn to build successful databases solutions with SQL Server. Even developers who've already used Oracle, Sybase, DB2 or other relational database management systems will find this course useful for getting up to speed on SQL Server 2000. You'll learn about the features that are available in SQL Server; how to design and create a database; and how to build basic queries using Transact-SQL, the language of SQL Server. Then, you'll learn how to build effective views, stored procedures, triggers, and user-defined functions, using Transact-SQL. You'll also learn how to take advantage of SQL Server's tools for maintaining your databases.

SQL Server 2000 includes a rich set of tools that go beyond the basics of querying and manipulating data. Microsoft added many very useful capabilities in SQL Server that most developers never discover. This course assumes that you already know the fundamentals of how to build a database and program it with Transact-SQL. You'll learn how to take advantage of SQL Server's tools for securing and tuning your databases. You'll also learn about the advanced features available to you for maintaining, analyzing, searching and distributing your data. Integrate your data safely with Internet and cross-platform applications.

5 days of planned curriculum in an instructor-led, hands-on setting.  Course includes:
25 modules of training
60+ hours of total training time...
Over 1000 pages of courseware
Step-by-step hands-on-labs
Sample code

To get the most out of this course, you should have a solid understanding of relational databases. No particular programming experience is required, but the course is taught from a developer's perspective. .