Key features

MONEY BACK GUARANTEE

How this works :

At Simplilearn, we greatly value the trust of our patrons. Our courses were designed to deliver an effective learning experience, and have helped over half a million find their professional calling. But if you feel your course is not to your liking, we offer a 7-day money-back guarantee. Just send us a refund request within 7 days of purchase, and we will refund 100% of your payment, no questions asked!

For Self Placed Learning :

Raise refund request within 7 days of purchase of course. Money back guarantee is void if the participant has accessed more than 25% content.

  • Training for Administering SQL Server 2012 Databases Exam 70-462
  • 15 Hrs of High Quality e-Learning Content
  • Topics include SQL server security
  • Maintaining & monitoring SQL server
  • Covers troubleshooting SQL server
  • Exam Tips and Techniques

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

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

Good course, handy and easy to follow content

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.

Contact Us

+1-844-532-7688

(Toll Free)

  • Disclaimer
  • PMP, PMI, PMBOK, CAPM, PgMP, PfMP, ACP, PBA, RMP, SP, and OPM3 are registered marks of the Project Management Institute, Inc.
/index/hidden/ - Never remove this line