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

Social Resources

Prep resources by objective

Microsoft Certification PREP Talk: Exam 461

In this episode of Prep tips from certification experts, James Seymour, Certification Planner, and Dandy Weyn, Senior Program Manager on the SQL Server product group, discuss the relevancy of the skills being measured on Exam 461.

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)

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

2.5  Query and manage XML data

3  Modify Data

3.1  Create and alter stored procedures (simple statements)

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

3.3  Combine datasets

  • FROM (Joining Tables)
  • <<Add your resources here>>

3.4  Work with functions

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

4  Troubleshoot & Optimize

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

Comments
  • chrisbclark11225.yahoo.com
    |

    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
    |

    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
    |

    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.

  • michael.lenard.hotmail.com
    |

    Dear MS,

    I am looking to take the 3 course package with Prometric, with a 15% discount. I see on the "Cert Challenge" page it has been extended to June 2014, but upon visiting the Prometric page the links to the offer are not working. Can somebody look into this ASAP as I want to start my certification?

    Thanks,

    Mike