Every registration supports local education. TrainUp Gives Back

Your Career Training Marketplace

Questions? Call Toll-Free: 1-866-540-9677

  • Instant Access ImageInstant Access
    From Anywhere
  • Unlimited Viewing ImageUnlimited
  • calendar Image 6-12 Months
    To Complete


SQL Server 2012 allows programming objects to be created to group multiple statements together. These objects work with data in the databases. One type of programming object is the stored procedure. Stored procedures can help reduce network traffic between clients and servers by enabling more than one statement to be set to the server at a time. They do this by executing statements as batches. They also provide greater security. Within stored procedures and other programming objects such as functions and triggers, error handling can be implemented to enable errors to be caught and corrected or returned to the user. Cursors and synonyms can also be used in SQL Server 2012. During user interactions with the database resource SQL Server implements certain mechanisms to ensure the integrity of the database, which includes concurrency control and locking. This course demonstrates how to create stored procedures, cursors, and synonyms, as well as how to implement error handling. It also discusses how to view and read execution plans, create plan guides and how concurrency control is handled in SQL Server 2012. This course is one of a series in the SkillSoft learning path that covers the objectives for the exam 70-461: Microsoft SQL Server 2012: Querying. This exam is one of the requirements for the Microsoft Certified Solutions Associated (MCSA): SQL Server 2012 certification.

Learning Objectives
  • 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
  • Audience

Get the latest industry news, recommended courses, & promotions from TrainUp.com sent straight to your inbox.