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 Overview00:47
      • 0.2 Table of Contents00:43
      • 0.3 Objectives00:26
      • 0.4 Course Overview00:46
      • 0.5 Course Overview (contd.)00:55
      • 0.6 Value of Administering SQL Server 2012 for Professionals00:47
      • 0.7 Value of Administering SQL Server 2012 for Organizations00:38
      • 0.8 Lessons Covered00:11
      • 0.9 Exam Pattern00:24
      • 0.10 Administering SQL Server 2012 Certification00:14
      • 0.11 Sources of Information00:14
      • 0.12 Conclusion00:14
    • Lesson 01 - SQL Server Tools and Installation 35:18
      • 1.1 SQL Server Tools and Installation00:22
      • 1.2 Objectives00:38
      • 1.3 SQL Server 2012 Components and Their Uses00:09
      • 1.4 SQL Server 2012 Components02:33
      • 1.5 Database Engine00:50
      • 1.6 Integration Services00:54
      • 1.7 Reporting Services01:12
      • 1.8 Analysis Services00:38
      • 1.9 Planning SQL Server Installation00:21
      • 1.10 Installation Requirements02:45
      • 1.11 32-Bit vs. 64-Bit Architecture02:14
      • 1.12 Scaling01:04
      • 1.13 Planning Storage03:09
      • 1.14 SQL Server Instances01:45
      • 1.15 Installing SQL Server 201200:15
      • 1.16 Steps to Install SQL Server 201202:41
      • 1.17 Steps to Install SQL Server 2012 (contd.)01:28
      • 1.18 Security Considerations01:54
      • 1.19 Installing SQL Server 201200:12
      • 1.20 Installing SQL Server 2012 Demo 0107:11
      • 1.21 Exploring the Installed Components00:06
      • 1.22 Exploring the Installed Components Demo201:32
      • 1.23 Quiz
      • 1.24 Summary00:42
      • 1.25 Summary (contd.) 00:42
      • 1.26 Conclusion00:01
    • Lesson 02 - Managing the Database Server 26:40
      • 2.1 Managing the Database Server00:26
      • 2.2 Objectives00:24
      • 2.3 Server Properties and sp configure00:12
      • 2.4 Server Properties00:55
      • 2.5 Using sp configure01:04
      • 2.6 RECONFIGURE Command01:26
      • 2.7 Viewing Server Properties and Using sp configure00:12
      • 2.8 Viewing Server Properties and Using sp configure Demo 0102:15
      • 2.9 Advanced Options00:50
      • 2.10 Default Values of sp configure00:45
      • 2.11 Enabling Advanced Options, and Viewing and Modifying Them00:06
      • 2.12 Enabling Advanced Options, and Viewing and Modifying Them Demo 0201:40
      • 2.13 CPU and Memory Architectures00:10
      • 2.14 Constraints in Processor Switching02:07
      • 2.15 Affinity Masks in SQL Server01:12
      • 2.16 Calculating CPU Affinity00:58
      • 2.17 SQL Server 2012 Enhancements00:54
      • 2.18 Memory Properties01:29
      • 2.19 Working with CPU Affinity and Memory Configurations00:08
      • 2.20 Working with CPU Affinity and Memory Configurations Demo 0303:06
      • 2.21 Configuring Database Mail00:09
      • 2.22 Database Mail00:45
      • 2.23 Setting up Database Mail01:13
      • 2.24 Sending a Mail00:42
      • 2.25 Set up Database Mail00:05
      • 2.26 Set up Database Mail Demo 0402:36
      • 2.27 Quiz
      • 2.28 Summary00:42
      • 2.29 Conclusion00:09
    • Lesson 03 - Managing Databases 34:10
      • 3.1 Managing Databases00:20
      • 3.2 Objectives00:30
      • 3.3 Understanding Databases00:10
      • 3.4 Database Structure01:48
      • 3.5 Types of Databases00:52
      • 3.6 Contained Databases02:22
      • 3.7 Creating User and Contained Databases00:09
      • 3.8 Creating User and Contained Databases Demo 0102:36
      • 3.9 System Databases00:10
      • 3.10 System Database01:24
      • 3.11 Master Database00:49
      • 3.12 Model Database01:01
      • 3.13 TempDB Database01:08
      • 3.14 MSDB Database00:59
      • 3.15 Database Options00:10
      • 3.16 Auto Close01:43
      • 3.17 Auto Shrink01:06
      • 3.18 File Space01:01
      • 3.19 Moving between Filegroups01:19
      • 3.20 Looking at Auto Close and Auto Shrink, and Checking Disk Space of a Database00:07
      • 3.21 Looking at Auto Close and Auto Shrink, and Checking Disk Space of a Database Demo 0202:44
      • 3.22 Moving between File Groups00:07
      • 3.23 Moving between File Groups Demo 0305:02
      • 3.24 Recovery Models00:10
      • 3.25 Recovery Models00:46
      • 3.26 Simple01:47
      • 3.27 Full01:13
      • 3.28 Bulk Logged01:07
      • 3.29 Changing Recovery Model00:05
      • 3.30 Changing Recovery Model Demo 0400:24
      • 3.31 Quiz
      • 3.32 Summary00:53
      • 3.33 Conclusion00:08
    • Lesson 04 - SQL Server Security 35:40
      • 4.1 SQL Server Security00:20
      • 4.2 Objectives00:23
      • 4.3 Security Model and Types of Accounts in SQL Server00:08
      • 4.4 Security Layers01:15
      • 4.5 Windows Accounts01:44
      • 4.6 SQL Server Accounts02:26
      • 4.7 Login Accounts01:07
      • 4.8 Using Accounts in SQL Server00:14
      • 4.9 Using Accounts in SQL Server Demo 0104:55
      • 4.10 Server Roles00:07
      • 4.11 Rights00:51
      • 4.12 Server Roles01:29
      • 4.13 Fixed Server Roles03:02
      • 4.14 Custom Server Roles01:30
      • 4.15 Managing Server Roles00:12
      • 4.16 Managing Server Roles Demo 0202:24
      • 4.17 Managing Permissions00:12
      • 4.18 GRANT01:01
      • 4.19 WITH GRANT01:06
      • 4.20 DENY00:54
      • 4.21 Using GRANT and DENY00:11
      • 4.22 Using GRANT and DENY Demo 0303:08
      • 4.23 Database Roles and Permissions00:15
      • 4.24 Database Roles00:23
      • 4.25 Fixed Database Roles01:42
      • 4.26 Custom Database Roles00:25
      • 4.27 Using Database Roles00:06
      • 4.28 Using Database Roles Demo 0403:19
      • 4.29 Quiz
      • 4.30 Summary00:42
      • 4.31 Conclusion00:09
    • Lesson 05 - Advanced Security in SQL Server 42:52
      • 5.1 Advanced Security in SQL Server00:19
      • 5.2 Objectives00:22
      • 5.3 Working with Digital Certificates00:12
      • 5.4 Digital Certificates02:18
      • 5.5 Private and Public Keys02:28
      • 5.6 Keys in SQL Server01:08
      • 5.7 Certificate Based Logins00:37
      • 5.8 Certificate Based Logins (contd.)00:38
      • 5.9 Creating Certificate Based Logins00:08
      • 5.10 Creating Certificate Based Logins Demo 0104:14
      • 5.11 Auditing and Policies00:07
      • 5.12 SQL Server Auditing01:33
      • 5.13 Audit Specifications01:14
      • 5.14 Audit Reports01:02
      • 5.15 Creating and Viewing Audits00:14
      • 5.16 Creating and Viewing Audits Demo 205:35
      • 5.17 Policy Based Management00:15
      • 5.18 Policy00:55
      • 5.19 Advantages of Policy01:03
      • 5.20 Components of Policy00:58
      • 5.21 Setting up Policy Based Management00:08
      • 5.22 Setting up Policy Based Management Demo 305:24
      • 5.23 Encryption and Compression00:13
      • 5.24 Encryption in SQL Server00:26
      • 5.25 Transparent Data Encryption01:30
      • 5.26 Column Level Encryption01:09
      • 5.27 Compression00:49
      • 5.28 Using TDE and Compression00:09
      • 5.29 Using TDE and Compression Demo 406:58
      • 5.30 Quiz
      • 5.31 Summary00:36
      • 5.32 Conclusion00:10
    • Lesson 06 - Working with Indexes and Files 39:43
      • 6.1 Working with Indexes and Files00:21
      • 6.2 Objectives00:20
      • 6.3 Understanding Indexes00:15
      • 6.4 Indexes03:14
      • 6.5 Index Types01:48
      • 6.6 Other Index Types01:04
      • 6.7 Adding an Index to a Table00:06
      • 6.8 Adding an Index to a Table Demo 0101:47
      • 6.9 Introduction to Full Text Indexing00:12
      • 6.10 Need for Full Text Indexing01:28
      • 6.11 Full Text Indexing02:58
      • 6.12 Full Text Search04:17
      • 6.13 Setting up FTI and Querying Using FTS00:08
      • 6.14 Setting up FTI and Querying Using FTS Demo 0204:18
      • 6.15 New Index Types in SQL Server 201200:11
      • 6.16 Column Store Index02:01
      • 6.17 FILESTREAM00:56
      • 6.18 FILETABLE00:59
      • 6.19 Using a Column Store Index00:05
      • 6.20 Using a Column Store Index Demo 0301:44
      • 6.21 Setting up New iFilters for FTI00:08
      • 6.22 Setting up New iFilters for FTI Demo 0402:20
      • 6.23 Setting up a New FILETABLE00:08
      • 6.24 Setting up a New FILETABLE Demo 0507:52
      • 6.25 Quiz
      • 6.26 Summary00:52
      • 6.27 Conclusion00:11
    • Lesson 07 - Maintaining Reliability of SQL Server Installations 25:53
      • 7.1 Maintaining Reliability of SQL Server Installations00:25
      • 7.2 Objectives00:20
      • 7.3 Detaching and Attaching Databases00:09
      • 7.4 Detaching a Database01:53
      • 7.5 Attaching a Database00:46
      • 7.6 Detach and Attach a Database00:06
      • 7.7 Detach and Attach a Database Demo 0101:29
      • 7.8 Database Backup and Restoration00:13
      • 7.9 Backups02:31
      • 7.10 Backup Strategies01:20
      • 7.11 Restore00:41
      • 7.12 Scheduling Backups00:45
      • 7.13 Backup, Restore, and Scheduling of Backup00:09
      • 7.14 Backup, Restore, and Scheduling of Backup Demo 0202:26
      • 7.15 High Availability00:10
      • 7.16 What Is High Availability00:54
      • 7.17 Clustering02:07
      • 7.18 Replication02:15
      • 7.19 Mirroring00:40
      • 7.20 AlwaysOn00:48
      • 7.21 Set up an SQL Server Cluster00:05
      • 7.22 Set up an SQL Server Cluster Demo 0304:49
      • 7.23 Quiz
      • 7.24 Summary00:42
      • 7.25 Conclusion00:10
    • Lesson 08 - Optimizing Servers 20:02
      • 8.1 Optimizing Servers00:20
      • 8.2 Objectives00:18
      • 8.3 Benchmarking Server Performance00:09
      • 8.4 System Benchmarks01:01
      • 8.5 Resource Governor00:56
      • 8.6 PerfMon01:01
      • 8.7 Using Resource Governor and PerfMon00:09
      • 8.8 Using Resource Governor and PerfMon Demo 0104:16
      • 8.9 DMVs and SQL Profiler00:09
      • 8.10 Dynamic Management View (DMV)01:11
      • 8.11 SQL Profiler01:17
      • 8.12 Using DMVs00:07
      • 8.13 Using DMVs Demo 0202:58
      • 8.14 Using SQL Profiler00:07
      • 8.15 Using SQL Profiler Demo 0300:07
      • 8.16 Optimizing Indexes00:10
      • 8.17 Index Statistics00:57
      • 8.18 Fragmentation of Indexes01:09
      • 8.19 View Index Statistics00:05
      • 8.20 View Index Statistics Demo 0402:19
      • 8.21 View and Rebuild Index to Reduce Fragmentation00:05
      • 8.22 View and Rebuild Index to Reduce Fragmentation Demo 0500:27
      • 8.23 Quiz
      • 8.24 Summary00:35
      • 8.25 Conclusion00:09
    • Lesson 09 - Troubleshooting Errors in SQL Server 21:02
      • 9.1 Troubleshooting Errors in SQL Server00:22
      • 9.2 Objectives00:20
      • 9.3 SQL Server Errors and Handling Issues00:07
      • 9.4 SQL Server Errors00:50
      • 9.5 Database Console Commands00:53
      • 9.6 DBCC Error Handling00:57
      • 9.7 Using DBCC00:11
      • 9.8 Using DBCC Demo 0101:57
      • 9.9 Traces00:07
      • 9.10 Trace Flags02:01
      • 9.11 Using Trace Flags00:05
      • 9.12 Using Trace Flags Demo 0202:03
      • 9.13 Extended Events00:08
      • 9.14 What Are Extended Events00:25
      • 9.15 Use XEvents00:06
      • 9.16 Use XEvents Demo 0302:46
      • 9.17 Database Recovery00:07
      • 9.18 Database Failure01:12
      • 9.19 Recovering a Database without a Backup00:08
      • 9.20 Recovering a Database without a Backup Demo 0405:33
      • 9.21 Quiz
      • 9.22 Summary00:34
      • 9.23 Conclusion00:10
    • Lesson 10 - Advanced Server Management 36:44
      • 10.1 Advanced Server Management00:20
      • 10.2 Objectives00:19
      • 10.3 Virtualization and SQL Server00:07
      • 10.4 What Is Virtualization02:15
      • 10.5 SQL Server and Virtualization01:20
      • 10.6 Running SQL Server in a Virtual Environment00:09
      • 10.7 Running SQL Server in a Virtual Environment Demo 0101:40
      • 10.8 Updating SQL Server00:07
      • 10.9 Updates Management02:12
      • 10.10 Patch Deployment02:06
      • 10.11 Updating SQL Server 201200:06
      • 10.12 Updating SQL Server 2012 Demo 0206:07
      • 10.13 Data Tier Applications00:12
      • 10.14 Client Application Connections01:58
      • 10.15 Data Tier Applications01:58
      • 10.16 Deployment Process02:09
      • 10.17 Deploy Structure to Different Databases Using DTA00:08
      • 10.18 Deploy Structure to Different Databases Using DTA Demo 0304:51
      • 10.19 Sync Changes Made to Main Database Using DTA00:08
      • 10.20 Sync Changes Made to Main Database Using DTA Demo 0403:33
      • 10.21 Export Data and Structure to a New Server Using DTA00:10
      • 10.22 Export Data and Structure to a New Server Using DTA Demo 0503:52
      • 10.23 Quiz
      • 10.24 Summary00:51
      • 10.25 Conclusion00: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.

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