70-461 - Querying Microsoft SQL Server 2012 Querying Microsoft SQL Server 2012
Kod egzaminu:
70-461
Nazwa:
Querying Microsoft SQL Server 2012 Querying Microsoft SQL Server 2012
Typ:
egzamin
Od kiedy:
2012-06-12
Opis:
This exam is intended for SQL Server database administrators, implementers, system engineers, and developers with two or more years of experience who are seeking to prove their skills and knowledge in writing queries. Primary responsibilities may include but are not limited to:
- Apply built-in scalar functions.
- Apply ranking functions.
- Combine datasets.
- Create and alter DML triggers.
- Create and alter indexes.
- Create and alter stored procedures.
- Create and alter tables.
- Create and alter user-defined functions (UDFs).
- Create and alter views.
- Create and modify constraints.
- Design T-SQL stored procedures.
- Design views.
- Implement aggregate queries.
- Implement data types.
- Implement error handling.
- Implement subqueries.
- Implement the sequence generator.
- Manage transactions.
- Modify data by using INSERT, UPDATE, and DELETE statements.
- Modify data by using MERGE statements.
- Optimize queries.
- Query and manage XML data.
- Query data by using SELECT statements.
- Return data by using the OUTPUT clause.
Szkolenia:
Tagi:
