2778 Writing Queries Using Microsoft SQL Server 2008 Transact-SQL - Class Outline

Print Preview \| E-Mail Outline

2778 Writing Queries Using Microsoft SQL Server 2008 Transact-SQL Duration: Online Live - 3.00 Sessions Traditional Instructor Led Learning - 3.00 Day(s) Mentored Learning - Flexible Overview: This course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2008. Who Should Attend: This course is intended for SQL Server database administrators, implementers, system engineers, and developers who are responsible for writing queries. At Course Completion: 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.
Prerequisite Comments:
Relational database design skills Programming skills Knowledge of data integrity concepts. Core Windows Server skills

Outline:	Top
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	Top
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	Top
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	Top

*Content, days, and times vary depending on your location. Please view the outline on the checkout page prior to purchase or
contact the local center for more information.