AUDIENCE:   This course is for support personnel who need to understand the basic concepts of SQL Server 2000 and 2005, from an administration or development viewpoint. This includes application developers (Visual Basic, C++, etc.) who need a basic grounding in SQL Server 2000 or 2005. PREREQUISITES:   No previous knowledge of the program is assumed although a working knowledge of Windows 2000/2003 Server/XP will be useful. DURATION:   2 days. Hands on. OBJECTIVES:   This course provides an introduction to the important features of both relational databases and specifically Microsoft's SQL Server product up to version 2005. The course will involve a terminology guide; installation of the server; a comprehensive guide to the SQL Server tools, including Enterprise Manager and Query Analyser and database implementation basics, with an introduction to T-SQL and SQL Server security. COURSE CONTENT:   SQL Server 2005 Architecture RDBMS Characteristics SQL Database Architecture Relational Database Design The Relational Database Structured Query Language Enforcing Data Integrity Client-Server Architecture Replication Architecture Installing SQL Server Pre-Installation Check-List Installed SQL Server Components Installing SQL Server SQL Server Tools Using the SQL Server Tools Creating a Database Creating Tables Administration Architecture Wizards Application Development Architecture Working with SQL Server Databases and Tables Structure Query Language Generating Database Information Setting Database Options Removing Databases Enforcing Data Integrity Defining Table Columns Using INSERT VALUES Using Database Queries The SELECT Statement Manipulating Data Selecting Rows Sorting Data with ORDER BY Aggregate Functions Implementing Joins Deleting Data with DELETE Updating Data with UPDATE Accessing Data with Views Stored Procedures Ensuring Database Integrity with Triggers Implementing SQL Server Security Accessing SQL Server Fixed Server Roles Fixed Database Roles What are User-Defined Roles? Application Roles Database Permissions