|
If you are looking for preparation materials for 70-461 exam querying Microsoft SQL Server 2012 than hopefully you will find this blog posts useful.
If you are new to SQL we suggest to start with our SQL Tutorial first.
Content:
|
Exam Preparations Video
|
Number of Questions: 45-55
Passing Score: 700 points (70%)
Exam Time: 120 Minutes
|
|
Create Database Objects (24%)
-
Create and alter tables
-
Create and alter views
-
Design views
-
Create and modify constraints
-
Create and alter DML triggers
|
Modify Data (24%)
-
Create and alter stored procedures
-
Modify data by using INSERT, UPDATE, and DELETE statements
-
Combine datasets
-
Work with functions
|
|
Work with Data (27%)
-
Query data by using SELECT statements
-
Implement sub-queries
-
Implement data types
-
Implement aggregate queries
-
Query and manage XML data
|
Troubleshoot and Optimize Queries (25%)
-
Optimize queries
-
Manage transactions
-
Evaluate the use of row-based operations vs. set-based operations
-
Implement error handling
|
Ranking Functions (Free)
Take care
Katie & Emil
|
Share:
Comments Add Comment
No data was returned.
Share your thoughts, questions and suggest improvements:
Add Comment
