Udemy_Microsoft_SQL_Server_2012_Certification_Training_Exam_70-462

در این آموزش تصویری با مباحث مربوط به گواهینامه SQL Server 2012 آزمون 70-462 آشنا می شوید.

این دوره آموزشی محصول موسسه Udemy است.

سرفصل های این دوره آموزشی:

  • مقدمه
  • نصب و پیکربندی
  • طراحی و ذخیره پایگاه داده
  • پیکر بندی سرور SQL Server
  • تغییر اکانت سرویس
  • تست اتصال به پایگاه داده
  • نصب سرویس های یکپارچه SQL Server
  • فعال و غیر فعال کردن ویژگی ها
  • جابه جایی دیتابیس از طریق Detach/Attach
  • پیکربندی FILESTREAM
  • استفاده از چندین فایل و Filegroups
  • مدل های بازیابی
  • اضافه کردن Filegroups های جدید
  • انتقال جدول ها بین Filegroups
  • فشرده سازی داده ها
  • پیکربندی TDE
  • راه اندازی قسمت بندی جداول
  • تنظیمات Memory
  • ایمیل دیتابیس
  • نصب خوشه
  • بهینه سازی و عیب یابی
  • تشخیص قفل ها و مسدود کردن
  • استفاده از SQL Profiler
  • مدیریت داده ها
  • تعریف مدل بازیابی
  • پشتیان گیری
  • بازگرداندن کامل پشتیبان گیری
  • تست پشتیبان گیری
  • آموزش ترمیم دیتابیس
  • ترمیم دیتابیس MSDB
  • بازیابی دیتابیس حفاظت شده توسط TDE
  • بازیابی یک صفحه دیتابیس
  • به روز رسانی آمار
  • امنیت
  • لاگین کاربران VS
  • ساخت Login
  • کاربران تعریف شده سرور
  • دیتابیس فیکس شده
  • ساخت کاربران دیتابیس
  • مدیریت مجوزها
  • امنیت Endpoint
  • پیکر بندی گروه های AlwaysOn
  • نظارت بر دیتابیس های معکوس
  • نتیجه گیری

عنوان دوره: Udemy Microsoft SQL Server 2012 Certification Training Exam 70-462

سطح: متوسط

مدت دوره: 12 ساعت

 توضیحات:

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

Infinite Skills
12 hours
All Levels

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.

What are the requirements?
A Desire To Learn
What am I going to get from this course?
To Study And Pass The Microsoft 70-462 Exam and Gain Certification For MCSA or MCSE
What is the target audience?
IT Professionals who wish to gain Microsoft Certification

Section 1: Introduction
Lecture 1
0101 What Is Exam 70-462?
Preview
02:20
Lecture 2
0102 What You Should Expect From The Videos
Preview
03:54
Section 2: Installation And Configuration
Lecture 3
0201 Growing And Shrinking Databases
Preview
09:49
Lecture 4
0202 Monitoring Database Growth
07:35
Lecture 5
0203 Designing Database Storage
10:23
Lecture 6
0204 Configure An SQL Server Standby Server - Part 1
13:52
Lecture 7
0205 Configure An SQL Server Standby Server - Part 2
07:06
Lecture 8
0206 Changing Service Accounts
13:12
Lecture 9
0207 Testing Database Connectivity
10:08
Lecture 10
0208 Installing SQL Server Database Engine - Part 1
11:37
Lecture 11
0209 Installing SQL Server Database Engine - Part 2
11:35
Lecture 12
0210 Installing SQL Server Database Engine - Part 3
08:52
Lecture 13
0211 Installing SQL Server Database Engine - Part 4
05:00
Lecture 14
0212 Installing SQL Server Integration Services
07:02
Lecture 15
0213 Enabling And Disabling Features
07:21
Lecture 16
0214 Moving Databases Via Detach/Attach
07:46
Lecture 17
0215 Migrating Logins
06:30
Lecture 18
0216 Creating A Full Text Index
05:13
Lecture 19
0217 Configuring FILESTREAM
01:29
Lecture 20
0218 Configuring FILETABLE
01:33
Lecture 21
0219 Create And Manage SQL Agent Jobs - Part 1
09:22
Lecture 22
0220 Create And Manage SQL Agent Jobs - Part 2
04:30
Lecture 23
0221 Setup Multi-Server Jobs
07:00
Section 3: Maintain Instances And Databases
Lecture 24
0301 Using Multiple Files And Filegroups
07:57
Lecture 25
0302 Recovery Models
06:07
Lecture 26
0303 Adding New Filegroups
02:24
Lecture 27
0304 Moving Tables Between Filegroups
06:05
Lecture 28
0305 Enabling Contained Databases
04:57
Lecture 29
0306 Data Compression
10:20
Lecture 30
0307 Configuring TDE
06:51
Lecture 31
0308 Setting Up Table Partitioning - Part 1
09:15
Lecture 32
0309 Setting Up Table Partitioning - Part 2
10:20
Lecture 33
0310 Managing Log File Growth - Part 1
08:32
Lecture 34
0311 Managing Log File Growth - Part 2
02:13
Lecture 35
0312 DBCC CHECKDB
09:10
Lecture 36
0313 Installing Default And Named Instances - Part 1
07:48
Lecture 37
0314 Installing Default And Named Instances - Part 2
05:42
Lecture 38
0315 CPU Affinity
05:26
Lecture 39
0316 Instance Level Settings - Part 1
09:13
Lecture 40
0317 Instance Level Settings - Part 2
09:02
Lecture 41
0318 Instance Level Settings - Part 3
10:51
Lecture 42
0319 Memory Settings
05:17
Lecture 43
0320 Database Mail
08:40
Lecture 44
0321 Fillfactor
06:44
Lecture 45
0322 Installing A Clustered Instance - Part 1
07:58
Lecture 46
0323 Installing A Clustered Instance - Part 2
08:38
Lecture 47
0324 Installing A Clustered Instance - Part 3
09:19
Lecture 48
0325 Installing A Clustered Instance - Part 4
01:48
Lecture 49
0326 Multi-Instance Clustering
03:56
Lecture 50
0327 Multi-Subnet Clustering
04:27
Lecture 51
0328 Recover From A Failed Cluster Node
04:05
Section 4: Optimization And Troubleshooting
Lecture 52
0401 Replication For Reporting - Part 1
08:22
Lecture 53
0402 Replication For Reporting - Part 2
11:54
Lecture 54
0403 Replication For Reporting - Part 3
12:23
Lecture 55
0404 Replication For Reporting - Part 4
07:36
Lecture 56
0405 Diagnosing Locking And Blocking - Part 1
08:52
Lecture 57
0406 Diagnosing Locking And Blocking - Part 2
06:14
Lecture 58
0407 Diagnosing Wait Stats
11:29
Lecture 59
0408 Using SQL Profiler
10:15
Lecture 60
0409 Using Performance Monitor - Part 1
07:33
Lecture 61
0410 Using Performance Monitor - Part 2
05:29
Lecture 62
0411 Using Extended Events
08:24
Lecture 63
0412 Using SQL Server Auditing
08:14
Lecture 64
0413 Using Data Collector
05:21
Lecture 65
0414 Using Policy Based Management
06:53
Section 5: Manage Data
Lecture 66
0501 Define Recovery Models
04:04
Lecture 67
0502 Mirrored Backups
01:39
Lecture 68
0503 Stripped Backups
02:39
Lecture 69
0504 Restoring Full Backups
04:16
Lecture 70
0505 Restoring Differential Backups
05:41
Lecture 71
0506 Restoring Transaction Log Backups
04:15
Lecture 72
0507 File Group Restores
04:11
Lecture 73
0508 Testing Backups
02:32
Lecture 74
0509 Restoring Master Database
05:23
Lecture 75
0510 Restoring msdb Database
00:48
Lecture 76
0511 Restoring model Database
00:32
Lecture 77
0512 Restoring Databases Protected By TDE
03:49
Lecture 78
0513 Restoring A Single Database Page
02:12
Lecture 79
0514 Point In Time Restores
05:33
Lecture 80
0515 Index Maintenance
10:22
Lecture 81
0516 Identifying Index Fragmentation
04:34
Lecture 82
0517 Identifying Unused Indexes
06:32
Lecture 83
0518 Filtered Indexes
03:23
Lecture 84
0519 Updating Statistics
03:38
Lecture 85
0520 Full Text Indexes
15:09
Lecture 86
0521 Column Store Indexes
07:51
Lecture 87
0522 Import Export Wizard
05:54
Lecture 88
0523 BCP
08:31
Lecture 89
0524 Bulk Insert
03:35
Section 6: Implement Security
Lecture 90
0601 Logins Vs. Users
02:57
Lecture 91
0602 Creating Logins
05:54
Lecture 92
0603 Fixed Server Roles
05:47
Lecture 93
0604 User Defined Server Roles
04:11
Lecture 94
0605 Certificate Logins
02:18
Lecture 95
0606 Instance Level Permissions
03:15
Lecture 96
0607 Database Level Permissions
05:13
Lecture 97
0608 Fixed Database Roles
05:43
Lecture 98
0609 User Defined Database Roles
02:49
Lecture 99
0610 Application Roles
04:15
Lecture 100
0611 Creating Database Users
06:06
Lecture 101
0612 Managing Certificates
02:18
Lecture 102
0613 Endpoint Security
03:35
Section 7: Implement High Availability
Lecture 103
0701 Configure Database Mirroring
10:54
Lecture 104
0702 Configure AlwaysOn Availability Groups - Part 1
10:33
Lecture 105
0703 Configure AlwaysOn Availability Groups - Part 2
07:58
Lecture 106
0704 Failing Over Database Mirroring
02:37
Lecture 107
0705 Failing Over AlwaysOn Availability Groups
07:54
Lecture 108
0706 Monitoring Database Mirroring
04:36
Section 8: Conclusion
Lecture 109
Thank You
04:00