Microsoft SQL Server 7.0: Advanced Transact-SQL

Overview/Description
To explain how to create queries to retrieve data from multiple tables and to return summary data

Target Audience
IT professionals including database administrators, application developers, independent software vendors, system integrators, Internet consultants who want to plan, deploy, configure, and administer SQL Server 7.0

Prerequisites
Experience of configuration and administration of Windows NT, familiarity with the Windows 95 or Windows NT user interface, familiarity with managing end-user accounts in an NT environment, knowledge of SQL or Transact-SQL, and an understanding of the role of a database administrator

Expected Duration
3:00 Hours

Objectives:

Microsoft SQL Server 7.0: Advanced Transact-SQL

  • To describe how to join data from two or more tables
  • To describe how to use subqueries to break down and perform complex queries
  • To demonstrate how to write queries that summarize data


    • Course Number: SQ7044E