Course description

  • What is this course about?

    Microsoft SQL Server 2012 is the one of the latest versions of Microsoft SQL Server, the extremely popular and widely used database system in the world. Simplilearn’s Administering Microsoft SQL Server 2012 Databases course introduces you to building and using databases in this platform.

    The course provides students with the technical skills required to perform installation, maintenance, and configuration tasks in Microsoft SQL Server 2012. It also teaches them how to set up database systems, make sure the systems operate efficiently, and regularly store, back up, and secure data from unauthorized access. This course will help current and aspiring data professionals to prepare for exam 70-462, known as Administering Microsoft SQL Server 2012 Databases.

  • What learning benefits do you get from Simplilearn’s training?

    Simplilearn’s training provides you the knowledge and skills to:
    • Install and configure
    • Maintain instances and databases
    • Optimize and troubleshoot
    • Manage data
    • Implement security
    • Implement high availability
    The course will help you understand the administration of SQL Server 2012 databases. You will learn the main issues and decisions involved in SQL Server installation and configuration. You will see how backup and restore operations can be performed, and databases and database files can be moved. Instance, database, and object security strategies will also be discussed and demonstrated.

    Finally, some high availability technologies will be discussed.

    Simplilearn’s training breaks up the course material into 10 easy-to-follow modules that cover the course-level objectives. Further, demos are provided for all the major concepts covered in a lesson so that participants understand how the steps learned are implemented in real time.

  • What are the career benefits in-store for you?

    Passing the Administering Microsoft SQL Server 2012 Databases (70-462) exam is a requirement to getting MCSA certified, which in turn is a prerequisite to achieving an MCSE certification.

    In high-growth industries, entry-level employees with a Microsoft Certified Solutions Associate (MCSA) certification can annually earn up to $16,000 more than their non-certified peers.

    Better job opportunities also await them.

  • Who should do this course?

    SQL Administrators who administer and maintain SQL Server databases are best suited for this certification training. Other responsibilities include setting up database systems, making sure those systems operate efficiently, and regularly storing, backing up, and securing data from unauthorized access.

  • Why Simplilearn?

    • Simplilearn is the World’s Largest Certification Training Provider, with over 500,000+ professionals trained globally
    • Trusted by the Fortune 500 companies as their learning provider for career growth and training
    • 2000+ certified and experienced trainers conduct trainings for various courses across the globe
    • All our Courses are designed and developed under a tried and tested Unique Learning Framework that is proven to deliver 98.6% pass rate in first attempt
    • Accredited, Approved and Recognized as a training organization, partner, education provider and examination center by globally renowned names like Project Management Institute of USA, APMG, CFA Institute, GARP, ASTQB, IIBA and others

Course preview

    • Lesson 00 - Course Overview

      06:19
      • 0.1 Course Overview
        00:47
      • 0.2 Table of Contents
        00:43
      • 0.3 Objectives
        00:26
      • 0.4 Course Overview
        00:46
      • 0.5 Course Overview (contd.)
        00:55
      • 0.6 Value of Administering SQL Server 2012 for Professionals
        00:47
      • 0.7 Value of Administering SQL Server 2012 for Organizations
        00:38
      • 0.8 Lessons Covered
        00:11
      • 0.9 Exam Pattern
        00:24
      • 0.10 Administering SQL Server 2012 Certification
        00:14
      • 0.11 Sources of Information
        00:14
      • 0.12 Conclusion
        00:14
    • Lesson 01 - SQL Server Tools and Installation

      35:18
      • 1.1 SQL Server Tools and Installation
        00:22
      • 1.2 Objectives
        00:38
      • 1.3 SQL Server 2012 Components and Their Uses
        00:09
      • 1.4 SQL Server 2012 Components
        02:33
      • 1.5 Database Engine
        00:50
      • 1.6 Integration Services
        00:54
      • 1.7 Reporting Services
        01:12
      • 1.8 Analysis Services
        00:38
      • 1.9 Planning SQL Server Installation
        00:21
      • 1.10 Installation Requirements
        02:45
      • 1.11 32-Bit vs. 64-Bit Architecture
        02:14
      • 1.12 Scaling
        01:04
      • 1.13 Planning Storage
        03:09
      • 1.14 SQL Server Instances
        01:45
      • 1.15 Installing SQL Server 2012
        00:15
      • 1.16 Steps to Install SQL Server 2012
        02:41
      • 1.17 Steps to Install SQL Server 2012 (contd.)
        01:28
      • 1.18 Security Considerations
        01:54
      • 1.19 Installing SQL Server 2012
        00:12
      • 1.20 Installing SQL Server 2012 Demo 01
        07:11
      • 1.21 Exploring the Installed Components
        00:06
      • 1.22 Exploring the Installed Components Demo2
        01:32
      • 1.23 Quiz
      • 1.24 Summary
        00:42
      • 1.25 Summary (contd.)
        00:42
      • 1.26 Conclusion
        00:01
    • Lesson 02 - Managing the Database Server

      26:40
      • 2.1 Managing the Database Server
        00:26
      • 2.2 Objectives
        00:24
      • 2.3 Server Properties and sp configure
        00:12
      • 2.4 Server Properties
        00:55
      • 2.5 Using sp configure
        01:04
      • 2.6 RECONFIGURE Command
        01:26
      • 2.7 Viewing Server Properties and Using sp configure
        00:12
      • 2.8 Viewing Server Properties and Using sp configure Demo 01
        02:15
      • 2.9 Advanced Options
        00:50
      • 2.10 Default Values of sp configure
        00:45
      • 2.11 Enabling Advanced Options, and Viewing and Modifying Them
        00:06
      • 2.12 Enabling Advanced Options, and Viewing and Modifying Them Demo 02
        01:40
      • 2.13 CPU and Memory Architectures
        00:10
      • 2.14 Constraints in Processor Switching
        02:07
      • 2.15 Affinity Masks in SQL Server
        01:12
      • 2.16 Calculating CPU Affinity
        00:58
      • 2.17 SQL Server 2012 Enhancements
        00:54
      • 2.18 Memory Properties
        01:29
      • 2.19 Working with CPU Affinity and Memory Configurations
        00:08
      • 2.20 Working with CPU Affinity and Memory Configurations Demo 03
        03:06
      • 2.21 Configuring Database Mail
        00:09
      • 2.22 Database Mail
        00:45
      • 2.23 Setting up Database Mail
        01:13
      • 2.24 Sending a Mail
        00:42
      • 2.25 Set up Database Mail
        00:05
      • 2.26 Set up Database Mail Demo 04
        02:36
      • 2.27 Quiz
      • 2.28 Summary
        00:42
      • 2.29 Conclusion
        00:09
    • Lesson 03 - Managing Databases

      34:10
      • 3.1 Managing Databases
        00:20
      • 3.2 Objectives
        00:30
      • 3.3 Understanding Databases
        00:10
      • 3.4 Database Structure
        01:48
      • 3.5 Types of Databases
        00:52
      • 3.6 Contained Databases
        02:22
      • 3.7 Creating User and Contained Databases
        00:09
      • 3.8 Creating User and Contained Databases Demo 01
        02:36
      • 3.9 System Databases
        00:10
      • 3.10 System Database
        01:24
      • 3.11 Master Database
        00:49
      • 3.12 Model Database
        01:01
      • 3.13 TempDB Database
        01:08
      • 3.14 MSDB Database
        00:59
      • 3.15 Database Options
        00:10
      • 3.16 Auto Close
        01:43
      • 3.17 Auto Shrink
        01:06
      • 3.18 File Space
        01:01
      • 3.19 Moving between Filegroups
        01:19
      • 3.20 Looking at Auto Close and Auto Shrink, and Checking Disk Space of a Database
        00:07
      • 3.21 Looking at Auto Close and Auto Shrink, and Checking Disk Space of a Database Demo 02
        02:44
      • 3.22 Moving between File Groups
        00:07
      • 3.23 Moving between File Groups Demo 03
        05:02
      • 3.24 Recovery Models
        00:10
      • 3.25 Recovery Models
        00:46
      • 3.26 Simple
        01:47
      • 3.27 Full
        01:13
      • 3.28 Bulk Logged
        01:07
      • 3.29 Changing Recovery Model
        00:05
      • 3.30 Changing Recovery Model Demo 04
        00:24
      • 3.31 Quiz
      • 3.32 Summary
        00:53
      • 3.33 Conclusion
        00:08
    • Lesson 04 - SQL Server Security

      35:40
      • 4.1 SQL Server Security
        00:20
      • 4.2 Objectives
        00:23
      • 4.3 Security Model and Types of Accounts in SQL Server
        00:08
      • 4.4 Security Layers
        01:15
      • 4.5 Windows Accounts
        01:44
      • 4.6 SQL Server Accounts
        02:26
      • 4.7 Login Accounts
        01:07
      • 4.8 Using Accounts in SQL Server
        00:14
      • 4.9 Using Accounts in SQL Server Demo 01
        04:55
      • 4.10 Server Roles
        00:07
      • 4.11 Rights
        00:51
      • 4.12 Server Roles
        01:29
      • 4.13 Fixed Server Roles
        03:02
      • 4.14 Custom Server Roles
        01:30
      • 4.15 Managing Server Roles
        00:12
      • 4.16 Managing Server Roles Demo 02
        02:24
      • 4.17 Managing Permissions
        00:12
      • 4.18 GRANT
        01:01
      • 4.19 WITH GRANT
        01:06
      • 4.20 DENY
        00:54
      • 4.21 Using GRANT and DENY
        00:11
      • 4.22 Using GRANT and DENY Demo 03
        03:08
      • 4.23 Database Roles and Permissions
        00:15
      • 4.24 Database Roles
        00:23
      • 4.25 Fixed Database Roles
        01:42
      • 4.26 Custom Database Roles
        00:25
      • 4.27 Using Database Roles
        00:06
      • 4.28 Using Database Roles Demo 04
        03:19
      • 4.29 Quiz
      • 4.30 Summary
        00:42
      • 4.31 Conclusion
        00:09
    • Lesson 05 - Advanced Security in SQL Server

      42:52
      • 5.1 Advanced Security in SQL Server
        00:19
      • 5.2 Objectives
        00:22
      • 5.3 Working with Digital Certificates
        00:12
      • 5.4 Digital Certificates
        02:18
      • 5.5 Private and Public Keys
        02:28
      • 5.6 Keys in SQL Server
        01:08
      • 5.7 Certificate Based Logins
        00:37
      • 5.8 Certificate Based Logins (contd.)
        00:38
      • 5.9 Creating Certificate Based Logins
        00:08
      • 5.10 Creating Certificate Based Logins Demo 01
        04:14
      • 5.11 Auditing and Policies
        00:07
      • 5.12 SQL Server Auditing
        01:33
      • 5.13 Audit Specifications
        01:14
      • 5.14 Audit Reports
        01:02
      • 5.15 Creating and Viewing Audits
        00:14
      • 5.16 Creating and Viewing Audits Demo 2
        05:35
      • 5.17 Policy Based Management
        00:15
      • 5.18 Policy
        00:55
      • 5.19 Advantages of Policy
        01:03
      • 5.20 Components of Policy
        00:58
      • 5.21 Setting up Policy Based Management
        00:08
      • 5.22 Setting up Policy Based Management Demo 3
        05:24
      • 5.23 Encryption and Compression
        00:13
      • 5.24 Encryption in SQL Server
        00:26
      • 5.25 Transparent Data Encryption
        01:30
      • 5.26 Column Level Encryption
        01:09
      • 5.27 Compression
        00:49
      • 5.28 Using TDE and Compression
        00:09
      • 5.29 Using TDE and Compression Demo 4
        06:58
      • 5.30 Quiz
      • 5.31 Summary
        00:36
      • 5.32 Conclusion
        00:10
    • Lesson 06 - Working with Indexes and Files

      39:43
      • 6.1 Working with Indexes and Files
        00:21
      • 6.2 Objectives
        00:20
      • 6.3 Understanding Indexes
        00:15
      • 6.4 Indexes
        03:14
      • 6.5 Index Types
        01:48
      • 6.6 Other Index Types
        01:04
      • 6.7 Adding an Index to a Table
        00:06
      • 6.8 Adding an Index to a Table Demo 01
        01:47
      • 6.9 Introduction to Full Text Indexing
        00:12
      • 6.10 Need for Full Text Indexing
        01:28
      • 6.11 Full Text Indexing
        02:58
      • 6.12 Full Text Search
        04:17
      • 6.13 Setting up FTI and Querying Using FTS
        00:08
      • 6.14 Setting up FTI and Querying Using FTS Demo 02
        04:18
      • 6.15 New Index Types in SQL Server 2012
        00:11
      • 6.16 Column Store Index
        02:01
      • 6.17 FILESTREAM
        00:56
      • 6.18 FILETABLE
        00:59
      • 6.19 Using a Column Store Index
        00:05
      • 6.20 Using a Column Store Index Demo 03
        01:44
      • 6.21 Setting up New iFilters for FTI
        00:08
      • 6.22 Setting up New iFilters for FTI Demo 04
        02:20
      • 6.23 Setting up a New FILETABLE
        00:08
      • 6.24 Setting up a New FILETABLE Demo 05
        07:52
      • 6.25 Quiz
      • 6.26 Summary
        00:52
      • 6.27 Conclusion
        00:11
    • Lesson 07 - Maintaining Reliability of SQL Server Installations

      25:53
      • 7.1 Maintaining Reliability of SQL Server Installations
        00:25
      • 7.2 Objectives
        00:20
      • 7.3 Detaching and Attaching Databases
        00:09
      • 7.4 Detaching a Database
        01:53
      • 7.5 Attaching a Database
        00:46
      • 7.6 Detach and Attach a Database
        00:06
      • 7.7 Detach and Attach a Database Demo 01
        01:29
      • 7.8 Database Backup and Restoration
        00:13
      • 7.9 Backups
        02:31
      • 7.10 Backup Strategies
        01:20
      • 7.11 Restore
        00:41
      • 7.12 Scheduling Backups
        00:45
      • 7.13 Backup, Restore, and Scheduling of Backup
        00:09
      • 7.14 Backup, Restore, and Scheduling of Backup Demo 02
        02:26
      • 7.15 High Availability
        00:10
      • 7.16 What Is High Availability
        00:54
      • 7.17 Clustering
        02:07
      • 7.18 Replication
        02:15
      • 7.19 Mirroring
        00:40
      • 7.20 AlwaysOn
        00:48
      • 7.21 Set up an SQL Server Cluster
        00:05
      • 7.22 Set up an SQL Server Cluster Demo 03
        04:49
      • 7.23 Quiz
      • 7.24 Summary
        00:42
      • 7.25 Conclusion
        00:10
    • Lesson 08 - Optimizing Servers

      20:02
      • 8.1 Optimizing Servers
        00:20
      • 8.2 Objectives
        00:18
      • 8.3 Benchmarking Server Performance
        00:09
      • 8.4 System Benchmarks
        01:01
      • 8.5 Resource Governor
        00:56
      • 8.6 PerfMon
        01:01
      • 8.7 Using Resource Governor and PerfMon
        00:09
      • 8.8 Using Resource Governor and PerfMon Demo 01
        04:16
      • 8.9 DMVs and SQL Profiler
        00:09
      • 8.10 Dynamic Management View (DMV)
        01:11
      • 8.11 SQL Profiler
        01:17
      • 8.12 Using DMVs
        00:07
      • 8.13 Using DMVs Demo 02
        02:58
      • 8.14 Using SQL Profiler
        00:07
      • 8.15 Using SQL Profiler Demo 03
        00:07
      • 8.16 Optimizing Indexes
        00:10
      • 8.17 Index Statistics
        00:57
      • 8.18 Fragmentation of Indexes
        01:09
      • 8.19 View Index Statistics
        00:05
      • 8.20 View Index Statistics Demo 04
        02:19
      • 8.21 View and Rebuild Index to Reduce Fragmentation
        00:05
      • 8.22 View and Rebuild Index to Reduce Fragmentation Demo 05
        00:27
      • 8.23 Quiz
      • 8.24 Summary
        00:35
      • 8.25 Conclusion
        00:09
    • Lesson 09 - Troubleshooting Errors in SQL Server

      21:02
      • 9.1 Troubleshooting Errors in SQL Server
        00:22
      • 9.2 Objectives
        00:20
      • 9.3 SQL Server Errors and Handling Issues
        00:07
      • 9.4 SQL Server Errors
        00:50
      • 9.5 Database Console Commands
        00:53
      • 9.6 DBCC Error Handling
        00:57
      • 9.7 Using DBCC
        00:11
      • 9.8 Using DBCC Demo 01
        01:57
      • 9.9 Traces
        00:07
      • 9.10 Trace Flags
        02:01
      • 9.11 Using Trace Flags
        00:05
      • 9.12 Using Trace Flags Demo 02
        02:03
      • 9.13 Extended Events
        00:08
      • 9.14 What Are Extended Events
        00:25
      • 9.15 Use XEvents
        00:06
      • 9.16 Use XEvents Demo 03
        02:46
      • 9.17 Database Recovery
        00:07
      • 9.18 Database Failure
        01:12
      • 9.19 Recovering a Database without a Backup
        00:08
      • 9.20 Recovering a Database without a Backup Demo 04
        05:33
      • 9.21 Quiz
      • 9.22 Summary
        00:34
      • 9.23 Conclusion
        00:10
    • Lesson 10 - Advanced Server Management

      36:44
      • 10.1 Advanced Server Management
        00:20
      • 10.2 Objectives
        00:19
      • 10.3 Virtualization and SQL Server
        00:07
      • 10.4 What Is Virtualization
        02:15
      • 10.5 SQL Server and Virtualization
        01:20
      • 10.6 Running SQL Server in a Virtual Environment
        00:09
      • 10.7 Running SQL Server in a Virtual Environment Demo 01
        01:40
      • 10.8 Updating SQL Server
        00:07
      • 10.9 Updates Management
        02:12
      • 10.10 Patch Deployment
        02:06
      • 10.11 Updating SQL Server 2012
        00:06
      • 10.12 Updating SQL Server 2012 Demo 02
        06:07
      • 10.13 Data Tier Applications
        00:12
      • 10.14 Client Application Connections
        01:58
      • 10.15 Data Tier Applications
        01:58
      • 10.16 Deployment Process
        02:09
      • 10.17 Deploy Structure to Different Databases Using DTA
        00:08
      • 10.18 Deploy Structure to Different Databases Using DTA Demo 03
        04:51
      • 10.19 Sync Changes Made to Main Database Using DTA
        00:08
      • 10.20 Sync Changes Made to Main Database Using DTA Demo 04
        03:33
      • 10.21 Export Data and Structure to a New Server Using DTA
        00:10
      • 10.22 Export Data and Structure to a New Server Using DTA Demo 05
        03:52
      • 10.23 Quiz
      • 10.24 Summary
        00:51
      • 10.25 Conclusion
        00:06
    • {{childObj.title}}

      • {{childObj.childSection.chapter_name}}

        • {{lesson.title}}
      • {{lesson.title}}

    View More

    View Less

Exam & certification

  • Why is this exam popular?

    SQL Server 2012 is a powerful platform that is widely used in the enterprise and cloud. Many critical systems are based on it. Exam 70-462 is part of a series of certifications that can make you a master of this platform.

  • What are the eligibility requirements to take the 70-462 exam?

    There are no eligibility requirements to take up this course. Register at the Microsoft website and select your exam to schedule with Pearson VUE.

  • Who should take this exam?

    This exam is targeted at database professionals whose primary duties involve installation, configuration, and maintenance tasks.

Reviews

Richard Ellis
Richard Ellis

This is definitely an interesting course for getting a hang of how to administer SQL server

Mohit Singh
Mohit Singh

Good course, handy and easy to follow content

Altaf Hussain
Altaf Hussain

This course offered by Simplilearn is quite interesting and useful for everyone who is looking for developing skills on SQL server

    FAQs

    • How do I enroll for the Online training?

      You can enroll for the training online. Payments can be made using any of the following options and receipt of the same will be issued to the candidate automatically via email.
      1. Visa debit/credit card
      2. American express and Diners club card
      3. Master Card, or
      4. Through PayPal

    • What will I get along with this training?

      You will have access to the online e-learning and practice tests along with the training.

    • Can I cancel my enrollment? Do I get a refund?

      Yes, you can cancel your enrollment. We provide you complete refund after deducting the administration fee. To know more please go through our Refund Policy.

    • Do you provide any course completion certificate?

      Yes, we offer course completion certificate after you successfully complete the training program.

    • Where and how can I access the e-learning content? Are there any limitations?

      Once you register with us for a course by paying the course fee, you can have 24/7 access to the e-learning content on our website. An automated course purchase confirmation mail from our side will guide you through the process.

    • I am not able to access the online course. Whom should I contact for a solution?

      Please raise a request via our Help and Support portal to have your issue resolved.

    • Do you provide money back guarantee for the training programs?

      Yes. We do offer a money-back guarantee for many of our training programs. You can refer to the Refund Policy and raise refund requests via our Help and Support portal.

    • Do you provide any course completion certificate?

      Yes, we offer course completion certificate after you successfully complete the training program.

    • I want to know more about the training program. Whom do I contact?

      Please join our Live Chat for instant support, call us, or Request a Call Back to have your query resolved.

    • Disclaimer
    • PMP, PMI, PMBOK, CAPM, PgMP, PfMP, ACP, PBA, RMP, SP, and OPM3 are registered marks of the Project Management Institute, Inc.