Microsoft SQL Server

Course Number: 662-JK
Recommended Duration: 3 days

Intended Audience
Personnel needing to create and execute queries and manipulate the SQL Server database.

Course Overview
Participants are introduced to the SQL Server database and SQL. Several exercises use Transact-SQL and SQL to query and modify the database. The participant will also learn how to work with views, indexed views, and XML. SQL Server 2008 and SWL Server 2005. Course can be taught with earlier versions of the database.

Prerequisities
No programming background or experience is necessary, although a technical orientation is helpful.

Topics

Relational database concepts
SQL syntax and usage
SELECT statement
Expressions
XML, XPath, and XQuery
Built-in functions
Joins, Outer joins
Subqueries (Nested Queries)
Views and Indexed Views
Synonyms
Sequences
Data Dictionary
UPDATE, INSERT, DELETE, and
MERGE
COMMIT, ROLLBACK, SAVE (savepoints)
Locking
CREATE/ALTER: Tables, Views, Indexed Views, Synonyms, Indexes
Referential Integrity
(Primary & Foreign keys)
Security: GRANT/DENY/REVOKE,
roles
Statistics and Performance overview

Microsoft SQL Server

Relational database concepts

SQL syntax and usage

SELECT statement

Expressions

XML, XPath, and XQuery

Built-in functions

Joins, Outer joins

Subqueries (Nested Queries)

Views and Indexed Views

Synonyms

Sequences

Data Dictionary

UPDATE, INSERT, DELETE, and

MERGE

COMMIT, ROLLBACK, SAVE (savepoints)

Locking

CREATE/ALTER: Tables, Views, Indexed Views, Synonyms, Indexes

Referential Integrity (Primary & Foreign keys)

Security: GRANT/DENY/REVOKE, roles

Statistics and Performance overview

Referential Integrity
(Primary & Foreign keys)

Security: GRANT/DENY/REVOKE,
roles