MOC 2778 Writing Queries Using Microsoft SQL Server 2008 Transact-SQL

This course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2008.
Before attending this course, students must have:-Knowledge of data integrity concepts. -Core Windows Server skills. -Relational database design skills. -Programming skills.
3 Days/Lecture & Lab
This course is intended for SQL Server database administrators, implementers, system engineers, and developers who are responsible for writing queries.
  • 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

Related Scheduled Courses