Who Should Attend:

Software engineers, systems analysts, applications programmers, computer science students, and anyone who is interested in acquiring the technical skills required to program in a Microsoft SQL 2000 environment.

Prerequisites:

D101 SQL programming module or familiarity with SQL syntax.

Objectives:
Participants will acquire hands-on practice and experience in programming a Microsoft SQL 2000 environment, and a foundation in the fundamental concepts and techniques related to programming servers. They will be given the opportunity to use SQL Server 2000, learn how to write successful queries to retrieve data and update this database, construct stored procedures, and learn how to write programmes to interact with Microsoft SQL Server.

Contents:

Introduction: SQL Server. General architectural issues.

Administering SQL Server: Basics of SQL server administration. Start, stop and service management.

SQL Server 2000 Security: Security basics of SQL Server. How to check log files for finding out security flaws.

Creating Databases and components: Creating Tables, Creating Indexes, Creating Relationships, Creating Table Objects, Creating Database Diagrams.

Retrieving data: SQL statements for querying, getting data from SQL Server 2000 with formatting options.

Working with Data: SQL statements and SQL server functionality. How to to update, modify or delete database entries.

Transact SQL: its internal use by SQL server for faster processing. Native and faster queries for SQL server. Stored procedures. Web based database applications.