Participants learn to issue data definition, query, and update commands against a populated sample database.
Special emphasis is given to views, joins, subqueries, and checking for referential integrity.
Students will also learn to use SQL Server client tools, such as Enterprise manager, Query Designer, and Query Analyzer. This course is designed for data processing professionals and end users that need to use interactive SQL commands or who will eventually be embedding SQL calls in programs. This course is designed for data processing professionals who need to use interactive SQL commands or create application programs containing SQL commands. All content copyright 1997 - 2000, Center for the Application of Information Technology. All rights reserved.