Loading Course Schedule...
PT6907
Summary
This course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2008.
Prerequisites
Before attending this course, students must have:-Knowledge of data integrity concepts. -Core Windows Server skills. -Relational database design skills. -Programming skills.
Duration
3 Days/Lecture & Lab
Audience
This course is intended for SQL Server database administrators, implementers, system engineers, and developers who are responsible for writing queries.
Topics
- Getting Started with Databases and Transact-SQL in SQL Server 2008
- Querying and Filtering Data
- Grouping and Summarizing Data
- Joining Data from Multiple Tables
- Working with Subqueries
- Modifying Data in Tables
- Querying Metadata, XML, and Full-Text Indexes
- Using Programming Objects for Data Retrieval
- Using Advanced Querying Techniques