Menu

search

Microsoft SQL Server 2000: Querying with Transact SQL

 Microsoft SQL Server 2000: Querying with Transact-SQLrequest-date-quote

Course Specifications

Course length: 2 days

Software: Microsoft_SQL_Server 2000

Course Description

This course teaches you how to use the Transact-SQL language to query a Microsoft SQL Server 2000 database. In addition, this course assists you in preparing for the Microsoft Certified Systems Engineer and Microsoft Certified Database Administrator Exam #70-229, Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition.

Prerequisites:  To ensure your success, we recommend you first take any of the following Element K courses or have equivalent knowledge:

  • Windows 2000: Introduction
  • Windows 2000: Transition from Windows 98
  • Windows Millennium Edition: Introduction
  • Windows 98: Introduction
  • Windows 98: Transition from Windows 3.1
  • Windows 98: Transition from Windows 95

Delivery Method:  Instructor-led, group-paced, classroom-delivery learning model with structured hands-on activities.

Hardware/Software Requirements

You will need:

  • At least 128 MB of RAM for each student computer (256 MB strongly recommended). At least 256 MB for the instructor's computer.
  • A 2 GB or larger hard drive for each of the student computers, and a 4 GB or larger hard drive for the instructor's computer.
  • A Pentium 166 MHz processor or faster.
  • A VGA or higher resolution video card and monitor.
  • A mouse or compatible tracking device.
  • A 12 X (or faster) CD-ROM drive.
  • A network adapter and network cabling.
  • A licensed copy of Windows 2000 Server or Advanced Server for each student and the instructor.
  • Windows 2000 Service Pack 1 or later.
  • A licensed copy of Microsoft SQL Server 2000 Enterprise Edition for each student and the instructor.
  • For the instructor's computer only, a display system to project the instructor's computer screen and PowerPoint slides.

Performance-Based Objectives

  • Identify the features of Transact-SQL and use the Transact-SQL utilities to query a SQL server.
  • Retrieve data by using the SELECT statement.
  • Modify data by using the INSERT, UPDATE, and DELETE statements.
  • Summarize data by using the TOP, GROUP BY, COMPUTE, and COMPUTE BY clauses.
  • Query multiple tables through the use of joins.
  • Design subqueries.
  • Work with full-text indexes.
  • Describe the types of programming objects in Transact-SQL.

Course Content

Lesson 1: Exploring Transact-SQL

Topic 1A: An Overview of SQL Server and Transact-SQL

Topic 1B: Programming in Transact-SQL

Lesson 2: Querying Data

Topic 2A: Using the SELECT Statement

Topic 2B: Formatting the Results Set

Lesson 3: Changing Data Through Queries

Topic 3A: Inserting Data

Topic 3B: Deleting Data

Topic 3C: Updating Data

Lesson 4: Summarizing Data

Topic 4A: Working with Aggregate Functions

Topic 4B: Grouping Data

Lesson 5: Joining Tables

Topic 5A: Querying Multiple Tables

Topic 5B: Implementing Advanced Table Joins

Lesson 6: Implementing Subqueries

Topic 6A: Designing Subqueries

Lesson 7: Working with Full-text Indexes

Topic 7A: Implementing the Microsoft Search Service

Topic 7B: Querying Full-text Indexes

Lesson 8: Programming Transact-SQL

Topic 8A: Creating and Managing Views

Topic 8B: Implementing Stored Procedures, Triggers, and User-defined Functions

Appendix A: The Movies Database Structure

Table DesignTopic

 

Contact Information

3295 River Exchange Drive
Suite 212
Sandy Springs, Georgia 30092
USA

Call

(678) 752-7542 x104

Mail

This email address is being protected from spambots. You need JavaScript enabled to view it.

Stay Connected

Be sure to stay connected for the latest news and updates :)

 Facebook Twitter Google+ RSS Dribbble

 

Join Our Email List