Implementing Tables and Views
- Create and alter tables.
- Create and alter views.
- Create and alter indexes.
- Create and modify constraints.
- Implement data types.
- Implement partitioning solutions.
Implementing Programming Objects
- Create and alter stored procedures.
- Create and alter user-defined functions (UDFs).
- Create and alter DML triggers.
- Create and alter DDL triggers.
- Create and deploy CLR-based objects.
- Implement error handling.
- Manage transactions.
Working with Query Fundamentals
- Query data by using SELECT statements.
- Modify data by using INSERT, UPDATE, and DELETE statements.
- Return data by using the OUTPUT clause.
- Modify data by using MERGE statements.
- Implement aggregate queries.
- Combine datasets.
- Apply built-in scalar functions.
Applying Additional Query Techniques
- Implement subqueries.
- Implement CTE (common table expression) queries.
- Apply ranking functions.
- Control execution plans.
- Manage international considerations.
Working with Additional SQL Server Components
- Integrate Database Mail.
- Implement full-text search.
- Implement scripts by using Windows PowerShell and SQL Server Management Objects(SMOs).
- Implement Service Broker solutions.
- Track data changes.
Working with XML Data
- Retrieve relational data as XML.
- Transform XML data into relational data.
- Query XML data.
- Manage XML data.
Gathering Performance Information
- Capture execution plans.
- Gather trace information by using the SQL Server Profiler.
- Collect output from the Database Engine Tuning Advisor. Collect information from system metadata.
