Exam Prep for 70-461: The unofficial guide

enriquelima — Sat, 10 Jan 2015 21:25:00 +0000

It is that time again, time to prepare for new certs, or just recert.

Here are the materials I am using to prepare and help others prepare to embark on this exam.

Create database objects

Objective

Materials

Create and alter tables using T-SQL syntax (simple statements)
Create and alter views (simple statements)
Design views
Create and modify constraints (simple statements)
Create and alter DML triggers

http://msdn.microsoft.com/en-us/library/ms188264.aspx

http://msdn.microsoft.com/en-us/library/ms190273(v=sql.110).aspx

http://msdn.microsoft.com/library/ms190174.aspx

Work with data

Objective

Materials

Query data using SELECT statements
Implement sub-queries
Implement data types
Implement aggregate queries
Query and manage XML data

http://msdn.microsoft.com/library/ms189499.aspx

http://msdn.microsoft.com/library/ms188029.aspx

http://msdn.microsoft.com/library/ms177634.aspx

Modify data

Objective

Materials

Create and alter stored procedures (simple statements)
Modify data by using INSERT, UPDATE, and DELETE statements
Combine datasets
Work with functions

http://msdn.microsoft.com/library/ms187926.aspx

http://msdn.microsoft.com/library/ms189762.aspx

http://msdn.microsoft.com/library/ms174335.aspx

http://msdn.microsoft.com/en-us/library/ms189835.aspx

http://msdn.microsoft.com/en-us/library/ms177523.aspx

Troubleshoot and optimize

Objective

Materials

Optimize queries
Manage transactions
Evaluate the use of row-based operations vs. set-based operations
Implement error handling

http://msdn.microsoft.com/library/ms174377.aspx

http://msdn.microsoft.com/library/ms173763.aspx

http://msdn.microsoft.com/library/ms191179.aspx

Additional Resources

Resource	Materials
MVA: Querying Microsoft SQL Server 2012 Databases	http://www.microsoftvirtualacademy.com/training-courses/querying-microsoft-sql-server-2012-databases-jump-start?WT.mc_id=msls_mva
Training Kit (Exam 70-461): Querying Microsoft SQL Server 2012	https://www.microsoftpressstore.com/store/training-kit-exam-70-461-querying-microsoft-sql-server-9780735666054

The post Exam Prep for 70-461: The unofficial guide appeared first on Intentional Thinking.