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?	02:20
	2. 0102 What You Should Expect From The Videos	03:54

Installation And Configuration
	1. 0201 Growing And Shrinking Databases	09:49
	2. 0202 Monitoring Database Growth	07: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	06:11
	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	10:38
	10. 0210 Installing SQL Server Database Engine - Part 3	07:33
	11. 0211 Installing SQL Server Database Engine - Part 4	05:00
	12. 0212 Installing SQL Server Integration Services	07:02
	13. 0213 Enabling And Disabling Features	07:21
	14. 0214 Moving Databases Via Detach/Attach	07:46
	15. 0215 Migrating Logins	06:30
	16. 0216 Creating A Full Text Index	05:13
	17. 0217 Configuring FILESTREAM	01:29
	18. 0218 Configuring FILETABLE	01:33
	19. 0219 Create And Manage SQL Agent Jobs - Part 1	09:22
	20. 0220 Create And Manage SQL Agent Jobs - Part 2	04:30
	21. 0221 Setup Multi-Server Jobs	05:37

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

Optimization And Troubleshooting
	1. 0401 Replication For Reporting - Part 1	08: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	07:36
	5. 0405 Diagnosing Locking And Blocking - Part 1	08:52
	6. 0406 Diagnosing Locking And Blocking - Part 2	06:14
	7. 0407 Diagnosing Wait Stats	11:29
	8. 0408 Using SQL Profiler	10:15
	9. 0409 Using Performance Monitor - Part 1	07:30
	10. 0410 Using Performance Monitor - Part 2	04:30
	11. 0411 Using Extended Events	08:24
	12. 0412 Using SQL Server Auditing	08:14
	13. 0413 Using Data Collector	05:21
	14. 0414 Using Policy Based Management	06:53

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

Implement Security
	1. 0601 Logins Vs. Users	02:57
	2. 0602 Creating Logins	05:54
	3. 0603 Fixed Server Roles	05:47
	4. 0604 User Defined Server Roles	04:11
	5. 0605 Certificate Logins	02:18
	6. 0606 Instance Level Permissions	03:15
	7. 0607 Database Level Permissions	05:13
	8. 0608 Fixed Database Roles	05:43
	9. 0609 User Defined Database Roles	02:49
	10. 0610 Application Roles	04:15
	11. 0611 Creating Database Users	06:06
	12. 0612 Managing Certificates	02:18
	13. 0613 Endpoint Security	03: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	07:30
	4. 0704 Failing Over Database Mirroring	02:37
	5. 0705 Failing Over AlwaysOn Availability Groups	07:54
	6. 0706 Monitoring Database Mirroring	04: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!

€30.00

Get Unlimited Access to ALL Premium Files Not Convinced?

Free 70-462 Exam Questions & Microsoft 70-462 Dumps
Microsoft.selftestengine.70-462.v2019-07-24.by.toby.189q.ete	Views: 615 Downloads: 207	Size: 4.3 MB Votes: 2
Microsoft.selftestengine.70-462.v2019-05-19.by.benjamin.187q.ete	Views: 632 Downloads: 150	Size: 3.62 MB Votes: 3
Microsoft.testkings.70-462.v2019-02-10.by.lauren.184q.ete	Views: 880 Downloads: 274	Size: 3.43 MB Votes: 3
Microsoft.certkey.70-462.v2019-01-14.by.lilly.182q.ete	Views: 673 Downloads: 166	Size: 3.5 MB Votes: 2
Microsoft.prep4sure.70-462.v2018-12-01.by.henry.180q.ete	Views: 714 Downloads: 285	Size: 3.42 MB Votes: 2
Microsoft.selftesttraining.70-462.v2018-09-19.by.tsucico.184q.ete	Views: 991 Downloads: 276	Size: 2.12 MB Votes: 4
Microsoft.test-inside.70-462.v2018-07-25.by.hennes.182q.ete	Views: 1145 Downloads: 272	Size: 4.19 MB Votes: 3
Microsoft.prep4sure.70-462.v2018-06-15.by.john.178q.ete	Views: 1337 Downloads: 399	Size: 3.33 MB Votes: 2
Microsoft.mcsa.selftestengine.70-462.v2018-05-22.by.jeff.175q.ete	Views: 1344 Downloads: 1015	Size: 4.47 MB Votes: 3
Microsoft.selftestengine.mcsa.70-462.v2018-03-10.by.olga.172qs.ete	Views: 2819 Downloads: 1521	Size: 4.37 MB Votes: 12
Microsoft.Pass4sure.70-462.v2018-01-08.by.liuwei.143qs.ete	Views: 2023 Downloads: 2121	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

Dec 08, 2019

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 23, 2019

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 08, 2019

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 26, 2019

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 12, 2019

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

Sep 29, 2019

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