ICB Consulting, Inc.                         

    Good with computers, but even better at helping people.
 
 

 

 

Microsoft SQL Server 2005 Training Class:   Querying A Database with Transact-SQL

This is a two day, introductory training class on querying a SQL Server database.

This course teaches you how to use the Transact-SQL language to query a Microsoft SQL Server 2005 database.  This is a really good course for someone who wants to learn how to build reports and conduct ad-hoc queries against a database.    You will learn the basics of the SQL language.    No prior knowledge of SQL Server databases is assumed.

 

The focus of this course is NOT on the details of database development or administration.   Rather, this course is more for non-database developers and administrators who need to learn how to query a database for reporting and data mining purposes.

Objectives of this course:  

  • 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 outline:

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

 

  Copyright: ICB Consulting, Inc.    |    About Us   |   Contact Us