Certifications
Cisco
Associate (CCNA)
Professional (CCNP)
CCNP Data Center
CCNP Enterprise
CCNP Security
Expert (CCIE)
CCIE Enterprise Infrastructure
CCIE Enterprise Wireless
Microsoft
Azure
MCSA
MCSD
MCSE
Modern Desktop Administrator Associate
CompTIA
A+
CySA+
IT Fundamentals
Linux+
Network+
PenTest+
Security+
Server+
AWS
AWS Foundational
AWS Architect
Ethical Hacking
ISC
2
CISSP
NetSim
CCNA
NetSim for Cisco 200-301 CCNA
CCNP
NetSim for Cisco 350-401 ENCOR
NetSim for Cisco 300-410 ENARSI
Downloads
FAQ
Practice Exams
Cisco
Associate (CCNA)
Professional (CCNP)
Expert (CCIE)
Microsoft
MCSA
MCSD
MCSE
CompTIA
A+
Network+
Security+
AWS
AWS Foundational
AWS Architect
Ethical Hacking
Ethical Hacking
(ISC)2
CISSP
Downloads
FAQ
Guarantee
Search
All Products
Instructor-Led
Cisco
Associate (CCNA)
CCNA Bootcamp
Cyber Ops
DevNet Associate, 200-901 DEVASC
Professional (CCNP)
CCNP Enterprise
CCNP Bootcamp
350-401 ENCOR
300-410 ENARSI
300-415 ENSDWI
300-420 ENSLD
300-425 ENWLSD
300-430 ENWLSI
300-435 ENAUTO
CCNP Data Center
350-601 DCCOR
300-610 DCID
300-615 DCIT
300-620 DCACI
300-625 DCSAN
300-635 DCAUTO
CCNP Security
350-701 SCOR
300-710 SNCF
300-715 SISE
300-720 SESA
300-725 SWSA
300-730 SVPN
300-735 SAUTO
CCNP Service Provider
350-501 SPCOR
300-510 SPRI
300-515 SPVI
300-535 SPAUTO
CCNP Collaboration
350-801 CLCOR
300-810 CLICA
300-815 CLACCM
300-820 CLCEI
300-835 CLAUTO
DevNet Professional
350-901 DEVCOR
300-435 ENAUTO
300-835 CLAUTO
300-635 DCAUTO
300-535 SPAUTO
300-735 SAUTO
300-910 DEVOPS
300-915 DEVIOT
300-920 DEVWBX
Expert (CCIE)
CCIE Enterprise Infrastructure – 350-401 ENCOR
CCIE Enterprise Wireless – 350-401 ENCOR
CCIE Data Center – 350-601 DCCOR
CCIE Security – 350-701 SCOR
CCIE Service Provider – 350-501 SPCOR
CCIE Collaboration –350-801 CLCOR
CompTIA
Linux+ Training
Network+ Training
Security+ Training
Ethical Hacking
Ethical Hacking
(ISC)2
CISSP Training
Microsoft
Full Course List
FAQ
Request Information
Room Rental
Courseware
Intro to Basic Networking
Courseware for 200-301 CCNA
Courseware for 350-401 ENCOR
Courseware for CISSP
Courseware Kits
Courseware Activation
FAQ
Lab Pack Activation
Samples
Practice Labs
All Practice Labs
FAQ
Video
Video Training for Cisco 200-301 CCNA
Video Training for Cisco 350-401 ENCOR
Support
Contact Us
Downloads
Free Utilities
Payment
Company Info
About Us
Boson Blog
Careers
Trademarks
Organizational & Volume Sales
About Org Sales
Resellers
Employee Training
Student Training
Government Employees
Military Personnel
FAQs
Courseware
Practice Exam
Practice Labs
NetSim
Training
Guarantees
ExSim-Max
Policies
Privacy Policy
Return Policy
Downloads
My Account
Special Offers
Personal
Support Tickets
Purchase History
My Reviews
My Practice Labs
My Video Courses
Log In
My Account
Special Offers
Personal
Support Tickets
Purchase History
My Reviews
My Practice Labs
My Video Courses
Log In
Special Offers
Personal
Support Tickets
Purchase History
My Reviews
My Video Courses
Log In
Search
NetSim
Gain Hands-on Experience
NetSim Home
NetSim for CCNA
NetSim for ENCOR
NetSim for ENARSI
Downloads
FAQ
Ex-Sim Max
Pass your Exam
Ex-Sim Max Home
AWS CLF-C01
AWS SAA-C02
Cisco 200-301 CCNA
Cisco 300-410 ENARSI
Cisco 350-401 ENCOR
CISSP
CompTIA A+ 220-1001
CompTIA A+ 220-1002
CompTIA Network+ N10-007
CompTIA Security+ SY0-501
Ethical Hacking
Microsoft 70-410
Microsoft 70-411
Microsoft 70-412
Microsoft 70-413
Microsoft 70-414
Microsoft 70-740
Microsoft 70-741
Microsoft 70-742
Microsoft 70-744
Microsoft AZ-104
Downloads
FAQ
Courseware
Learn the Material
Courseware Home
Courseware Kits
Basic Networking
CCNA
ENCOR
CISSP
Activation
FAQ
Samples
Boson Training
Instructor-led IT Training
Boson Training Home
Course List
FAQ
Request Information
Cisco
All Cisco
Associate (CCNA)
Professional (CCNP)
Expert (CCIE)
CompTIA
All CompTIA
A+
CySA+
IT Fundamentals
Linux+
Network+
PenTest+
Security+
Server+
Microsoft
All Microsoft
Azure
MCSA
MCSD
MCSE
Modern Desktop Administrator Associate
AWS
All AWS
AWS Foundational
AWS Architect
Ethical Hacking
All Ethical Hacking
(ISC)
2
All (ISC)
2
CISSP
Boson Support
Boson B2B
Contact Us
Products Only
Search
Microsoft
>
MCSE
> Practice Lab for Microsoft 70-464
Practice Lab for Microsoft 70-464
$99
$49
Exam Number
70-464
Exam Name
Developing Microsoft SQL Server 2012 Databases
Certifications
MCSE
Author
Boson
Single-User License
70-464 Practice Lab
The Practice Lab for Microsoft 70-464 provides access* to real computer equipment that is networked together and conveniently accessible over the internet.
Practice Labs
include multiple pieces of equipment that you can configure. This lab includes instructions that will guide you as you learn the concepts and technologies covered on the Microsoft 70-464 certification exam.
The Microsoft 70-464 certification exam will retire on January 31, 2021.
The 70-464 Practice-Lab will provide you with the necessary platform to gain hands on skills in Microsoft SQL Server 2012. By completing the lab tasks you will improve your practical skills in managing tables with complex statements, implementing database security and manage transactions and isolation levels. You will also maintain indexes, implement different data types, modifying constraints and working with XML data. Finally you will create automation scripts, manage views and indexes, tune queries and use estimation plans. These same tasks will help you understand the objectives and competencies required by the MCSE: Developing Microsoft SQL Server 2012 Databases certification exam.
See our
Practice Labs Youtube Playlist
to learn how to purchase, activate and access Boson Practice Labs.
*A Practice Lab purchase includes access for one (1) year from activation.
See the
Lab Videos
to learn more.
Exam Info
Candidates for this exam are database professionals who build and implement databases across organizations and ensure high levels of data availability. Responsibilities include creating database files, data types, and tables; planning, creating, and optimizing indexes; insuring data integrity; implementing views, stored procedures, and functions; and managing transactions and locks.
The 70-464: Developing Microsoft SQL Server 2012 Databases exam counts as credit toward the
MCSE
: Database Platform certification.
Benefits of Online Practice Labs
Provide dedicated live equipment without the risk or expense
Help improve practical IT skills
Can help you learn the knowledge needed to pass the certification exam
Are accessible through the internet anytime, from anywhere
Course Modules
Create and Alter Tables
Introduction
Create Schema and Tables
Create Temporary Tables and Table Variables
Summary
Design Implement and Troubleshoot Security
Introduction
Implement Security
Summary
Design the Locking Granularity Level
Introduction
Implement Transactions and Isolation Levels
Summary
Maintain Indexes
Introduction
Explore Index Statistics and Rebuild/Reorganize indexes
Summary
Implement DataTypes
Introduction
Data Types such as CLR, GUID, SPARSE, Spatial & LOB
Use Sparse Columns
Summary
Create Modify Constraints
Introduction
Create Constraints
Modify Constraints
Test Constraints for Performance Implications
Summary
Work with XML Data
Introduction
Create XML Schema Collection
Import and Export XML Data
Transform and Modify XML Data
Summary
Write Automation Scripts
Introduction
Write Automation Script to Perform Database Backup
Write Automation Script to Shrink Database
Write Automation Script to Remedy Index Fragmentation
Write Automation Script to Check Disk Space
Write Script to Automate Execution of SSIS Package
Summary
Design T-SQL Table-Valued and Scalar Functions
Introduction
Work with Scalar and Table Valued Function
Implement Set Based Vs Procedural Approach
Summary
Create and Alter Views
Introduction
Create and Modify Views
Implement Partitioned View
Summary
Create and Alter Indexes
Introduction
Implement Full Text and Filtered Index
Create Non Clustered and Column Store Index
Implement Semantic Index
Create Filtered Statistics and Full Statistics
Summary
Optimize and Tune Queries
Introduction
Tuning Queries
Use Recursive CTE
Implement Full Text Search and Use Hints to Control Execution Plans
Summary
Capture and Analyzie Estimation Plan
Introduction
Use Actual and Estimated Execution Plans
Summary
See all
Microsoft
|
MCSA
|
MCSE
|
Practice Labs
|
Practice Labs FAQ
Practice Lab for Microsoft 70-464
$99
$49
Related Kits
Create Your Own Practice Lab Kit - Pick 2
$179
Details
Create Your Own Practice Lab Kit - Pick 3
$259
Details
Create Your Own Practice Lab Kit - Pick 5
$419
Details
Create Your Own Practice Lab Kit - Pick 7
$559
Details
Create Your Own Practice Lab Kit - Pick 10
$699
Details
Create Your Own Practice Lab Kit - Pick 15
$849
Details
Reviews
Be the first to review this product. If you have used this product, you can
review it
on your account page. You must be logged in to review products.
MIC-PL-70464-01