MS-SQL Server

	Topic Outline
•	Relational Databases
•	Language Syntax
•	Coding Conventions
•	ISQL
•	Common Commands
•	Relational and Logical Operators
•	Aggregate Operators
•	Table Creation and Modification
•	Multiple Tables
•	Sub-queries
•	String manipulation
•	Date Functions
•	Access Rights

MS-SQL Server

2 days

Description

This course combines lecture and lab work to introduce the features available with MS-SQL Server.

Audience

Application programmers who need to process relational databases.

Prerequisite

Familiarity with Windows 95/98/NT.

Objectives

Students will be able to:

understand the features available with MS-SQL Server

write efficient queries against MS-SQL Server tables using SQL

prepare and run queries against ACV Register Balancing data