Appdev Microsoft SQL Server 2000| 20 hours Runtime | 14 (CDs Set) | 2.6 GB

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. 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.