SQL Server Training Kit [70-461].pdf

(14627 KB) Pobierz
70-461
Querying Microsoft
SQL Server 2012
®
®
EXAM
Training Kit
Itzik Ben-Gan
Dejan Sarka
Ron Talmage
EXAM 70-461
Querying Microsoft
SQL Server 2012
Microsoft Certified Solutions Associate
The new MCSA certifications validate the core
technical skills required to build a sustainable
career in IT. MCSA opens the door to multiple
career paths and is a requirement for MCSE
certifications.
Exam 70-641
is one of three required exams for
MCSA:
SQL Server 2012 certification.
For complete information on Microsoft Certifications,
visit:
microsoft.com/learning/certification
1
2
Your 2-in-1 Self-Paced Training Kit
EXAM PREP GUIDE
Ace your preparation for the skills measured by Exam 70-461—and
on the job. Work at your own pace through a series of lessons and
reviews that fully cover each exam objective. Then, reinforce and
apply what you’ve learned through real-world case scenarios and
practice exercises. This official Microsoft study guide is designed to
help make the most of your study time.
Maximize your performance on the exam by learning to:
•
Write queries and work with database entities using
T-SQL
•
Choose the right data type for your database structure
•
Create, modify, and delete tables using T-SQL
•
Implement aggregate queries and XML schemas
•
Modify data by using INSERT, UPDATE, and DELETE
statements
•
Identify performance issues and optimize query
execution
Your kit includes:
·
15% exam discount from Microsoft.
Offer expires 12/31/2017. Details inside.
·
Official self-paced study guide.
·
Practice tests with multiple, and a
customizable testing options
·
·
·
learning plan based on your results.
200+ practice and review questions.
Case scenarios, exercises, and best
practices.
Fully searchable eBook of this guide.
For
system requirements,
see the Introduction.
PRACTICE TESTS
Assess your skills with practice tests on CD. You can work through
hundreds of questions using multiple testing modes to meet your
specific learning needs. You get detailed explanations for right
and
wrong answers—including a customized learning path that
describes how and where to focus your studies.
About the Authors
Itzik Ben-Gan
is a Microsoft MVP for SQL Server
and T-SQL expert who has written many books
on the subject, including
Microsoft SQL Server
2012 T-SQL Fundamentals.
Dejan Sarka,
a Microsoft MVP for SQL Server
who focuses on database development and BI
applications, is coauthor of the
Training Kit
for
Exam 70-463.
Ron Talmage
is a Microsoft MVP for SQL Server
who has contributed to numerous SQL Server
white papers and articles.
microsoft.com/mspress
U.S.A. $69.99
Canada $73.99
[Recommended]
Certification/
Microsoft SQL Server
Best Exam
Preparation Product
Exam 70-461: Querying Microsoft SQL Server 2012
Objective
1. create Database Objects
1.1 Create and alter tables using T-SQL syntax (simple statements).
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.
chapter
8
9
15
9
8
13
1
2
3
4
5
6
8
9
12
4
5
17
2
3
5
7
13
10
11
2
4
11
2
3
6
13
12
14
15
17
12
16
12
16
LessOn
1
1
1
1
2
2
1
2
All lessons
All lessons
3
Lessons 2 and 3
2
2
3
2
2
1
2
1
Lessons 1 and 3
All lessons
All lessons
All lessons
3
2
3
2
2
1
3
3
Both lessons
All lessons
All lessons
All lessons
1
1
2
1
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.
3.4 Work with functions.
4. trOubLeshOOt & OptiMize
4.1 Optimize queries.
4.2 Manage transactions.
4.3 Evaluate the use of row-based operations vs. set-based operations.
4.4 Implement error handling.
exam Objectives
The exam objectives listed here are current as of this book’s publication date. Exam objectives are
subject to change at any time without prior notice and at Microsoft’s sole discretion. Please visit the Microsoft Learning
website for the most current listing of exam objectives:
http://www.microsoft.com/learning/en/us/exam.aspx?ID=
70-461&locale=en-us.
Querying Microsoft
SQL Server 2012
®
®
Exam 70-461
Training Kit
Itzik Ben-Gan
Dejan Sarka
Ron Talmage

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika:

Zgłoś jeśli naruszono regulamin