70-461 Braindumps Pass4sure

1

• Microsoft SQL Server 2012 Certifications and
  Training

• Microsoft Learning

2
Agenda
MCSE Business Intelligence
MCSE Data Platform
Training
MCSA SQL Server 2012
http//www.pass4sureexam.co/70-461.html
3

• Certifications

4
Value of Certification
Recognition
Differentiation
Employability
http//www.pass4sureexam.co/70-461.html
5
Changes to the Certifications and Exams
Certification Requirements
Broader Skill Set
Relevance
Rigor
Deeper Skill Set
Recertification
http//www.pass4sureexam.co/70-461.html
6
SQL Server 2012 Certification paths
MCA SQL Server
MCSM SQL Server
MCSM Business Intelligence
Master
MCSE Data Platform
MCSE Business Intelligence
Recertification
Recertification
Destination
Designing Database Solutions (Exam 465)
Developing Databases (Exam 464)
Implementing Data Models and Reports (Exam 466)
Designing Business Intelligence Solutions (Exam
467)
Expert
MCSA SQL Server 2012
Administering Databases (Exam 462)
Implementing a Data Warehouse (Exam 463)
Querying (Exam 461)
Associate
7
MCSA SQL Server 2012
Microsoft Certified Solutions Associate
SQL Server 2012
Show that you have a minimum set of skills to hit
the ground running.

Exam 70-463 Implementing Data Warehouses with
Microsoft SQL Server 2012

Exam 70-462 Administering a Microsoft SQL Server
2012 Database
Develop and maintain the next wave of mission
critical environments and breakthrough insights.

Exam 461 Querying Microsoft SQL Server 2012
8
MCSE Business Intelligence
Microsoft Certified Solutions Expert
Business Intelligence
Showcase your expert skills at developing and
deploying rich business intelligence solutions.

Exam 467 Designing Business Intelligence
Solutions with SQL Server 2012

Exam 466 Implementing Data Models and Reports
with SQL Server 2012
Deliver more data to more people across the
organization.

Microsoft Certified Solutions Associate SQL
Server 2012
9
MCSE Data Platform
Microsoft Certified Solutions Expert Data
Platform
Demonstrate your expertise at building
enterprise-scale data solutions.

Exam 465 Designing Database Solutions for SQL
Server 2012

Exam 464 Developing SQL Server 2012 Databases
Extend your skills beyond traditional database
capabilities.

Microsoft Certified Solutions Associate SQL
Server 2012
10
Database roles convergence
http//www.pass4sureexam.co/70-461.html
11
Recertification ensures up-to-date skills
Recertifying also earns you the new MCSA
Replaces upgrade at expert level
Protects your cert from being devalued
Proves latest skills in the solution area
Recertification
Expert-level cert names not versioned
Transcript will show upcoming inactive date
In most cases, requirement will be one exam
MCSEs will need to recertify every three years
http//www.pass4sureexam.co/70-461.html
12
More challenging item types
Choose All That Apply
Case Studies
Code Review
Extending Matching items
Best Answer
Build Lists
Drag Drop
Active Screen
!Be sure to view the exam item type demo to see
these item types!
13

• Upgrade paths

14
Upgrade to MCSE Data Platform
MCITP Database Developer 2008 or MCITP
Database Administrator 2008
MCSE Data Platform



457
458
458
NOTE All Upgrade paths are subject to change
until final release.
Requires recertification
http//www.pass4sureexam.co/70-461.html
15
Upgrade to MCSE Business Intelligence
MCSE Business Intelligence
MCITP Business Intelligence Developer 2008


457
458
NOTE All Upgrade paths are subject to change
until final release.
Requires recertification
http//www.pass4sureexam.co/70-461.html
16
Upgrade to MCSA SQL Server 2012
MCTS on SQL Server 2008
MCSA SQL Server 2012

457
458
457
458
NOTE All Upgrade paths are subject to change
until final release.
Requires recertification
http//www.pass4sureexam.co/70-461.html
17

• SQL Server Instructor-Led Training

18
Microsoft Official Courseware
Exam 461
Course 10774
Course 10775
Exam 462
Exam 464
Course 10776
Exam 463
Course 10777
Exam 466
Course 10778
19
Microsoft PressExam prep
Exam 461
Training Kit, Rapid Review
Querying Microsoft SQL Server 2012
Administering Microsoft SQL Server 2012
Databases
Training Kit, Rapid Review
Exam 462
Implementing a Data Warehouse with Microsoft SQL
Server 2012
Training Kit, Rapid Review
Exam 463
Developing Microsoft SQL Server 2012 Databases
Exam 464
Exam Ref
Designing Database Solutions for Microsoft SQL
Server 2012
Exam 465
Exam Ref
Exam 466
Exam Ref
Implementing Data Models and Reports with SQL
Server 2012
Designing BI Sols with Microsoft SQL Server 2012
Platform
Exam 467
Exam Ref
Training Kits available mid-August 2012 Rapid
Reviews available December 2012 Exam Refs
available March 2013
20
Additional resources
Microsoft.com/learning

• SQL Server certifications
• SQL Server training
• Learning snacks
• Free ebook Introducing Microsoft SQL Server 2012

Born to Learn

• SQL Server forums
• MCT SQL Server wiki

Microsoftvirtualacademy.com

• Breakthrough Insights using Microsoft SQL Server
  2012 - Analysis Services
• Breakthrough Insights using Microsoft SQL Server
  2012 - Scalable data warehouse
• Breakthrough Insights using Microsoft SQL Server
  2012 - Reporting Services
• Cloud on your terms with Microsoft SQL server
  2012 Scale on demand

TechNet.com

• Download trial version
• Virtual labs
• Tutorials
• Demos

21

• Questions

22
2012 Microsoft Corporation. All rights
reserved. Microsoft, Windows, Windows Vista and
other product names are or may be registered
trademarks and/or trademarks in the U.S. and/or
other countries. The information herein is for
informational purposes only and represents the
current view of Microsoft Corporation as of the
date of this presentation. Because Microsoft
must respond to changing market conditions, it
should not be interpreted to be a commitment on
the part of Microsoft, and Microsoft cannot
guarantee the accuracy of any information
provided after the date of this presentation.
MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED
OR STATUTORY, AS TO THE INFORMATION IN THIS
PRESENTATION.
23

• Appendix

24
Frequently asked questions
Question Answer
Why did you change the certification names? The names were changed to better reflect the experience, knowledge, and skills that IT Professionals and Developers need to build and manage technology solutions that may include multiple technologies, whether on-premise or in the cloud.
When will exams be available to upgrade from SQL Server 2008? Upgrade exams will be released by August 2012.
My transcript shows that I earned the Microsoft Certified Solutions Associate SQL Server 2008 certification. How did I get it? If you passed Exams 70-432 and 70-448, or you have achieved the MCTS Microsoft SQL Server 2008, Implementation and Maintenance and the MCTS SQL Server 2008, Business Intelligence Development and Maintenance certifications, you automatically earn the Microsoft Certified Solutions Associate (MCSA) certification on SQL Server 2008.
How do these changes impact my existing Microsoft Certifications? The existing MCTS, MCITP, and MCPD Certifications are currently valuable in the market and will remain valuable as long as companies are using the technology covered in your certification.
How long will I be able to earn an MCITP or MCTS Certification on SQL Server 2008? After April 2013, you will no longer be able to achieve an MCTS or MCITP certification on SQL Server 2008. However, the MCSA SQL Server 2008 will still be available to earn.
What happens if I pass a single exam? When you pass a single exam, you become a member of the Microsoft Certification Program. You can share your transcript with others to prove that you passed that exam and show your progress towards a specific certification.
http//www.pass4sureexam.co/70-461.html
25
More frequently asked questions
Question Answer
What is the recertification requirement? To ensure that our certifications remain a meaningful and valuable indicator of candidates skills, Microsoft Certified Solutions Expert (MCSE) certifications will require recertification every three years.
Why is this recertification requirement being implemented? Recertification ensures that Microsoft Certifications remain a meaningful and valuable indicator of candidates skills. Recertification provides assurance to hiring managers and other stakeholders that certified candidates have demonstrated continued competence even as the technology has changed based on service packs, revisions, and new product version releases.
Will MCSA certifications require recertification also? The recertification requirement does not apply to Microsoft Certified Solutions Associate (MCSA) certifications.
Why did you raise the expectations for minimum skills? We raised the minimum expectations in order to recognize and validate the full set of skills that a candidate would need to successfully work with across a technology solution and included topics relevant to working with solutions in the cloud. By increasing the minimum expectations and the skills validated, individuals will be more successful in working with Microsoft technologies and better able to satisfy the needs of the organization.
How did you make the exams more challenging? There are many aspects to a candidate's perception of how challenging an exam is. We made changes to our certification program to address each of those aspects, including setting the bar higher for minimum experience that we expect from successful candidates, validating more difficult skills, using more challenging question types, and implementing security enhancements in our exams and test centers.
26
MCSA SQL Server 2008
Microsoft Certified Solutions Associate
SQL Server 2008
The MCSA SQL Server 2008 certification shows
that you have a minimum set of skills to hit the
ground running.

Exam 70-448 Implementing Data Warehouses with
Microsoft SQL Server 2012

Exam 70-432 Administering a Microsoft SQL Server
2012 Database
Demonstrate your essential skills on SQL Server
2008 by earning the MCSA SQL Server 2008
certification.
Note MCSA SQL Server 2008 certification does
not count towards the MCSE Data Platform or
MCSE Business Intelligence certifications.
However, candidates can upgrade from MCSA SQL
Server 2008 to MCSA SQL Server 2012 by taking
two exams.
27
Reinvented for the Cloud
Microsoft has reinvented its certifications by
building cloud related skills validation into the
industrys most recognized and respected
certification program. Microsoft Certifications
remains the method by which IT Pros and
Developers stand out from their peers and for
employers to recognize candidates/employees who
have the skills required to be productive. To
ensure Microsoft Certifications remain relevant,
they now validate a broader and deeper set of
cloud skills and experience across a technology
solution.
IT Pro Developer benefits
Hiring Manager benefits
Get hired Get a job building the future.
Microsoft ensures its certifications are on the
cutting-edge of technology and are valued by
businesses, helping professionals get hired in
todays highly competitive market.
Get Recognized Get recognized by peers and
hiring managers. Microsoft Certification
distinguishes the ability of professionals to
deploy, design, optimize and operate technologies
for critical IT roles.
Get verification employee knowledge is
current .
Get qualified candidates
A 2011 study showed 86 of hiring managers
indicate IT certifications are a high or medium
priority during the candidate evaluation
process CompTIA Feb, 2011 Press Release
A certification research report, 64 of IT
hiring managers rate certifications as having
extremely high or high value in validating the
skills and expertise of job candidates
Channelinsider.com, 2011-10-19
A certification research report, 89 of IT hiring
managers say that IT certifications help confirm
subject matter knowledge and expertise
Channelinsider.com, 2011-10-19
In a survey of 700 IT professionals, 60 said
certification led to a new job Network World,
11/14/2011
28
New Technical Certification Names
Hiring Manager
Brand recognition
Consistency across the stack
Easy to communicate
Value of certification
Level 2 is the destination
29
MS PressPlanned books
High Performance T-SQL Using Windows Functions
SQL Server 2012 Internals
Microsoft SQL Server 2012 Analysis Services the
BISM Tabular Model
SQL Server 2012 Integration Services
Programming Microsoft SQL Server 2012
SQL Server 2012 Administration Inside Out
SQL Server 2012 Reporting Services
SQL Server 2012 Step by Step
Introducing Microsoft SQL Server 2012
T-SQL Fundamentals
30
Virtual Machine Plan

• Hardware Level 6
• Minimum level no less than 8GB RAM, more is
  better
• Windows Server 2008 R2 SP1 host machines
• Base 11A (WS2008R2 HyperV SP1)
• MIA-DC (domain controller, 512MB)
• MIA-SQL1 (SQL 2012, no BI components)
• Used by 10774, 10775, 10776
• MIA-SQLBI (SQL 2012, all BI components,
  Sharepoint)
• Used by 10777, 10778
• Internet access for SQL Azure
• Introducing the TMG VM

31
MSL Hardware Level 6

• Intel 64bit Virtualization Technology (Intel VT)
  or AMD Virtualization (AMD-V) processor (2.8 GHz
  dual core or better recommended)
• Dual 120 GB hard disks 7200 RPM SATA or better
• 4 GB RAM expandable to 8GB or higher
• DVD drive
• Network adapter
• Super VGA (SVGA) 17-inch monitor
• Microsoft Mouse or compatible pointing device
• Sound card with amplified speakers

32
SQL Azure

• SQL Azure an integrated story for off-premise
  data
• Options for existing SQL training
• In SQL 2012 Courseware
• Design approach
• Labs
• Student Azure Accounts

33
Custom Deliveries

• Many diverse secondary audiences
• Modules Labs designed for modularity
• Examples
• T-SQL for Report Developers
• Four day first four days of 10774 10778
  module 3
• Data Quality in SQL Server 2012
• One day 10777 modules 7, 9, 10
• Building Reports and Visualizations with SQL
  Server 2012
• Two day 10778 modules 2, 3, 10, 11, 13
• Student Azure Accounts

34
10774 Writing Queries Using Microsoft SQL
Server 2012 Transact-SQL

• Module 11 Use Set Operators
• Module 12 Using Window Ranking, Offset and
  Aggregate Functions
• Module 13 Pivoting and Grouping Sets
• Module 14 Writing Specialized Queries
• Module 15 Executing Stored Procedures
• Module 16 Programming with T-SQL
• Module 17 Implementing Error Handling
• Module 18 Implementing Transactions
• Module 19 Querying SQL Server Metadata
• Module 20 Improving Query Performance

• Module 1 Introduction to SQL Server 2012
• Module 2 Introduction to Transact SQL Querying
• Module 3 Writing SELECT Statements
• Module 4 Combining Data from Multiple Tables
• Module 5 Filtering and Sorting Data
• Module 6 Working with SQL Server Data Types
• Module 7 Using Built-In Functions
• Module 8 Grouping and Aggregating Data
• Module 9 Using Subqueries
• Module 10 Using Table Expressions

35
10775 Course 10775A Administering a Microsoft
SQL Server 2012 Database

• Module 1 Introduction to SQL Server 2012 and its
  Toolset
• Module 2 Preparing Systems for SQL Server 2012
• Module 3 Installing and Configuring SQL Server
  2012
• Module 4 Working with Databases
• Module 5 Understanding SQL Server 2012 Recovery
  Models
• Module 6 Backup of SQL Server 2012 Databases
• Module 7 Restoring SQL Server 2012 Databases
• Module 8 Importing and Exporting Data
• Module 9 Authenticating and Authorizing Users
• Module 10 Assigning Server and Database Roles

• Module 11 Authorizing Users to Access Resources
• Module 12 Auditing SQL Server Environments
• Module 13 Automating SQL Server 2012 Management
• Module 14 Configuring Security for SQL Server
  Agent
• Module 15 Monitoring SQL Server 2012 with Alerts
  and Notifications
• Module 16 Performing Ongoing Database
  Maintenance
• Module 17 Tracing Access to SQL Server 2012
• Module 18 Monitoring SQL Server 2012
• Module 19 Managing Multiple Servers
• Module 20 Troubleshooting Common SQL Server 2012
  Administrative Issues

36
10776 Developing a Microsoft SQL Server 2012
Database

• Module 1 Introduction to SQL Server 2012 and its
  ToolsetModule 2 Working with Data Types
• Module 3 Designing and Implementing Tables
• Module 4 Ensuring Data Integrity through
  Constraints
• Module 5 Planning for SQL Server 2012 Indexing
• Module 6 Implementing Table Structures in SQL
  Server 2012
• Module 7 Reading SQL Server 2012 Execution Plans
• Module 8 Improving Performance through
  Non-Clustered Indexes
• Module 9 Designing and Implementing Views
• Module 10 Designing and Implementing Stored
  Procedures

• Module 11 Merging Data and Passing Tables
• Module 12 Designing and Implementing
  User-Defined Functions
• Module 13 Creating Highly Concurrent SQL Server
  2012 Applications
• Module 14 Handling Errors in T-SQL Code
• Module 15 Responding to Data Manipulation via
  Triggers
• Module 16 Implementing Managed Code in SQL
  Server 2012
• Module 17 Storing XML Data in SQL Server 2012
• Module 18 Querying XML Data in SQL Server 2012
• Module 19 Working with SQL Server 2012 Spatial
  Data
• Module 20 Working with Full-Text Indexes and
  Queries

37
10777 Implementing a Data Warehouse with
Microsoft SQL Server 2012

• Module 1 Introduction to Data Warehouse Concepts
• Module 2 Data Warehouse Hardware Considerations
• Module 3 Designing and Implementing a Data
  Warehouse
• Module 4 Creating an ETL Solution with SSIS
• Module 5 Implementing Control Flow in an SSIS
  Package
• Module 6 Debugging and Troubleshooting SSIS
  Packages
• Module 7 Implementing an Incremental ETL Process
• Module 8 Incorporating Data from the Cloud in a
  Data Warehouse
• Module 9 Enforcing Data Quality
• Module 10 Using Master Data Services
• Module 11 Extending SSIS
• Module 12 Deploying and Configuring SSIS
  Packages
• Module 13 Consuming Data in a Data Warehouse

38
10778 Implementing Data Models and Reports with
Microsoft SQL Server 2012

• Module 1 Overview of Reporting and Data Modeling
• Module 2 Implementing Reports with Reporting
  Services
• Module 3 Supporting Self-Service Reporting
• Module 4 Managing a Reporting Infrastructure
• Module 5 Creating Multidimensional Databases
• Module 6 Working with Cubes and Dimensions
• Module 7 Working with Measures and Measure
  Groups
• Module 8 Introduction to MDX
• Module 9 Customizing Cube Functionality
• Module 10 Implementing a PowerPivot for Excel
  Workbook
• Module 11 Introduction to Data Analysis
  Expression (DAX)
• Module 12 Implementing a Tabular Database
• Module 13 Creating Data Visualizations With
  Crescent
• Module 14 Performing Predictive Analysis with
  Data Mining