70-462 : Administering Microsoft SQL Server 2012 Databases (Course & Lab)

70-462-complete
70-462-complete
Administering Microsoft SQL Server 2012 Databases (Course & Lab)
ISBN : 978-1-61691-534-6
Gain hands-on expertise in Microsoft SQL Server certification exam with 70-462: Administering Microsoft SQL Server 2012 Databases course and performance-based labs. Performance-based labs simulate real-world, hardware, software & command line interface environments and can be mapped to any text-book, course & training. The course and labs focus on objectives of the 70-462 exam and provide competence across a spectrum of skills including SQL server command-line administration; indexes and views; performance monitoring and tuning; authentication and encryption; and many more.

Here's what you will get

The Microsoft MCSA/MCSE SQL Server 2012 certification is an industry-recognized credential. The certification 70-462 certification exam measures your skills in the areas such as installation and configuration; maintaining instances and databases; optimization and troubleshooting; managing data; implementing security; implementing high availability.

Lessons
Lessons
20+
Exercises
459+
Quizzes
147+
Flashcards
188+
Glossary of terms
55+
TestPrep
Pre-assessment Questions
20+
Full Length Tests
8+
Post-Assessment Questions
52+
Lab
Performance based lab
80+
Video tutorials
88+
Hours
01:18+
Live Lab
live lab
18+
Video tutorials
88+
Hours
01:18+

Videos and How To..

uCertify course includes videos to help understand concepts. It also includes How Tos that help learners with how to accomplish certain tasks.

Video Lessons
Videos
82+
Hours
02+
Exam FAQs
What is the exam registration fee? USD 165
Where do I take the exam? Pearson VUE
How many questions are asked in the exam? The exam contains 40-60 questions.
What is the duration of the exam? 120 minutes
What is the passing score? 700
What is the exam's retake policy?

Here are the retake policies:

  • If a candidate achieves a passing score on an exam, the candidate cannot take the exam again.
  • If a candidate does not achieve a passing score on an exam the first time, the candidate must wait at least 24 hours before resitting the exam.
  • If a candidate does not achieve a passing score the second time, the candidate must wait at least 14 days before retaking the exam for the third time. Same applies with fourth and fifth exam retakes.
  • A candidate may not take a given exam any more than five times per 12 months. This 12-month period starts the day of the fifth unsuccessful exam retake. To take a given exam more than five times per year, a candidate must submit a request and obtain prior permission from Microsoft.
Where can I find more information about this exam? To know more about the 70-462-complete, click here.
Which certification covers this exam?

Here's what you will learn

  • What Is Information Technology?
  • Introduction to Databases
  • Database Servers and Applications
  • SQL Server's Role
  • Summary
  • Chapter Essentials
  • Installation Planning
  • Installing a Default Instance
  • Installing Named Instances
  • Installing to a Cluster
  • Installing Extra Features
  • Upgrading from Previous Versions
  • Validating an Installation
  • Removing an Installation
  • Summary
  • Chapter Essentials
  • SQL Server Configuration Manager
  • SQL Server Management Studio
  • SQL Server Data Tools
  • SQL Server Profiler
  • Books Online
  • Windows Server Administration for the DBA
  • Summary
  • Chapter Essentials
  • Introducing the Command Prompt
  • General Commands
  • Batch Files
  • Mastering SQLCMD
  • Introducing Windows PowerShell
  • Using SQL Server PowerShell Extensions
  • Summary
  • Chapter Essentials
  • SQL Server Databases
  • Database Storage
  • Database Options and Properties
  • Creating Databases in the GUI
  • Creating Databases with T-SQL
  • Creating Databases with PowerShell
  • Attaching and Detaching Databases
  • Database Snapshots
  • Summary
  • Chapter Essentials
  • Understanding Indexes
  • Creating Basic Indexes
  • Creating Advanced Indexes
  • Managing Indexes
  • Understanding Views
  • Creating Views
  • Summary
  • Chapter Essentials
  • Understanding and Installing Analysis Services
  • Understanding Integration Services
  • Understanding and Installing Reporting Services
  • Implementing Database Mail
  • Configuring Full-Text Indexing
  • Implementing Transparent Data Encryption
  • Data Compression
  • Summary
  • Chapter Essentials
  • Standardize, Automate, and Update
  • Understanding SQL Server Jobs
  • Creating T-SQL Jobs
  • Creating SSIS Jobs
  • Creating Windows Command Jobs
  • Creating and Using Operators
  • Creating and Using Alerts
  • Using WSUS for SQL Server 2012
  • Summary
  • Chapter Essentials
  • Performance Tuning Principles
  • Performance and Troubleshooting Tools
  • Audit SQL Server instances
  • Blocks, Locks, and Deadlocks
  • SQL Server Profiler
  • Database Engine Tuning Advisor
  • Performance Monitoring with System Monitor
  • Using the Resource Governor
  • Performance Studio
  • Advanced Monitoring Tools
  • Summary
  • Chapter Essentials
  • Policy-Based Management
  • Centralized Server Management
  • Standardizing with PBM and CMS
  • Summary
  • Chapter Essentials
  • Backing Up a Database
  • Backing Up System Databases
  • Restoring a Database
  • Backing Up the Environment
  • Summary
  • Chapter Essentials
  • Security Defined
  • Security Threats
  • Security Principles
  • Summary
  • Chapter Essentials
  • Understanding Authentication
  • SQL Server Authentication Methods
  • Logins, Users, and Roles
  • Understanding Encryption
  • Summary
  • Chapter Essentials
  • Establishing Baselines
  • Implementing Least Privilege
  • Auditing SQL Server Activity
  • Configuring the Surface Area
  • Understanding Common Criteria and C2
  • Summary
  • Chapter Essentials
  • Introducing AlwaysOn Technology
  • Mirroring and AlwaysOn
  • Failover Solutions
  • Selecting Hardware for AlwaysOn
  • Summary
  • Chapter Essentials
  • Understanding Windows Failover Clustering Service
  • Implementing a Windows Cluster
  • Installing SQL Server 2012 to a Cluster
  • Monitoring and Managing a SQL Server Cluster
  • Summary
  • Chapter Essentials
  • RAID-based Data Redundancy
  • Using Database Mirroring
  • Understanding Log Shipping
  • Implementing Database Snapshots
  • Summary
  • Chapter Essentials
  • SQL Server Replication
  • Importing and Exporting Data
  • Summary
  • Chapter Essentials
  • Integration Issues
  • Installing SSIS
  • Configuring SSIS Security Settings
  • Deploying Packages
  • SSIS Auditing and Event Handling
  • Extracting, Transforming, and Loading Data
  • Summary
  • Chapter Essentials
  • Certification Objectives Map

Hands on Activities (Labs)

  • Stopping MSSQLSERVER service
  • Configuring service properties
  • Configuring a protocols
  • Opening the Query Editor window
  • Generating an administrative task scripts
  • Creating a new query and viewing its errors
  • Viewing a predesigned database reports
  • Creating a new project and new solution
  • Creating a new project in an existing solution
  • Removing a project from a solution
  • Using the SQL Server Import and Export Wizard
  • Configuring Database Mail
  • Creating a Full-Text index
  • Creating an SSIS export package
  • Creating an SSIS job
  • Creating a Windows command job
  • Creating an operator
  • Creating a SQL Server Alert in SSMS
  • Creating a free drive space alert
  • Creating a trace file with SQL Server Profiler
  • Creating a DTA workload file with SQL Server Profiler
  • Installing System Monitor in a custom MMC
  • Viewing live performance data on Windows Server 2012 R2
  • Creating a data collector set in Windows Server 2012 R2
  • Creating an MDW
  • Setting sata collection options
  • Viewing a disk usage report
  • Launching the resource monitor directly
  • Determining read-only facet properties
  • Importing Microsoft policies
  • Creating a custom category for policies
  • Subscribing a database to a category
  • Creating the conDatabaseSize condition
  • Creating the conPasswordRules condition
  • Creating the conSurfaceArea condition
  • Creating the polDatabaseSizeScheduled policy
  • Creating the polPasswordRulesPrevent policy
  • Creating the polSurfaceAreaLog policy
  • Creating and registering a CMS
  • Creating a server group in a CMS
  • Registering a server
  • Setting the recovery model in SSMS
  • Creating a full backup of a database
  • Creating a backup device that points to a file
  • Starting the SQL Server Database Engine in single-user mode
  • Restoring a database to a specified time
  • Adding Windows Server Backup features
  • Configuring the authentication mode in SSMS
  • Creating a SQL login
  • Viewing and configuring local password policies
  • Creating a Windows login
  • Creating a database role with SSMS
  • Creating a database user
  • Creating a custom security template
  • Analyzing security with templates
  • Creating a baseline from current settings with the SCW
  • Managing permissions in SSMS
  • Enabling a SQL Server audit
  • Configuring the Surface Area using sp_configure
  • Configuring the surface area using PBM
  • Enabling the C2 audit trace
  • Identifying availability group terms
  • Implementing the AlwaysOn feature
  • Identifying failover and operational modes
  • Implementing highly available networks
  • Identifying Failover Clustering quorum modes
  • Identifying Validate a Configuration Wizard facts
  • Identifying Validate a Configuration Wizard tests
  • Installing Windows Failover Clustering
  • Implementing log shipping
  • Viewing a log shipping report
  • Creating a publication to replicate a table
  • Creating a Subscription
  • Exporting Data with the Import or Export Wizard
  • SSIS roles
  • Identifying the steps to sign a package in SSDT
  • Identify the steps of package deployment
  • Identifying log providers supported by SSIS
  • Identify the DTUTIL utility actions
  • Configuring an OLEDB/SQL connection

Hands on Activities (Live Labs)

  • Stopping MSSQLSERVER service
  • Configuring service properties
  • Configuring a protocols
  • Opening the Query Editor window
  • Generating an administrative task scripts
  • Creating a new query and viewing its errors
  • Viewing a predesigned database reports
  • Creating a new project and new solution
  • Creating a new project in an existing solution
  • Removing a project from a solution
  • Using the SQL Server Import and Export Wizard
  • Configuring Database Mail
  • Creating a Full-Text index
  • Creating an SSIS export package
  • Creating an SSIS job
  • Creating a Windows command job
  • Creating an operator
  • Creating a SQL Server Alert in SSMS
  • Creating a free drive space alert
  • Creating a trace file with SQL Server Profiler
  • Creating a DTA workload file with SQL Server Profiler
  • Installing System Monitor in a custom MMC
  • Viewing live performance data on Windows Server 2012 R2
  • Creating a data collector set in Windows Server 2012 R2
  • Creating an MDW
  • Setting sata collection options
  • Viewing a disk usage report
  • Launching the resource monitor directly
  • Determining read-only facet properties
  • Importing Microsoft policies
  • Creating a custom category for policies
  • Subscribing a database to a category
  • Creating the conDatabaseSize condition
  • Creating the conPasswordRules condition
  • Creating the conSurfaceArea condition
  • Creating the polDatabaseSizeScheduled policy
  • Creating the polPasswordRulesPrevent policy
  • Creating the polSurfaceAreaLog policy
  • Creating and registering a CMS
  • Creating a server group in a CMS
  • Registering a server
  • Setting the recovery model in SSMS
  • Creating a full backup of a database
  • Creating a backup device that points to a file
  • Starting the SQL Server Database Engine in single-user mode
  • Restoring a database to a specified time
  • Adding Windows Server Backup features
  • Configuring the authentication mode in SSMS
  • Creating a SQL login
  • Viewing and configuring local password policies
  • Creating a Windows login
  • Creating a database role with SSMS
  • Creating a database user
  • Creating a custom security template
  • Analyzing security with templates
  • Creating a baseline from current settings with the SCW
  • Managing permissions in SSMS
  • Enabling a SQL Server audit
  • Configuring the Surface Area using sp_configure
  • Configuring the surface area using PBM
  • Enabling the C2 audit trace
  • Identifying availability group terms
  • Implementing the AlwaysOn feature
  • Identifying failover and operational modes
  • Implementing highly available networks
  • Identifying Failover Clustering quorum modes
  • Identifying Validate a Configuration Wizard facts
  • Identifying Validate a Configuration Wizard tests
  • Installing Windows Failover Clustering
  • Implementing log shipping
  • Viewing a log shipping report
  • Creating a publication to replicate a table
  • Creating a Subscription
  • Exporting Data with the Import or Export Wizard
  • SSIS roles
  • Identifying the steps to sign a package in SSDT
  • Identify the steps of package deployment
  • Identifying log providers supported by SSIS
  • Identify the DTUTIL utility actions
  • Configuring an OLEDB/SQL connection