Microsoft SQL Server 2012 Certification Training Exam 70-462

Name: Microsoft SQL Server 2012 Certification Training Exam 70-462
Rating: 4.7 (649 reviews)

Study For The Microsoft 70-462 Exam - Administering Microsoft SQL Server 2012 Databases

Created byInfinite Skills

Last updated 9/2013

English

What you'll learn

To Study And Pass The Microsoft 70-462 Exam and Gain Certification For MCSA or MCSE

Course content

8 sections • 109 lectures • 11h 45m total length

0101 What Is Exam 70-462?2:20
0102 What You Should Expect From The Videos3:54

0201 Growing And Shrinking Databases9:49
0202 Monitoring Database Growth7:35
0203 Designing Database Storage10:23
0204 Configure An SQL Server Standby Server - Part 113:52
0205 Configure An SQL Server Standby Server - Part 27:06
0206 Changing Service Accounts13:12
0207 Testing Database Connectivity10:08
0208 Installing SQL Server Database Engine - Part 111:37
0209 Installing SQL Server Database Engine - Part 211:35
0210 Installing SQL Server Database Engine - Part 38:52
Demonstrates a command line installation of SQL Server 2012, detailing installation parameters, features, license terms acceptance, batch file workflow, plus image prep and gold image cloning for virtual machines.
0211 Installing SQL Server Database Engine - Part 45:00
0212 Installing SQL Server Integration Services7:02
0213 Enabling And Disabling Features7:21
Enable and disable features in SQL Server 2012 using the installation center, installing or removing features on an existing instance to reduce attack surface and resource use.
0214 Moving Databases Via Detach/Attach7:46
0215 Migrating Logins6:30
0216 Creating A Full Text Index5:13
0217 Configuring FILESTREAM1:29
0218 Configuring FILETABLE1:33
0219 Create And Manage SQL Agent Jobs - Part 19:22
Learn to create and manage sql agent jobs. Use management studio or t-sql to configure steps, schedules, alerts, and step types like os commands, powershell, ssis packages, replication options.
0220 Create And Manage SQL Agent Jobs - Part 24:30
View and manage SQL Server Agent jobs using the activity monitor, job editor, and sp_help_job to track status, history, and schedules on the local server.
0221 Setup Multi-Server Jobs7:00

0301 Using Multiple Files And Filegroups7:57
0302 Recovery Models6:07
Discover the three SQL Server recovery models: snapshot, bulk logged, and full, and how they govern logging, recoverability, and point-in-time restores. Learn how to change models and perform backups.
0303 Adding New Filegroups2:24
Create file groups to isolate IO for objects and spread files across disks, using one or more files per group. Add via SSMS or T-SQL with online, no downtime operations.
0304 Moving Tables Between Filegroups6:05
0305 Enabling Contained Databases4:57
0306 Data Compression10:20
0307 Configuring TDE6:51
0308 Setting Up Table Partitioning - Part 19:15
0309 Setting Up Table Partitioning - Part 210:20
0310 Managing Log File Growth - Part 18:32
0311 Managing Log File Growth - Part 22:13
Learn how transaction log growth affects virtual log files, why smaller transactions improve performance and reduce locking, and how more frequent log backups minimize data loss.
0312 DBCC CHECKDB9:10
DBCC CHECKDB scans every page, table, and catalog to detect corruption, validates data values, and reports integrity issues, with repair options and backup restores as needed.
0313 Installing Default And Named Instances - Part 17:48
0314 Installing Default And Named Instances - Part 25:42
0315 CPU Affinity5:26
Isolate SQL Server instances to specific processors using CPU affinity via SQL Server Management Studio or T-SQL scripts, reducing workload contention and preserving CPU resources for other services.
0316 Instance Level Settings - Part 19:13
0317 Instance Level Settings - Part 29:02
0318 Instance Level Settings - Part 310:51
0319 Memory Settings5:17
0320 Database Mail8:40
Configure database mail in SQL Server 2012 using profiles and accounts to send emails from different addresses. Explore authentication options, failover, and troubleshooting with logs.
0321 Fillfactor6:44
0322 Installing A Clustered Instance - Part 17:58
0323 Installing A Clustered Instance - Part 28:38
0324 Installing A Clustered Instance - Part 39:19
Add a node to an existing SQL Server failover cluster using the streamlined wizard, ensure edition matches (evaluation), validate with rule checks, and reuse a configuration file for nodes.
0325 Installing A Clustered Instance - Part 41:48
0326 Multi-Instance Clustering3:56
Explore multi-instance clustering in SQL Server, where each instance runs on its own hostname, IP address, port, and shared disk, enabling floating resilience across cluster nodes.
0327 Multi-Subnet Clustering4:27
0328 Recover From A Failed Cluster Node4:05

0401 Replication For Reporting - Part 18:22
0402 Replication For Reporting - Part 211:54
0403 Replication For Reporting - Part 312:23
0404 Replication For Reporting - Part 47:36
0405 Diagnosing Locking And Blocking - Part 18:52
0406 Diagnosing Locking And Blocking - Part 26:14
Diagnose and resolve locking and blocking in SQL Server by identifying blocking sessions with dynamic management views, then fix root causes with indexing, query rewrites, faster storage, or more RAM.
0407 Diagnosing Wait Stats11:29
0408 Using SQL Profiler10:15
0409 Using Performance Monitor - Part 17:33
0410 Using Performance Monitor - Part 25:29
0411 Using Extended Events8:24
0412 Using SQL Server Auditing8:14
0413 Using Data Collector5:21
0414 Using Policy Based Management6:53
Discover how policy based management uses facets, conditions, and policies to enforce configuration and naming standards across SQL Server instances, with real-time or scheduled checks against targeted objects.

0501 Define Recovery Models4:04
0502 Mirrored Backups1:39
Discover how mirrored backups use a mirror to clause to create redundant copies on separate disks in parallel, enabling restoration from either backup file and protecting against disk failures.
0503 Stripped Backups2:39
0504 Restoring Full Backups4:16
0505 Restoring Differential Backups5:41
0506 Restoring Transaction Log Backups4:15
0507 File Group Restores4:11
0508 Testing Backups2:32
0509 Restoring Master Database5:23
0510 Restoring msdb Database0:48
0511 Restoring model Database0:32
0512 Restoring Databases Protected By TDE3:49
0513 Restoring A Single Database Page2:12
0514 Point In Time Restores5:33
0515 Index Maintenance10:22
0516 Identifying Index Fragmentation4:34
0517 Identifying Unused Indexes6:32
0518 Filtered Indexes3:23
0519 Updating Statistics3:38
0520 Full Text Indexes15:09
Discover how full text indexes enable natural language searches using contains, contains table, free text, and free text table predicates for text and binary data in SQL Server 2012.
0521 Column Store Indexes7:51
0522 Import Export Wizard5:54
0523 BCP8:31
Explore the bulk copy program (BCP) in SQL Server 2012, a versatile command-line tool for exporting and importing data from tables or queries, with batch processing and format file options.
0524 Bulk Insert3:35
Bulk insert imports data from text files into a table, with batch size, field terminator, and options like first row skip and tab lock.

0601 Logins Vs. Users2:57
0602 Creating Logins5:54
Learn to create logins in SQL Server 2012 using Management Studio or T-SQL, including simple and Windows logins. Understand password policy options and the login vs user distinction.
0603 Fixed Server Roles5:47
Explore the nine fixed server roles in SQL Server 2012, including bulkadmin, dbcreator, diskadmin, processadmin, public, securityadmin, serveradmin, setupadmin, and sysadmin, and learn their specific permissions and security implications.
0604 User Defined Server Roles4:11
0605 Certificate Logins2:18
Learn how certificate logins in SQL Server serve code signing, not authentication. Create a certificate in the master database, then create and map a login from that certificate.
0606 Instance Level Permissions3:15
0607 Database Level Permissions5:13
0608 Fixed Database Roles5:43
0609 User Defined Database Roles2:49
0610 Application Roles4:15
0611 Creating Database Users6:06
0612 Managing Certificates2:18
Learn to manage certificates in SQL Server by changing certificate passwords with the alter certificate statement, using old and new passwords, while meeting Windows password policy and avoiding data decryption.
0613 Endpoint Security3:35

0701 Configure Database Mirroring10:54
0702 Configure AlwaysOn Availability Groups - Part 110:33
0703 Configure AlwaysOn Availability Groups - Part 27:58
Configure always on availability groups with full data synchronization, endpoints, extended event sessions, and a listener, using the wizard to manage backups, replicas, and failover.
0704 Failing Over Database Mirroring2:37
Learn how to perform a database mirroring failover from the primary server, either via sql or the gui, and understand data loss, planning, and high safety mode of synchronous mirroring.
0705 Failing Over AlwaysOn Availability Groups7:54
0706 Monitoring Database Mirroring4:36

Requirements

A Desire To Learn

Description

This SQL Server 70-462 exam training course by Infinite Skills teaches you everything you need to know to pass the Administering Microsoft SQL Server 2012 Databases Server 2012 exam. It is required that you pass the 70-462 Exam in order to earn your MCSA and MCSE certifications from Microsoft.

The course takes you through each of the topics that you will have to master in order to pass the SQL Server 2012 70-462 exam. Throughout this tutorial video, you will learn how to install and configure the SQL Server, maintain instances and databases, optimize and troubleshoot, manage data, and implement security and high availability. Each topic is broken down into step-by-step lessons, allow you to quickly learn and retain the information more effectively.

Once you have completed this video based training course for the Microsoft SQL Server 70-462 exam, you will have a comprehensive understanding of how to Administer Databases with Microsoft SQL Server 2012. You will be fully prepared to write, and pass, your 70-462 exam and continue towards earning your MCSA and MCSE certifications.

How to take the Microsoft 70-462 Exam:

1. Find a test center near you to take the SQL Server 70-462 certification exam, their will provide details on test center locations and schedules. This exam is typically priced around $150 dollars.

2. Study the required material to pass the 70-462 examination. This course covers the material that is within the 70-462 certification exam, and will help put you in a great position to succeed in the exam

3. Pass your exam!

4) Take our Microsoft Windows Server 70-461 and 70-463 courses which will prepare you for the 70-461 and 70-463 exams. Upon passing the 70-461, 70-462, and 70-463 exams you will become a Microsoft Solutions Certified Associate in Microsoft SQL Server 2012.

5. Tell your friends how easy passing the Microsoft 70-462 exam was using Infinite Skills training courses

The information laid out above is given in good faith, we are not endorsing and third party company by offering a link to their site. You should always do your own research prior to making a purchase or using any service linked to via this website. Prices or details may alter and any information listed can not be guaranteed to be accurate. Note: While this course is comprehensive in regards to covering material on the exam, we do recommend using other aids to guide your study.

Who this course is for:

IT Professionals who wish to gain Microsoft Certification

Microsoft SQL Server 2012 Certification Training Exam 70-462

What you'll learn

Explore related topics

Course content

Introduction2 lectures • 6min

Installation And Configuration21 lectures • 2hr 47min

Maintain Instances And Databases28 lectures • 3hr 13min

Optimization And Troubleshooting14 lectures • 1hr 59min

Manage Data24 lectures • 1hr 57min

Implement Security13 lectures • 54min

Implement High Availability6 lectures • 45min

Conclusion1 lecture • 4min

Requirements

Description

Who this course is for: