New Horizons Lexington KY Computer Training
New Horizons Computer Learning Center presents
 

2778 Writing Queries Using Microsoft SQL Server 2008 Transact-SQL On-Site Training

This on-site training class is also available as Public Schedule Seminar.

This course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2008.

Course Description/Agenda


Overview :
This course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2008.

Objective :
After completing this course, students will be able to: - Describe the uses of and ways to execute the Transact-SQL language. - Use querying tool. - Write SELECT queries to retrieve data. - Group and summarize data by using Transact-SQL. - Join data from multiple tables. - Write queries that retrieve and modify data by using subqueries. - Modify data in tables. - Query text fields with full-text search. - Describe how to create programming objects. - Use various techniques when working with complex queries.

Lesson 1: Getting Started with Databases and Transact-SQL in SQL Server 2008
Overview of SQL Server 2008
Overview of SQL Server Databases
Overview and Syntax Elements of T-SQL
Working with T-SQL Scripts
Using T-SQL Querying Tools
Lesson 2: Querying and Filtering Data
Using the SELECT Statement
Filtering Data
Working with NULL Values
Formatting Result Sets
Performance Considerations for Writing Queries
Lesson 3: Grouping and Summarizing Data
Summarizing Data by Using Aggregate Functions
Summarizing Grouped Data
Ranking Grouped Data
Creating Crosstab Queries
Lesson 4: Joining Data from Multiple Tables
Querying Multiple Tables by Using Joins
Applying Joins for Typical Reporting Needs
Combining and Limiting Result Set
Lesson 5: Working with Subqueries
Writing Basic Subqueries
Writing Correlated Subqueries
Comparing Subqueries with Joins and Temporary Tables
Using Common Table Expressions
Lesson 6: Modifying Data in Tables
Inserting Data into Tables
Deleting Data from Tables
Updating Data in Tables
Overview of Transactions
Lesson 7: Querying Metadata, XML, and Full-Text Indexes
Querying Metadata
Overview of XML
Querying XML Data
Overview of Full-Text Indexes
Querying Full-Text Indexes
Lesson 8: Using Programming Objects for Data Retrieval
Overview of Views
Overview of User-Defined Functions
Overview of Stored Procedures
Overview of Triggers
Writing Distributed Queries
Lesson 9: Using Advanced Querying Techniques
Considerations for Querying Data
Working with Data Types
Cursors and Set-Based Queries
Dynamic SQL
Maintaining Query Files

 

More Seminar Information

New Horizons Computer Learning Center
New Horizons Lexington KY Computer Training

Delivery Method

 On-Site Training On-Site Training

Also Available As

 Seminar Seminar

  		Add to favorites Add to favorites
Email Email this page
 

On-Site Training
Information Request Form

Please complete the form for more information and/or a quote for this on-site class.

Name:

Email

Phone:

City and State

Company:

Number of students:
(at least 10 for consideration)

When do you want to hold the
seminar?

How long would you like for the
seminar?

Additional comments to trainer:

We value your privacy!