Inhoud ICT-cursus 70-461 Querying Microsoft SQL Server 2012

Inhoud van de ICT-cursus 70-461 Querying Microsoft SQL Server 2012 | De Kantooropleider

Tijdens de ICT-cursus 70-461 Querying Microsoft SQL Server 2012 worden de volgende onderdelen behandeld:

Querying Basics and Modifying Data

  • describe how the SELECT statement is used to retrieve data
  • describe the characteristics of subqueries
  • use a join condition to define how tables are related
  • retrieve data from SQL Server database in a given scenario
  • alter the data in a given scenario
  • use the MERGE and OUTPUT statements to change the contents of a database in a given scenario
  • modify the contents of a databases in a given scenario

Manipulate Data Using Operators and Functions

  • describe the features of functions in SQL Server 2012
  • use built in functions in SQL Server 2012
  • determine the kind of scalar function required in a given scenario
  • manipulate data using built-in functions
  • manage results sets
  • return a single value by evaluating conditions
  • describe the considerations involved in creating summary reports
  • change a table-valued expression using the PIVOT and UNPIVOT operators in a given scenario
  • use the results returned from a subquery in an outer query
  • use operators and table expressions to work with data in given scenarios
  • determine which expression should be used in a given scenario

Creating Functions and Triggers

  • control the sequence of statement execution using control-of-flow language
  • match the transaction modes to their descriptions
  • create and modify user-defined functions
  • create a DML trigger
  • modify an existing DML trigger
  • specify the sequence of statement execution for a given scenario
  • create and modify functions and triggers in a given scenario

Creating Programming Objects and Optimizing Queries

  • recognize the characteristics of stored procedures
  • execute and modify a stored procedure in a given scenario
  • employ error handling techniques
  • use cursors to focus query results
  • use synonyms in a given scenario
  • create program objects for a given scenario
  • describe the characteristics of execution plans
  • creating a plan guide
  • create and update statistics in a given scenario
  • describe the characteristics of concurrency in SQL Server 2012
  • describe the characteristics of locking in SQL Server 2012
  • describe how queries can be optimized in a given scenario
  • improve query performance in a given scenario

Managing XML Data

  • describe the considerations involved in storing XML data directly within SQL Server 2012
  • recognize how to implement XML data storage in SQL Server 2012
  • describe the characteristics of indexes
  • recognize how to handle XML data in different scenarios
  • recognize how XPath is used
  • recognize how to query XML data using XQuery
  • recognize the modes that can be specified for a FOR XML clause
  • distinguish between regular and nested XML queries
  • retrieve and convert data using the OPENXML statement
  • use SQL Server 2012’s XML integration features
  • recognize how to manage XML data in SQL Server 2012
  • control how XML-related queries are returned

TestPrep 70-461 Querying Microsoft SQL Server 2012

  • TestPrep 70-461 Querying Microsoft SQL Server 2012
Print pagina