Curriculum For This Course

Introduction

2Lectures

Time 00:06:14

Installation And Configuration

21Lectures

Time 02:46:57

Maintain Instances And Databases

28Lectures

Time 03:13:05

Optimization And Troubleshooting

14Lectures

Time 01:58:59

Manage Data

24Lectures

Time 01:57:03

Implement Security

13Lectures

Time 00:54:21

Implement High Availability

6Lectures

Time 00:44:32

Introduction
	1. 0101 What Is Exam 70-462?	2:20
	2. 0102 What You Should Expect From The Videos	3:54

Installation And Configuration
	1. 0201 Growing And Shrinking Databases	9:49
	2. 0202 Monitoring Database Growth	7:35
	3. 0203 Designing Database Storage	10:23
	4. 0204 Configure An SQL Server Standby Server - Part 1	13:52
	5. 0205 Configure An SQL Server Standby Server - Part 2	7:06
	6. 0206 Changing Service Accounts	13:12
	7. 0207 Testing Database Connectivity	10:08
	8. 0208 Installing SQL Server Database Engine - Part 1	11:37
	9. 0209 Installing SQL Server Database Engine - Part 2	11:35
	10. 0210 Installing SQL Server Database Engine - Part 3	8:52
	11. 0211 Installing SQL Server Database Engine - Part 4	5:01
	12. 0212 Installing SQL Server Integration Services	7:02
	13. 0213 Enabling And Disabling Features	7:21
	14. 0214 Moving Databases Via Detach/Attach	7:46
	15. 0215 Migrating Logins	6:30
	16. 0216 Creating A Full Text Index	5:13
	17. 0217 Configuring FILESTREAM	1:29
	18. 0218 Configuring FILETABLE	1:33
	19. 0219 Create And Manage SQL Agent Jobs - Part 1	9:22
	20. 0220 Create And Manage SQL Agent Jobs - Part 2	4:30
	21. 0221 Setup Multi-Server Jobs	7:01

Maintain Instances And Databases
	1. 0301 Using Multiple Files And Filegroups	7:57
	2. 0302 Recovery Models	6:07
	3. 0303 Adding New Filegroups	2:24
	4. 0304 Moving Tables Between Filegroups	6:05
	5. 0305 Enabling Contained Databases	4:57
	6. 0306 Data Compression	10:20
	7. 0307 Configuring TDE	6:51
	8. 0308 Setting Up Table Partitioning - Part 1	9:15
	9. 0309 Setting Up Table Partitioning - Part 2	10:20
	10. 0310 Managing Log File Growth - Part 1	8:32
	11. 0311 Managing Log File Growth - Part 2	2:13
	12. 0312 DBCC CHECKDB	9:10
	13. 0313 Installing Default And Named Instances - Part 1	7:48
	14. 0314 Installing Default And Named Instances - Part 2	5:42
	15. 0315 CPU Affinity	5:26
	16. 0316 Instance Level Settings - Part 1	9:13
	17. 0317 Instance Level Settings - Part 2	9:02
	18. 0318 Instance Level Settings - Part 3	10:51
	19. 0319 Memory Settings	5:17
	20. 0320 Database Mail	8:40
	21. 0321 Fillfactor	6:44
	22. 0322 Installing A Clustered Instance - Part 1	7:58
	23. 0323 Installing A Clustered Instance - Part 2	8:38
	24. 0324 Installing A Clustered Instance - Part 3	9:19
	25. 0325 Installing A Clustered Instance - Part 4	1:48
	26. 0326 Multi-Instance Clustering	3:56
	27. 0327 Multi-Subnet Clustering	4:27
	28. 0328 Recover From A Failed Cluster Node	4:05

Optimization And Troubleshooting
	1. 0401 Replication For Reporting - Part 1	8:22
	2. 0402 Replication For Reporting - Part 2	11:54
	3. 0403 Replication For Reporting - Part 3	12:23
	4. 0404 Replication For Reporting - Part 4	7:36
	5. 0405 Diagnosing Locking And Blocking - Part 1	8:52
	6. 0406 Diagnosing Locking And Blocking - Part 2	6:14
	7. 0407 Diagnosing Wait Stats	11:29
	8. 0408 Using SQL Profiler	10:15
	9. 0409 Using Performance Monitor - Part 1	7:33
	10. 0410 Using Performance Monitor - Part 2	5:29
	11. 0411 Using Extended Events	8:24
	12. 0412 Using SQL Server Auditing	8:14
	13. 0413 Using Data Collector	5:21
	14. 0414 Using Policy Based Management	6:53

Manage Data
	1. 0501 Define Recovery Models	4:04
	2. 0502 Mirrored Backups	1:39
	3. 0503 Stripped Backups	2:39
	4. 0504 Restoring Full Backups	4:16
	5. 0505 Restoring Differential Backups	5:41
	6. 0506 Restoring Transaction Log Backups	4:15
	7. 0507 File Group Restores	4:11
	8. 0508 Testing Backups	2:32
	9. 0509 Restoring Master Database	5:23
	10. 0510 Restoring msdb Database	0:48
	11. 0511 Restoring model Database	0:32
	12. 0512 Restoring Databases Protected By TDE	3:49
	13. 0513 Restoring A Single Database Page	2:12
	14. 0514 Point In Time Restores	5:33
	15. 0515 Index Maintenance	10:22
	16. 0516 Identifying Index Fragmentation	4:34
	17. 0517 Identifying Unused Indexes	6:32
	18. 0518 Filtered Indexes	3:23
	19. 0519 Updating Statistics	3:38
	20. 0520 Full Text Indexes	15:09
	21. 0521 Column Store Indexes	7:51
	22. 0522 Import Export Wizard	5:54
	23. 0523 BCP	8:31
	24. 0524 Bulk Insert	3:35

Implement Security
	1. 0601 Logins Vs. Users	2:57
	2. 0602 Creating Logins	5:54
	3. 0603 Fixed Server Roles	5:47
	4. 0604 User Defined Server Roles	4:11
	5. 0605 Certificate Logins	2:18
	6. 0606 Instance Level Permissions	3:15
	7. 0607 Database Level Permissions	5:13
	8. 0608 Fixed Database Roles	5:43
	9. 0609 User Defined Database Roles	2:49
	10. 0610 Application Roles	4:15
	11. 0611 Creating Database Users	6:06
	12. 0612 Managing Certificates	2:18
	13. 0613 Endpoint Security	3:35

Implement High Availability
	1. 0701 Configure Database Mirroring	10:54
	2. 0702 Configure AlwaysOn Availability Groups - Part 1	10:33
	3. 0703 Configure AlwaysOn Availability Groups - Part 2	7:58
	4. 0704 Failing Over Database Mirroring	2:37
	5. 0705 Failing Over AlwaysOn Availability Groups	7:54
	6. 0706 Monitoring Database Mirroring	4:36

About This Course

Also known as Administering Microsoft SQL Server 2014 Databases, this course brings you close to the administration level expertise. The course is capable to give you the advantages during the process of recruitment of managers. Besides, it can promote you to the managerial level of administration with the MCSE and MCSA certifications.

The course comes with both theoretical and practical preparations, training, and exams. This helps you prepare not only for the exam but also for the practical world after obtaining the certificate.

Description

This advanced level course comes with complete details and required knowledge and skills regarding SQL Server Administration. This is a helpful tutorial while preparing for the Microsoft 70-462 exam and looking for the MCSA and MCSE certifications.

The course comprises 13 modules that are dedicated to enhancing theoretical knowledge and practical skills. There are also labs that are sufficient to obtain new hands-on experience.

The course helps to get the skills in

Installing SQL Server and other related services
Implementing the Migration strategy
Process of configuring additional components of SQL Server
Management of SQL Server Agent
Management and configuration of Database
Process of configuring SQL Server instances
Implementation of instance of SQL Server cluster
Management of SQL Server instances
Process of identification and resolving concurrency problems
Collecting and process of troubleshooting the analyzed data
Audit of instances of SQL Server
Maintaining and configuration of backup strategy
Restoration of database
Maintaining and implementing of indexes
Exporting and importing of data
Management of server and login roles
Management of permissions of database
Management of database roles and users
Troubleshooting of security

The topics covered by the course

Installation and configuration
Maintenance of databases and instances
Optimization and troubleshooting
Management of data
Implementation of security
Implementation of high availability

Who can apply for the course?

The course is widely preferred by the SQL administrators.
It can be interesting for students who want to maintain and administer databases of SQL Server.
The course attracts IT professionals willing to get the certification.
It can be useful for IT professionals who have administration skills.

There are a few prerequisites of the course, including basic understanding of the Microsoft Windows OS and Transact-SQL, as well as experience related to databases.

Conclusion

This course is the best and basic one while looking for the MCSA, MCP, and MCSE certificates. It aids you in getting total skills to become a professional administrator for SQL Server. It focuses on teaching the students how to deal with SQL Server 2014 tools and product features.

Career path:

This course related to MS SQL Server 2014 helps you get designated to the administrative level of any post such as an Analyst, a Manager, and a Researcher.

The specialists with the certification receive a basic salary that ranges from $49,876 to $118,764 on annual basis.

Pass Microsoft MCSA 70-462 Exam in First Attempt Guaranteed!

Get 100% Real Exam Questions, Accurate & Verified Answers As Seen in the Real Exam!
30 Days Free Updates, Instant Download!

$23.33

Get Unlimited Access to ALL Premium Files Not Convinced?

Free 70-462 Exam Questions & Microsoft 70-462 Dumps
Microsoft.testkings.70-462.v2019-02-10.by.lauren.184q.ete	Views: 352 Downloads: 143	Size: 3.43 MB Votes: 3
Microsoft.certkey.70-462.v2019-01-14.by.lilly.182q.ete	Views: 320 Downloads: 114	Size: 3.5 MB Votes: 2
Microsoft.prep4sure.70-462.v2018-12-01.by.henry.180q.ete	Views: 342 Downloads: 157	Size: 3.42 MB Votes: 2
Microsoft.selftesttraining.70-462.v2018-09-19.by.tsucico.184q.ete	Views: 631 Downloads: 204	Size: 2.12 MB Votes: 4
Microsoft.test-inside.70-462.v2018-07-25.by.hennes.182q.ete	Views: 823 Downloads: 235	Size: 4.19 MB Votes: 3
Microsoft.prep4sure.70-462.v2018-06-15.by.john.178q.ete	Views: 1013 Downloads: 266	Size: 3.33 MB Votes: 2
Microsoft.mcsa.selftestengine.70-462.v2018-05-22.by.jeff.175q.ete	Views: 1028 Downloads: 343	Size: 4.47 MB Votes: 3
Microsoft.selftestengine.mcsa.70-462.v2018-03-10.by.olga.172qs.ete	Views: 2485 Downloads: 1394	Size: 4.37 MB Votes: 12
Microsoft.Pass4sure.70-462.v2018-01-08.by.liuwei.143qs.ete	Views: 1635 Downloads: 1976	Size: 3.75 MB Votes: 14

Student Feedback

4.7

Excellent

72%

28 %

Comments * The most recent comment are at the top

Amelia

South Africa

Nov 12, 2018

Great video lectures, propelled modules, question papers, and so on are what you need to get for scoring in the Microsoft exam. The underlying days no uncertainty confounded me, in any case, I got immediately dependent on the modules and addresses for getting ready for the exam. I passed the exam without any difficulties. Thanks a lot, the best instructor!

Juan José

United States

Nov 06, 2018

Astounding course with otherworldly advantages. With the use of the course that provides a great intelligent instructor, I could pass the exam with great numbers. The instructor has presented his complete knowledge in the course that allows to learn effortlessly with different disclosed traps to make it simple for recollecting. So, the course is great to enable you to pass the exams completely. Thank you so much once again.

Robert

India

Nov 01, 2018

Are you also going to reach the professional level in the field of administration????This course designed by the knowledgeable instructor is the end of your search. The course is made keeping in mind the concept of video learning. So, the lectures, modules, and other practical aspects have made the course a big hit. With all the learning modules and materials easy to download, the instructor has made learning simpler. Thanks for this marvelous course!!!!!!

Miguel

Saudi Arabia

Oct 18, 2018

I have heard about various instructional classes, but I discovered this course the best one get ready for the exam. I would recommend this course. I am still learning with it, and I am extremely satisfied with the keen instructor it accompanies. Planned professionally, the course is accessible in video addresses. Subsequent to experiencing this course, I have built up an alternate sort of certainty for composing the exams. Thanks to the instructor who has helped with profound knowledge to prepare for the exam and become a real professional.

Princess

Afghanistan

Oct 10, 2018

The fundamental point to like the course is the useful detailed clarifications it concocts. The instructor has likewise drawn out all the vital ideas independently in a module, which makes adapting so simple. The nitty gritty answers and brief clarifications of each address are genuinely helpful to get ready for the exam. This course is surely the best one to go with while thinking of learning all the required concepts about administration in detail. Thank you for this magical course!

Aya

Uganda

Oct 04, 2018

The course covers almost all the imperative ideas of the course and administration of SQL server with most extreme profundity. The lucidity of the recordings adds to the learning condition. Every subject is intended for the understudies to get it. The modules cover all the necessary concepts. The online video addresses are also very useful. The instructor uses very simple language that is easy to understand. Many thanks to the instructor who has helped in learning all the concepts with ease..

Add Comments

Name:^*

E-mail:^*

Comment:^* Comment will be moderated and published within 1-4 hours

Verification:^*

Type the characters from the picture.

Rate Course:^*

Limited Time Discount Offer
40% Off - Ends in 02:00:00

70-462: MCSA Administering Microsoft SQL Server 2012/2014 Databases

Curriculum For This Course