Scroll to top button

Microsoft SQL Server 2012 Administration (70-461,70-462, & 70-463)

ISBN : 9781616912123

Prepare for the Microsoft MCSE/MCSA SQL Server 2012 certification exam with the Microsoft SQL Server 2012 Administration (70-461,70-462, & 70-463) course. The course completely covers SQL Server 2012 70-461, 70-462, and 70-463 exam objectives and will help you master the skills required to manage, and troubleshoot network protocols and services; and configure, manage, and troubleshoot security.

The Microsoft MCSA/MCSE SQL Server 2012 certification is an industry-recognized credential that validates candidates' skills in implementing, managing, monitoring, and troubleshooting hardware devices and drivers; monitoring and optimizing system performance and reliability; and configuring and troubleshooting the desktop environment.

Lessons
Lessons
30+
Exercises
653+
Quizzes
317+
Flashcards
335+
Glossary of terms
189+
TestPrep
Pre Assessment Questions
14+
Full Length Tests
9+
Post Assessment Questions
69+

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
93+
Hours
02:30+
Exam related FAQs
What is the exam registration fee? USD 165
Where do I take the exam? Certiport
What are the pre-requisites of the exam? All MCSA certifications are a prerequisite to the MCSE certifications.
How many questions are asked in the exam? The exam contains 40-60 questions.
What is the exam's retake policy?

In the event that you fail your first attempt at passing the sql-2012 examination, Microsoft's retake policy is:

  • If a candidate fails in first attempt, he need to wait for 24 hours to retake the exam.
  • If he fails in second, third, and subsequent attempts, he need to wait for 14 days before re-scheduling the exam.
  • If you have already passed the exam, it cannot be taken again.
Where can I find more information about this exam? To know more about the SQL-Server-2012, click here.
Which certification covers this exam?
What are the career opportunities after passing this exam?
  • Systems Analyst
  • Systems Engineer
  • Desktop Technician
  • Help Desk Technician
  • Systems Administrator
  • Technical Support Engineer
  • What Is Information Technology?
  • Introduction to Databases
  • Database Servers and Applications
  • SQL Server's Role
  • Summary
  • Lesson 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
  • Lesson 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
  • Lesson Essentials
  • Introducing the Command Prompt
  • General Commands
  • Batch Files
  • Mastering SQLCMD
  • Introducing Windows PowerShell
  • Using SQL Server PowerShell Extensions
  • Summary
  • Lesson Essentials
  • Understanding the SQL Language
  • SQL Statement Types
  • SQL Syntactical Elements
  • Coding Recommendations
  • Using SELECT Statements
  • Advanced Query Techniques
  • Using DDL Statements
  • Using DCL Statements
  • Modifying Data
  • Tuning and Optimizing Queries
  • Summary
  • Lesson Essentials
  • Relational Database Theory
  • Database Design Processes
  • Project Management for the DBA
  • Summary
  • Lesson Essentials
  • Planning a Database
  • Understanding Entity Relationship Diagramming
  • Building an ERD
  • Capacity Planning
  • Summary
  • Lesson Essentials
  • Designing for Normalization
  • Designing for Performance
  • Designing for Availability
  • Designing for Security
  • Summary
  • Lesson 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
  • Lesson Essentials
  • Data Types
  • Collations
  • Table Creation Process
  • Data Partitioning
  • Summary
  • Lesson Essentials
  • Understanding Indexes
  • Creating Basic Indexes
  • Creating Advanced Indexes
  • Managing Indexes
  • Understanding Views
  • Creating Views
  • Summary
  • Lesson Essentials
  • Triggers Defined
  • Using Triggers
  • Creating Triggers
  • Understanding Stored Procedures
  • Creating Stored Procedures
  • Summary
  • Lesson 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
  • Lesson 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
  • Lesson Essentials
  • Performance Tuning Principles
  • Performance and Troubleshooting Tools
  • 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
  • Lesson Essentials
  • Policy-Based Management
  • Centralized Server Management
  • Standardizing with PBM and CMS
  • Summary
  • Lesson Essentials
  • Backing Up a Database
  • Backing Up System Databases
  • Restoring a Database
  • Backing Up the Environment
  • Summary
  • Lesson Essentials
  • Security Defined
  • Security Threats
  • Security Principles
  • Summary
  • Lesson Essentials
  • Understanding Authentication
  • SQL Server Authentication Methods
  • Logins, Users, and Roles
  • Understanding Encryption
  • Summary
  • Lesson Essentials
  • Establishing Baselines
  • Implementing Least Privilege
  • Auditing SQL Server Activity
  • Configuring the Surface Area
  • Understanding Common Criteria and C2
  • Summary
  • Lesson Essentials
  • Introducing AlwaysOn Technology
  • Mirroring and AlwaysOn
  • Failover Solutions
  • Selecting Hardware for AlwaysOn
  • Summary
  • Lesson 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
  • Lesson Essentials
  • RAID-based Data Redundancy
  • Using Database Mirroring
  • Understanding Log Shipping
  • Implementing Database Snapshots
  • Summary
  • Lesson Essentials
  • SQL Server Replication
  • Importing and Exporting Data
  • Summary
  • Lesson Essentials
  • Understanding Data Warehouses
  • Implementing Fact Tables
  • Implementing Dimensions
  • Summary
  • Chapter Essentials
  • Integration Issues
  • Installing SSIS
  • Configuring SSIS Security Settings
  • Deploying Packages
  • SSIS Auditing and Event Handling
  • Extracting, Transforming, and Loading Data
  • Summary
  • Lesson Essentials
  • Understanding Data Quality Concerns
  • Installing Data Quality Services
  • Using Master Data Services
  • Cleaning Data
  • Summary
  • Chapter Essentials
  • Certification Objectives Map
  • Certification Objectives Map
  • Certification Objectives Map
×