About Us|Contact Us|Learn Now: Find a Course
Like us and Save!  Join our Mailing List and Save!
Connect with us for News & Exclusive Offers:
View Cart
Contact Us


Microsoft SQL Server 2012 Tutorial - Certification Exam 70-462

SPECIAL OFFER: 20% DISCOUNT & FREE SHIPPING!
 Professionally created, self-study video training.

About this Tutorialshow details
Learn this relational database management system from an administrative stance with the help of these Microsoft SQL Server 2012 tutorial videos.

Commencing with the basics, expert SQL Server tutor Denny Cherry uses high quality training videos that help explain and demonstrate the key concepts and techniques, which will help best prepare you for the Microsoft 70-462 Admin certification exam.

Through over eleven hours of professionally created training videos, the tuition includes the improvements for 2012, installation step-by-step, learning how to manage SQL Server, lessons on automation techniques, security considerations explained, best practices for backup and recovery and so much more.

The complete training course contents are listed below and you can start learning right away, click any of the blue linked lessons to sample FREE SQL Server 2012 video tutorials and discover how effective this teaching method is...
Learn this Software - See below for FREE TUTORIALS
BUNDLE COURSE:
We also have the
MCSA: SQL Server 2012 Bundle Tutorial
Including this 70-462 course, the 70-461 and 70-463


Each Course on 1 or 2 CDs or Download
For Mac and PC


FREE Shipping on ALL Orders
Microsoft SQL Server 2012 Tutorial - Certification Exam 70-462
Tutor: Denny Cherry
Duration: 11.75 hrs / 109 video lessons
This course is currently on offer:
20% OFF & FREE Shipping!
UK Price: £79.95 £63.95 + VAT

EU Price: €84.95 €67.95 + VAT

US & Canada: $124.95 $99.94
Product Code: 01839
DELIVERY DETAILS:
Downloads: Training downloadable when payment processed (by next working day)
CDs: Please allow 2-3 days for UK, Europe, US & Canada.
3-5 days rest of world

IN STOCK

- All CDs Shipped Carriage FREE -
Compatibility: MS Windows 8, 7, Vista, XP, 2000, 98, NT, Mac OS X, OS 9
 

Share |


Don't take our word for it, see our CUSTOMER TESTIMONIALS
Benefits of this Software Training
  Tuition by expert tutors.
  Narrated training videos demonstrate the key tools and professional techniques helping you to work faster and smarter.
  Learning is fast as the trainers provide a beginners guide using simplistic terms and minimal jargon.
  Personal Tutoring - Step-by-step video training from your own desktop. Delivered via best selling DVD/CD training or online tuition.
  The tutor transfers knowledge to you quickly and effectively.
  All the concepts of each application are explained clearly and precisely.
  Every course works on PC and Mac.
  Alternative to a boring book or manual and expensive training courses, seminars, workshops & classes.
  You can jump to and from lessons allowing you to learn at your own pace.
  The visual and practical nature shortens the learning curve compared to standard training manuals, basic handbooks, and for dummies books.
Customer Testimonials
Associated Training CDs:
Microsoft SQL Server 2012 Certification Exam 70-463 | Microsoft SQL Server 2012 Certification Exam 70-461 | Microsoft Windows Server 2012 Exam 70-412 | MongoDB Database | Microsoft Excel Tutorials | Complete Range of Microsoft Video Tutorials | Complete Range of Microsoft SQL Server Tutorials | Microsoft C# 2008 | Microsoft Visual Basic 2008 | Microsoft Visual Studio 2008
 
CD CONTENTS & FREE VIDEO TUTORIALS
Click on any linked lesson below for a FREE demo
Purchased CD tutorials have a higher sound & video quality.

FREE Sample Videos from this Course

What Is Exam 70-462?
About The Tutor
What You Should Expect From The Videos
Growing And Shrinking Databases
Testing Database Connectivity
Migrating Logins
Adding New Filegroups
DBCC CHECKDB
Memory Settings
ERRORLOG Management
Using Performance Monitor - Lesson 1
Using Data Collector
Restoring Full Backups
Testing Backups
BCP
Creating Database Users
Managing Certificates
Configure AlwaysOn Availability Groups - Lesson 1

We hope you enjoyed the FREE lessons. To view the complete contents, including ALL the lessons below & above, please purchase the course via CD or Download


Introduction
What Is Exam 70-462?
What You Should Expect From The Videos

Installation And Configuration
Growing And Shrinking Databases
Monitoring Database Growth
Designing Database Storage
Configure An SQL Server Standby Server - Lesson 1
Configure An SQL Server Standby Server - Lesson 2
Changing Service Accounts
Testing Database Connectivity
Installing SQL Server Database Engine - Lesson 1
Installing SQL Server Database Engine - Lesson 2
Installing SQL Server Database Engine - Lesson 3
Installing SQL Server Database Engine - Lesson 4
Installing SQL Server Integration Services
Enabling And Disabling Features
Moving Databases Via Detach/Attach
Migrating Logins
Creating A Full Text Index
Configuring FILESTREAM
Configuring FILETABLE
Create And Manage SQL Agent Jobs - Lesson 1
Create And Manage SQL Agent Jobs - Lesson 2
Setup Multi-Server Jobs

Maintain Instances And Databases
Using Multiple Files And Filegroups
Recovery Models
Adding New Filegroups
Moving Tables Between Filegroups
Enabling Contained Databases
Data Compression
Configuring TDE
Setting Up Table Partitioning - Lesson 1
Setting Up Table Partitioning - Lesson 2
Managing Log File Growth - Lesson 1
Managing Log File Growth - Lesson 2
DBCC CHECKDB
Installing Default And Named Instances - Lesson 1
Installing Default And Named Instances - Lesson 2
CPU Affinity
Instance Level Settings - Lesson 1
Instance Level Settings - Lesson 2
Instance Level Settings - Lesson 3
Memory Settings
Database Mail
Fillfactor
Installing A Clustered Instance - Lesson 1
Installing A Clustered Instance - Lesson 2
Installing A Clustered Instance - Lesson 3
Installing A Clustered Instance - Lesson 4
Multi-Instance Clustering
Multi-Subnet Clustering
Recover From A Failed Cluster Node

Optimization And Troubleshooting
Replication For Reporting - Lesson 1
Replication For Reporting - Lesson 2
Replication For Reporting - Lesson 3
Replication For Reporting - Lesson 4
Diagnosing Locking And Blocking - Lesson 1
Diagnosing Locking And Blocking - Lesson 2
Diagnosing Wait Stats
Using SQL Profiler
Using Performance Monitor - Lesson 1
Using Performance Monitor - Lesson 2
Using Extended Events
Using SQL Server Auditing
Using Data Collector
Using Policy Based Management

Manage Data
Define Recovery Models
Mirrored Backups
Stripped Backups
Restoring Full Backups
Restoring Differential Backups
Restoring Transaction Log Backups
File Group Restores
Testing Backups
Restoring Master Database
Restoring msdb Database
Restoring model Database
Restoring Databases Protected By TDE
Restoring A Single Database Page
Point In Time Restores
Index Maintenance
Identifying Index Fragmentation
Identifying Unused Indexes
Filtered Indexes
Updating Statistics
Full Text Indexes
Column Store Indexes
Import Export Wizard
BCP
Bulk Insert

Implement Security
Logins VsUsers
Creating Logins
Fixed Server Roles
User Defined Server Roles
Certificate Logins
Instance Level Permissions
Database Level Permissions
Fixed Database Roles
User Defined Database Roles
Application Roles
Creating Database Users
Managing Certificates
Endpoint Security

Implement High Availability
Configure Database Mirroring
Configure AlwaysOn Availability Groups - Lesson 1
Configure AlwaysOn Availability Groups - Lesson 2
Failing Over Database Mirroring
Failing Over AlwaysOn Availability Groups
Monitoring Database Mirroring

Conclusion
About The Tutor
Thank You