Born To Learn
Training and Certification Community
Home » Microsoft Certification Study Groups » Database Certification Study Group » Database Certification Exam Prep Resources » 461: Querying Microsoft SQL Server 2012

461: Querying Microsoft SQL Server 2012

Database Certification Study Group
Related Resources
Schedule
Table of Contents
Options
Page Details

Reminder: Some of the content contained on these wiki pages is contributed by members of the community and Microsoft provides no specific endorsement for any third party resources listed here. Please review the Code of Conduct and Terms of Use for detailed guidelines.

Database Certification Exam Prep Resources

Rate This:

461: Querying Microsoft SQL Server 2012

Preparation Tools and Resources

Search here for prep resources for specific exam topics and add any exam prep resources that you have found helpful in preparing for this exam.

General preparation material

Learning plans and classroom training

Microsoft Press books

 

Training Kit 70-461: Querying Microsoft SQL Server 2012
By: Itzik Ben-Gan, Dejan Sarka, Ron Talmage 
Released: December 2012

Buy this book from   (Official distributor of Microsoft Press)

Prep resources by objective

Show all

1  Create Database Objects

1.1  Create and alter tables using T-SQL syntax

1.2  Create and alter views (simple statements)

1.3  Design views

1.4  Create and modify constraints (simple statements)

1.5  Create and alter DML triggers

2  Work with Data

2.1  Query data by using SELECT statements

2.2  Implement sub-queries

2.3  Implement data types

2.4  Implement aggregate queries

  • <<Add your resources here>>
  • <<Add your resources here>>

2.5  Query and manage XML data

  • <<Add your resources here>>
  • <<Add your resources here>>

3  Modify Data

3.1  Create and alter stored procedures (simple statements)

  • <<Add your resources here>>
  • <<Add your resources here>>

3.2  Modify data by using INSERT, UPDATE, and DELETE statements

  • <<Add your resources here>>
  • <<Add your resources here>>

3.3  Combine datasets

  • <<Add your resources here>>
  • <<Add your resources here>>

3.4  Work with functions

  • <<Add your resources here>>
  • <<Add your resources here>>

4  Troubleshoot & Optimize

4.1  Optimize queries

  • <<Add your resources here>>
  • <<Add your resources here>>

4.2  Manage transactions

  • <<Add your resources here>>
  • <<Add your resources here>>

4.3  Evaluate the use of row-based operations vs. set-based operations

  • <<Add your resources here>>
  • <<Add your resources here>>

4.4  Implementing error handling

70-461, database certification, Exam Prep, study group
Comments
  • chrisbclark11225.yahoo.com
    |
    2 Aug 2013 4:05 AM

    Hi; been studying to prepare for the SQL Server Developer Exam (433, 461) for the last year. Have failed the exam twice.  Need a new study plan.  My background is that I am new to IT and am trying to break into the field.  I have taken online prep classes, studied with a tutor and read the Microsoft training manuel 70-433 three times. How long should it reasonably take for somebody to study and pass this exam?  I would appreciate any advice I can get.  Thank you.

  • chrisbclark11225.yahoo.com
    |
    2 Aug 2013 4:05 AM

    Hi; been studying to prepare for the SQL Server Developer Exam (433, 461) for the last year. Have failed the exam twice.  Need a new study plan.  My background is that I am new to IT and am trying to break into the field.  I have taken online prep classes, studied with a tutor and read the Microsoft training manuel 70-433 three times. How long should it reasonably take for somebody to study and pass this exam?  I would appreciate any advice I can get.  Thank you.

  • cliff.harrison.live.com
    |
    2 Aug 2013 3:54 PM

    Hi chrisbclark, There is no better way to learn than to do. Download a copy of SQL Server, and go through the course objectives one by one, working through all the examples you can find. This is how I managed to get passes in the exams I have taken.

    Regards,

    Cliff Harrison.

More Microsoft sites

About

Support

Related sites

Regional Service Centers

Popular resources

Member sites