SQL 2000 Introduction

Overview: Level 1 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 have 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. 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. This introductory course teaches you the fundamentals and gives you a taste of the potential of Microsoft SQL Server 2000.

Course Duration: 1 Day (9 am to 5 pm each day)

Pre-requisite: To get the most out of the Introduction to Microsoft SQL Server 2000 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.

< PC Skills | Schedule | Sign Up > 

SQL 2000 Intermediate

Overview: Level 2 assumes that you already know how to create a well-designed database and how to write simple SQL queries for retrieving and manipulating data. The course shows you how to build effective views, stored procedures, triggers, and user-defined functions, using Transact-SQL (T-SQL), the programming language of SQL Server. You will also learn how to take advantage of SQL Server's tools for maintaining, securing, and tuning your databases.

Course Duration: 2 Days (9 am to 5 pm each day)

Pre-requisite: To get the most out of Programming and Maintaining Databases with Microsoft SQL Server 2000, you should already know how to create and maintain tables in SQL Server, and how to write simple SQL queries for retrieving and manipulating data.

< PC Skills | Schedule | Sign Up >

SQL 2000 Advanced

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

Course Duration: 2 Days (9 am to 5 pm each day)

Pre-requisite: To get the most out of Extended Features in Microsoft SQL Server 2000, you should be very familiar with creating and maintaining SQL Server databases and programming with Transact-SQL.

< PC Skills | Schedule | Sign Up >

MCAD/MCSE/MCDBA Self-Paced Training ... Microsoft Corporat... Buy New $41.99! Privacy Information

MCSA/MCSE/MCDBA Self-Paced Training ... Microsoft Corporat... Buy New $41.99! Privacy Information

Complete SQL Training Course Michael J. Hernand... Buy New $76.99! Privacy Information

SQL Queries for Mere Mortals Michael J. Hernand... Buy New $34.99! Privacy Information