Prerrequisitos
Before attending this course, students must have:
•Knowledge of data integrity concepts.
•Core Windows Server skills.
•Relational database design skills.
•Programming skills.
After completing this course, students will be able to:
•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.
Module 1: Getting Started with Databases and Transact-SQL in SQL Server 2008
Module 2: Querying and Filtering Data
Module 3: Grouping and Summarizing Data
Module 4: Joining Data from Multiple Tables
Module 5: Working with Subqueries
Module 6: Modifying Data in Tables
Module 7: Querying Metadata, XML, and Full-Text Indexes
Module 8: Using Programming Objects for Data Retrieval
Module 9: Using Advanced Querying Techniques