Resources: Exam 70-461: Querying Microsoft SQL Server 2012

RobertKaucher

Data Platform
Exam 70-461: Querying Microsoft SQL Server 2012


Exam 70-462: Administering Microsoft SQL Server 2012 Databases


Exam 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012


Exam 70-464: Developing Microsoft SQL Server 2012 Databases


Exam 70-465: Designing Database Solutions for Microsoft SQL Server 2012

Exam 70-461: Querying Microsoft SQL Server 2012

General Resources
Database Management | Data Mining & Warehousing | Microsoft SQL Server
5 Things to Know about SQL Server Denali 2011 2012 | Brent Ozar PLF

Audience Profile
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.
Built-in Functions (Transact-SQL) [MSDN Reference]
• Apply ranking functions.
Ranking Functions (Transact-SQL) [MSDN Reference]
• Combine datasets.
Transact-SQL Joins [MSDN Reference (SQL Server 2000)]
Join Fundamentals [MSDN Reference (SQL Server 2000)]
http://4.bp.blogspot.com/_gWQaU40PH24/TG_d4LWGqYI/AAAAAAAAI0I/szwmLmy2t44/s640/Visual_SQL_JOINS_V2.png
T-SQL Misconceptions - JOIN ON vs. WHERE - Blog do Ezequiel - Site Home - MSDN Blogs
• Create and alter DML triggers.
CREATE TRIGGER (Transact-SQL) [MSDN Reference]
ALTER TRIGGER (Transact-SQL) [MSDN Reference]
• Create and alter indexes.
Indexes [MSDN Reference]
Columnstore Indexes [MSDN Reference]
CREATE COLUMNSTORE INDEX (Transact-SQL) [MSDN Reference]
SQL Server Performance: Indexing Basics - Online Training Course for .NET Developers [PluralSight Paid Training (they have a trial but worth the $30)]
CREATE INDEX (Transact-SQL) [MSDN Reference]
SQL SERVER – Understanding new Index Type of SQL Server 2005 Included Column Index along with Clustered Index and Non-clustered Index « SQL Server Journey with SQL Authority
SQL SERVER – Fundamentals of Columnstore Index « SQL Server Journey with SQL Authority
SQL Server Columnstore Index Performance Demonstration - YouTube