Querying Microsoft SQL Server 2000 with
Transact-SQL
Course
Title
Querying Microsoft SQL Server 2000 with Transact-SQL
Course
Language
English
Course
Code
MS2071
Course
Duration
16 Hours
Course
Level
Core
Course
Price
Topics
Introduction to Transact-SQL
Using Transact-SQL Querying Tools
Retrieving Data
Grouping and Summarizing Data
Joining Multiple Tables
Working with Subqueries
Modifying Data
Querying Full-Text Indexes
Introduction to Programming Objects
Prereqisites
Experience in using a Microsoft Windowsآ® operating system
An understanding of basic related database concepts, including:
Logical and physical database design
Data integrity concepts
Relationships between tables and columns (primary key and foreign key, one-to-one, one-to-many, and many-to-many)
Knowledge of how data is stored in tables (rows and columns)
Familiarity with the role of the database administrator
An understanding of the English language is a prerequisite to benefit from the course
