|
|
 |
 |
Course 4332: Querying Metadata, XML, and Full-Text Indexes in Microsoft SQL Server 2005 |
|
In this course, you query metadata, XML data, and full-text indexes by using Transact-SQL (T-SQL) in Microsoft SQL Server 2005. You query metadata by using SQL Server views and commands. You query XML data by using OpenXML and XQuery. You also query relational data combined with XML data. In addition, you analyze the purpose and process of querying full-text indexes. This course also helps prepare you for certification exam 70-431. |
|
|
 |
|
Formas de Pagamento
|
|
|
Cartão de Crédito
Obs.: Optando pela forma de pagamento através de cartão de crédito, deverão ser enviadas as cópias desses documentos: CPF, RG e a frente do cartão de crédito.
|
|
|
|
Conteúdo
|
|
|
| Course Overview | | Module Introduction | | Navigation Overview | | Lab Information | | Querying Metadata, XML, and Full-Text Indexes | | Module Introduction | | Querying Metadata | | Lesson Introduction | | Categories of Data | | Grouping Concepts Related to Different Categories of Data | | What Is Metadata? | | How to Query Metadata by Using SQL Server Views | | How to Query Metadata by Using SQL Server Commands | | Self Test | | Overview of XML | | Lesson Introduction | | What Is XML? | | Scenarios Where XML Is Used | | How SQL Server Implements XML | | Self Test | | Querying XML Data | | Lesson Introduction | | How to Generate XML-Based Reports | | How to Query XML by Using OpenXML | | What Is XQuery? | | How to Query XML by Using Xquery | | How to Query Relational Data Combined with XML Data | | Self Test | | Overview of Full-Text Indexes | | Lesson Introduction | | What Are Full-Text Indexes? | | Full-Text Indexing and Querying Process | | How SQL Server Implements Full-Text Indexes | | Self Test | | Querying Full-Text Indexes | | Lesson Introduction | | Overview of Full-Text Search | | How to Use the CONTAINS Predicate | | How to Use the FREETEXT Predicate | | How to Use the Full-Text Functions | | Identifying Differences Between Full-Text Functions and Predicates | | How to Combine Full-Text Search and Transact-SQL Predicates | | Self Test | | Lab:Querying Metadata, XML, and Full-Text Indexes | | Lesson Introduction | | Scenario | | Exercises | | Lab Review | | Module Summary | | Glossary | | Module Introduction |
|
|
|
Material
|
|
|
Download do curso para visualização em offline sem o uso de impressão.
|
|
|
|
Certificado
|
|
|
O certificado de conclusão do curso, estará liberado para impressão ao termino do curso.
|
|
|
|
Requisitos de Sistema
|
|
|
- A Pentium II, 256 MB RAM with a processor speed greater than or equal to 400 MHZ
- Microsoft® Windows® 2000 or higher
- Microsoft Internet Explorer 6.0 with SP1
- Macromedia Flash 7.0 or higher (1MB disk space needed to install)
- Microsoft Virtual Server ActiveX control (required for virtual labs; 1MB disk space needed to install)
- Microsoft Windows Media Player 7.0 or higher
- Microsoft XML Core Services 3.0 or higher
- A Super VGA monitor with minimum screen resolution 1024x768, with 16-bit color.
- A sound card, speakers, or headphones are recommended.
- Internet bandwidth of 56K or faster. Broadband is recommended.
|
|
|
|
Requisitos de Acessibilidade
|
|
|
Microsoft Internet Explorer 5.0 or higher
Window-Eyes from GS Micro
JAWS from Freedom Scientific
MSAA enabled
|
|
|
|
|
|
|
|
|
|
 |
|
 |
|
|
Cursos online
Cursos Presenciais
Course in English
