Untitled Document

Concentrika poppy

About the course

The course is intended for those who need to understand database technology and in particular, that engineered by Microsoft. On the course you will learn the features of a RDBMS and the SQL Server management interfaces, both the GUI and the command line options. The course seeks to show delegates where everything is and how the components fit together, rather than imparting low level ability to manipulate the database. The course also serves as a high level introduction to Transact SQL. Anyone wishing to progress towards full training in SQL or Database Administration will find this training a useful launch-pad.

Prerequisites

Delegates should have a general familiarity with IT and feel confident inputting commands into a computer, navigating GUI menus and accessing files on the filing system. Some of the overviews are fairly technical and an understanding of how IT fits together in general would be helpful.

The rest, we teach you on the course.

Duration

3 days

1. SQL Server 7.0 architecture

RDBMS Characteristics
SQL 7.0 Database Architecture
Relational Database Design
The Relational Database
Structured Query Language
Enforcing Data Integrity
Client-Server Architecture
Replication Architecture

3. SQL Server tools

Using the SQL Server Tools
Object management with enterprise manager
Administration Architecture
Wizards
Application Development Architecture
On line manual

5. TRANSACT SQL (T-SQL)

The SELECT Statement
Manipulating Data
Sorting Data with ORDER BY
Aggregate Functions
Implementing Joins
Managing the table object
Insert
Update
Delete
Views
Stored Procedures
Triggers

2. Installing SQL Server 7.0

Pre-Installation Check-List
Installed SQL Server Components
Installing SQL Server 7.0

4. WORKING WITH SQL 7.0 DATABASES

Database deployment strategy
Creating databases
Overview of data storage
Setting Database Options
Removing Databases

6. IMPLEMENTING SQL Server SECURITY

SQL Server 7.0 access security mechanism
Fixed Server Roles
Fixed Database Roles
User-Defined Roles