Экзамен 70-461: Запросы Microsoft SQL Server 2012

Learning path description


Difficulty Level : Advanced
Exams & accreds : Microsoft Official Certification exams
Product : SQL Server
Role : Technical
Country : Ukraine
Комплект учебных материалов (Экзамен 70-461): Запросы в Microsoft SQL Server 2012 [0 h 0 m]

Ace your preparation for Microsoft® Certification Exam 70-461 with this 2-in-1 Training Kit from Microsoft Press®. Work at your own pace through a series of lessons and practical exercises, and then assess your skills with practice tests on CD—featuring multiple, customizable testing options. Maximize your performance on the exam by learning how to: •Create database objects •Work with data •Modify data •Troubleshoot and optimize queries

Launch course
Экзамен 70-461: Запросы Microsoft SQL Server 2012 [ h m]

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.

Launch course

Saving please wait...