Scroll to top button

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

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 by 70-462 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 installation, maintenance, and configuration of tasks involved with SQL Server 2012. The Microsoft MCSA/MCSE SQL Server 2012 certification is an industry-recognized credential.

Here's what you will get

Lessons
20+
Exercises
459+
Quizzes
147+
Flashcards
188+
Glossary of terms
55+
Pre-assessment Questions
20+
Full Length Tests
8+
Post-Assessment Questions
52+
Performance based lab
80+
Video tutorials
88+
Hours
01:18+
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.

Videos
82+
Hours
02+

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

Copyright © 2002-2017 uCertify / All Rights Reserved.