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 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. 70-462 covers installing and configuring server and related services; implementing security and high availability; and troubleshooting and optimizing data.

Lessons

uCertify uses content from well known publishers, instructors, and subject matter experts. They have a minimum of 15 years of experience in their fields. uCertify brings these textbooks to life. It is full of interactive activities that keeps the learner engaged. uCertify brings all available learning resources for a topic in one place so that the learner can efficiently learn without going to multiple places. Challenge questions are also embedded in the chapters so learners can attempt those while they are learning about that particular topic. This helps them grasp the concepts better because they can go over it again right away which improves learning. Learners can do Flashcards, Exercises, Quizzes and Labs related to each chapter. At the end of every lesson, uCertify courses guide the learners on the path they should follow.

uCertify platform supports 50+ different types of interactive activities, connect the idea, or try it yourself lab activities embedded throughout its course. These interactive activities keeps learners engaged and makes learning fun.

Here's What You Get

Exercises, Flashcards, Quizzes & Glossary

Each lesson comes with Exercises, Flashcards & Quizzes. There is no limit to the number of times learners can attempt these. Exercises come with detailed remediation, which ensures that learners are confident on the topic before proceeding. Flashcards help master the key concepts while Glossary defines the key terms.

Exercise Questions
478+
Quizzes
147+
Flashcards
188+
Glossary of terms
55+
Lessons
20+
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
171+
Hours
03:19+

Test Prep & Practice Questions

uCertify provides full length practice tests. These tests closely follow the exam objectives and are designed to simulate real exam conditions. Each course has a number of test sets consisting of hundreds of items to ensure that learners are prepared for the certification exam.

Here's What You Get

Pre-assessments Questions
20+
Full Length Tests
8+
Post-Assessments Questions
52+

Features

Full Remediation

Each question comes with detailed remediation explaining not only why an answer option is correct but also why the incorrect answer options are incorrect.

Unlimited Practice

Each test can be taken unlimited number of times until the learner feels they are prepared. Learner can review the test and read detailed remediation. Detailed test history is also available.

Learn, Test and Review Mode

Each test set comes with learn, test and review modes. In learn mode, learners will attempt a question and will get immediate feedback and complete remediation as they move on to the next question. In test mode, learners can take a timed test simulating the actual exam conditions. In review mode, learners can read through one item at a time without attempting it.

Labs

Online labs can be used to supplement training. uCertify labs are an inexpensive & safe way to explore and learn. uCertify labs are versatile - labs simulate real-world, hardware, software & command line interface environments and can be mapped to any text-book, course & training.

Here's What You Get

Performance based lab
80+

Hands on Activities

Understanding SQL Server's Role

Installing SQL Server 2012

Working with the Administration Tools

  • 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

SQL Server Command-Line Administration

Creating SQL Server Databases

Indexes and Views

Implementing Advanced Features

  • Configuring Database Mail
  • Creating a Full-Text index

Creating Jobs, Operators, and Alerts

  • 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

Performance Monitoring and Tuning

  • 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

Policy-Based Management

  • 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

Backup and Restoration

  • 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

Security Threats and Principles

Authentication and Encryption

  • 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

Security Best Practices

  • 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

AlwaysOn and High Availability

  • Identifying availability group terms
  • Implementing the AlwaysOn feature
  • Identifying failover and operational modes
  • Implementing highly available networks

SQL Server Failover Clustering

  • Identifying Failover Clustering quorum modes
  • Identifying Validate a Configuration Wizard facts
  • Identifying Validate a Configuration Wizard tests
  • Installing Windows Failover Clustering

Database Mirroring and Snapshots

  • Implementing log shipping
  • Viewing a log shipping report

Implementing Replication

  • Creating a publication to replicate a table
  • Creating a Subscription
  • Exporting Data with the Import or Export Wizard

SQL Server Integration Services

  • 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

Appendix A

Live Lab

Live-Lab is a real computer equipment, networked together and conveniently accessible over the internet using virtualization. A live-lab has equipments such as a computer, server, switch or router in it that a user is free to configure.

The benefits of live-labs are:

  • Exam based practical tasks
  • Real equipment, absolutely no simulations
  • Access to the latest industry technologies
  • Available anytime, anywhere on any device
  • Break and Reset functionality
  • No hardware costs

Here's What You Get

live lab
18+

Hands on Activities

Understanding SQL Server's Role

Installing SQL Server 2012

Working with the Administration Tools

  • 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

SQL Server Command-Line Administration

Creating SQL Server Databases

Indexes and Views

Implementing Advanced Features

  • Configuring Database Mail
  • Creating a Full-Text index

Creating Jobs, Operators, and Alerts

  • 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

Performance Monitoring and Tuning

  • 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

Policy-Based Management

  • 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

Backup and Restoration

  • 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

Security Threats and Principles

Authentication and Encryption

  • 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

Security Best Practices

  • 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

AlwaysOn and High Availability

  • Identifying availability group terms
  • Implementing the AlwaysOn feature
  • Identifying failover and operational modes
  • Implementing highly available networks

SQL Server Failover Clustering

  • Identifying Failover Clustering quorum modes
  • Identifying Validate a Configuration Wizard facts
  • Identifying Validate a Configuration Wizard tests
  • Installing Windows Failover Clustering

Database Mirroring and Snapshots

  • Implementing log shipping
  • Viewing a log shipping report

Implementing Replication

  • Creating a publication to replicate a table
  • Creating a Subscription
  • Exporting Data with the Import or Export Wizard

SQL Server Integration Services

  • 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

Appendix A

Exam Information

Exam FAQs
What is the format of the exam?
Multiple choice, multiple answer, and scenario based
How many questions are asked in the exam?
The exam contains 55 questions.
What is the duration of the exam?
120 minutes
What is the passing score?
700

(on a scale of 0-1000)

Table of Content

Here's What you will Learn

Lesson 1: Understanding SQL Server's Role

  • What Is Information Technology?
  • Introduction to Databases
  • Database Servers and Applications
  • SQL Server's Role
  • Summary
  • Chapter Essentials

Lesson 2: Installing SQL Server 2012

  • 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

Lesson 3: Working with the Administration Tools

  • 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

Lesson 4: SQL Server Command-Line Administration

  • Introducing the Command Prompt
  • General Commands
  • Batch Files
  • Mastering SQLCMD
  • Introducing Windows PowerShell
  • Using SQL Server PowerShell Extensions
  • Summary
  • Chapter Essentials

Lesson 5: Creating SQL Server Databases

  • 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

Lesson 6: Indexes and Views

  • Understanding Indexes
  • Creating Basic Indexes
  • Creating Advanced Indexes
  • Managing Indexes
  • Understanding Views
  • Creating Views
  • Summary
  • Chapter Essentials

Lesson 7: Implementing Advanced Features

  • 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

Lesson 8: Creating Jobs, Operators, and Alerts

  • 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

Lesson 9: Performance Monitoring and Tuning

  • 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

Lesson 10: Policy-Based Management

  • Policy-Based Management
  • Centralized Server Management
  • Standardizing with PBM and CMS
  • Summary
  • Chapter Essentials

Lesson 11: Backup and Restoration

  • Backing Up a Database
  • Backing Up System Databases
  • Restoring a Database
  • Backing Up the Environment
  • Summary
  • Chapter Essentials

Lesson 12: Security Threats and Principles

  • Security Defined
  • Security Threats
  • Security Principles
  • Summary
  • Chapter Essentials

Lesson 13: Authentication and Encryption

  • Understanding Authentication
  • SQL Server Authentication Methods
  • Logins, Users, and Roles
  • Understanding Encryption
  • Summary
  • Chapter Essentials

Lesson 14: Security Best Practices

  • Establishing Baselines
  • Implementing Least Privilege
  • Auditing SQL Server Activity
  • Configuring the Surface Area
  • Understanding Common Criteria and C2
  • Summary
  • Chapter Essentials

Lesson 15: AlwaysOn and High Availability

  • Introducing AlwaysOn Technology
  • Mirroring and AlwaysOn
  • Failover Solutions
  • Selecting Hardware for AlwaysOn
  • Summary
  • Chapter Essentials

Lesson 16: SQL Server Failover Clustering

  • 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

Lesson 17: Database Mirroring and Snapshots

  • RAID-based Data Redundancy
  • Using Database Mirroring
  • Understanding Log Shipping
  • Implementing Database Snapshots
  • Summary
  • Chapter Essentials

Lesson 18: Implementing Replication

  • SQL Server Replication
  • Importing and Exporting Data
  • Summary
  • Chapter Essentials

Lesson 19: SQL Server Integration Services

  • Integration Issues
  • Installing SSIS
  • Configuring SSIS Security Settings
  • Deploying Packages
  • SSIS Auditing and Event Handling
  • Extracting, Transforming, and Loading Data
  • Summary
  • Chapter Essentials

Lesson 20: Appendix A

  • Certification Objectives Map

Copyright © 2002-2017 uCertify / All Rights Reserved.