• 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
• Exploring the Components and Executing Queries in SQL Server Management Studio
• Starting and Using SQLCMD
• Generating a Report from a SQL Server Database Using Microsoft Office Excel
• Describe the architecture and components of SQL Server 2008.
• Describe the structure of a SQL Server database.
• Explain the basics of the SQL language.
• Describe the syntax elements of T-SQL.
• Explain how to manage T-SQL scripts.
• Use T-SQL querying tools to query SQL Server 2008 databases.

Querying and Filtering Data

• Using the SELECT Statement
• Filtering Data
• Working with NULL Values
• Formatting Result Sets
• Performance Considerations for Writing Queries
• Retrieving Data by Using the SELECT Statement
• Filtering Data by Using Different Search Conditions
• Using Functions to Work with NULL Values
• Formatting Result Sets
• Retrieve data by using the SELECT statement.
• Filter data by using different search conditions.
• Explain how to work with NULL values.
• Format result sets.
• Describe the performance considerations that affect data retrieval.

Grouping and Summarizing Data

• Summarizing Data by Using Aggregate Functions
• Summarizing Grouped Data
• Ranking Grouped Data
• Creating Crosstab Queries
• Summarizing Data by Using Aggregate Functions
• Summarizing Grouped Data
• Ranking Grouped Data
• Creating Crosstab Queries
• Summarize data by using aggregate functions.
• Summarize grouped data by using the GROUP BY and COMPUTE clauses.
• Rank grouped data.
• Create cross-tabulation queries by using the PIVOT and UNPIVOT clauses.

Joining Data from Multiple Tables

• Querying Multiple Tables by Using Joins
• Applying Joins for Typical Reporting Needs
• Combining and Limiting Result Set
• Querying Multiple Tables by Using Joins
• Applying Joins for Typical Reporting Needs
• Combining and Limiting Result Sets
• Query multiple tables by using joins.
• Apply joins for typical reporting needs.
• Combine and limit result sets.

Working with Subqueries: Tableau Online Training

• Writing Basic Subqueries
• Writing Correlated Subqueries
• Comparing Subqueries with Joins and Temporary Tables
• Using Common Table Expressions
• Writing Basic Subqueries
• Writing Correlated Subqueries
• Comparing Subqueries with Joins and Temporary Tables
• Using Common Table Expressions
• Write basic subqueries.
• Write correlated subqueries.
• Compare subqueries with joins and temporary tables.
• Use common table expressions in queries.

Modifying Data in Tables

• Inserting Data into Tables
• Deleting Data from Tables
• Updating Data in Tables
• Overview of Transactions
• Inserting Data into Tables
• Deleting Data from Tables
• Updating Data in Tables
• Working with Transactions
• Insert data into tables.
• Delete data from tables.
• Update data in tables.
• Describe transactions.

Querying Metadata, XML, and Full-Text Indexes in Tableau Online Training

• Querying Metadata
• Overview of XML
• Querying XML Data
• Overview of Full-Text Indexes
• Querying Full-Text Indexes
• Querying Metadata
• Querying XML Data
• Creating and Querying Full-Text Indexes
• Query metadata.
• Describe the functionality of XML.
• Query XML data.
• Describe the functionality of full-text indexes.
• Query full-text indexes.

Using Programming Objects for Data Retrieval

• Overview of Views
• Overview of User-Defined Functions
• Overview of Stored Procedures
• Overview of Triggers
• Writing Distributed Queries
• Creating Views
• Creating User-Defined Functions
• Creating Stored Procedures
• Writing Distributed Queries
• Encapsulate queries by using views.
• Encapsulate expressions by using user-defined functions.
• Explain how stored procedures encapsulate T-SQL logic.
• Define triggers, types of triggers, create a trigger.
• Write distributed queries.

Using Advanced Querying Techniques

• Considerations for Querying Data
• Working with Data Types
• Cursors and Set-Based Queries
• Dynamic SQL
• Maintaining Query Files
• Using Execution Plans
• Converting Data Types
• Implementing a Hierarchy
• Using Cursors and Set-Based Queries
• Explain the recommendations for querying complex data.
• Query complex table structures.
• Write efficient queries.
• Use various techniques when working with complex queries.

Maintain query files.