SQL Server Training Classes in San Francisco Bay Area

This two-day training class introduces students to relational theory, data integrity, and performance using SQL Server. This server is Microsoft's popular enterprise-level database, competing with Oracle and MySQL. On the conclusion of this course students will be able to outline a basic normalized database, utilize primary and foreign key concepts, and extract data using select statements in conjunction with built in functions.

Relational Theory, Data Integrity, and Performance

What is Transact-SQL?
Database management systems (DMS): Discussion of types and product examples
Description of SQL Server DMS
Relational theory constructs - basis in set theory

Tables (entities)
Primary keys (unique identifier)
Foreign keys (relationships)
Columns (data) and datatypes

Relational theory operation

Relationships
Relationship types

One to many (most common)
One to one
Many to many
The resolution table and its use

Data Integrity Maintenance

Constraints

Primary keys
Foreign keys
Indexes (unique)

Transactions

Implicit
Explicit

Locks

Shared locks
Update locks
Exclusive locks
Intent locks

Introduction to Transact-SQL Tools and the Database Management Console

Books Online
SQL Server Enterprise Manager
Query Analyzer

System objects: purposes and functions

Tables
Views
Stored procedures
Functions

Functions
Table functions

Defaults
Rules
User-Defined types

ANSI-SQL compliant SQL statements

ANSI-Compliant SQL
The difference between ANSI-Complient SQL and SQL Server SQL (T-SQL).

Prerequisites:

Experience with at least one other database