NewEra Technology Facebook
2778 Writing Queries Using Microsoft SQL Server 2008 Transact-SQL - Virtual Led Training - Course Information
PRINT
SEND TO A FRIEND
Name: 2778 Writing Queries Using Microsoft SQL Server 2008 Transact-SQL - Virtual Led Training
Category: Microsoft Official Curriculum Courses
Length (Days): 3
Course Price (CAD): 1650
Description:
This course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2008.
Prerequisites:
N/A
Outline:
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
Guaranteed to run courses