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


Objectivos
_ 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.


Duração: 18 horas


Conteúdo Programático
Module 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

Module 2: Querying and Filtering Data
_ Using the SELECT Statement
_ Filtering Data
_ Working with NULL Values
_ Formatting Result Sets
_ Performance Considerations for Writing Queries

Module 3: Grouping and Summarizing Data
_ Summarizing Data by Using Aggregate Functions
_ Summarizing Grouped Data
_ Ranking Grouped Data
_ Creating Crosstab Queries
Module 4: Joining Data from Multiple Tables
_ Querying Multiple Tables by Using Joins
_ Applying Joins for Typical Reporting Needs
_ Combining and Limiting Result Set

Module 5: Working with Subqueries
_ Writing Basic Subqueries
_ Writing Correlated Subqueries
_ Comparing Subqueries with Joins and Temporary Tables
_ Using Common Table Expressions

Module 6: Modifying Data in Tables
_ Inserting Data into Tables
_ Deleting Data from Tables
_ Updating Data in Tables
_ Overview of Transactions

Module 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

Module 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

Module 9: Using Advanced Querying Techniques
_ Considerations for Querying Data
_ Working with Data Types
_ Cursors and Set-Based Queries
_ Dynamic SQL
_ Maintaining Query Files


Requisitos
_ Knowledge of data integrity concepts.
_ Core Windows Server skills.
_ Relational database design skills.
_ Programming skills

Solicite mais informação

Inscreva-se neste curso