Administering Microsoft SQL Server Databases (MS-20462)

This intermediate-level 5 days course is specifically designed for professionals striving to pursue a career in the niche of Microsoft SQL Server Databases Administration & Maintenance.

Virtual

Learning Style

Microsoft

Provider

Intermediate

Difficulty

5 Days

Course Duration

5

SATV Value

Course Info

Download PDF

Certificate

See Sample

Timezone
empty table
tab

You have already taken demo for this course.

If you want to get access to demo again, feel free to contact our support at (855) 800-8240

This intermediate-level 5 days course is specifically designed for professionals striving to pursue a career in the niche of Microsoft SQL Server Databases Administration & Maintenance.

Course Information

Candidates enrolling directly in this course without the Master Subscription Plan will receive a free official exam voucher for the 70-462 Exam (Except Purchases included in Training Vouchers/SATV). There is no free official exam voucher for candidates enrolling using the Master Subscription Plan. However, the official exam voucher can be purchased separately on request

About this Course:

This intermediate-level 5 days course is specifically designed for professionals striving to pursue a career in the niche of Microsoft SQL Server Databases Administration & Maintenance. Professionals having proficiency in SQL Server Database Maintenance are always in high demand and can easily secure a reputable job in the niche of Information Technology. This course is specifically designed for professionals interested in enhancing the knowledge of SQL Server 2012/2014. The new features and upgrades in the SQL Server 2014 are also elaborated in this course. Professionals with proficiency in SQL Server Database Maintenance and Administration and IT Professionals earn $82,000 annually.

Course Objectives:

The core objective of this course is to help professionals gain a better understanding and sound knowledge of the following key concepts:

  • Database Restoration and Data Migration
  • SQL Server 2014 Configuration and Installation
  • Database Alerts, Notifications, and Mails Configuration
  • Data Encryption and Data Access Auditing
  • Backup Strategy Planning & Implementation and SQL Server Storage Configuration
  • Database Administration Tools & Best Practices
  • Monitoring, Tracing and Managing SQL Server
  • Database Upkeep & Maintenance Tasks and SQL Server Maintenance Automation

Audience:

  • Database Administrators & App Developers
  • Professionals Administering & Maintaining SQL Server Databases
  • Professionals Developing SQL Server Databases 

Prerequisites:

Professionals planning to enroll in the Administering Microsoft SQL Server Databases (MS-20462) Course must comply with the following prerequisites:

  • Database Designing Practical Experience
  • Conceptual Know-how of Core Functionalities of Windows Operating System
  • Fundamental Knowledge of Transact-SQL and Relational Databases

Suggested Prerequisite Courses:

  • Querying Data with Microsoft Transact-SQL (MS-20761)
  • Querying Microsoft SQL Server (MS-20461)

Outline

Frequently Asked Questions



1. How will the Administering Microsoft SQL Server Databases (MS-20462) certification training benefit me in my current job role?

This training will help you in your Job’s current role by knowing and getting hands on experience in the following areas:
  • How to monitor data using DMV (Dynamic Management Views)
  • How to configure SQL Profiler and SQL Trace.
  • Learn how to use Database Tuning Advisor.
  • Learn how to configure Database Mail, Alerts and notifications.
  • Managing SQL Server using Windows PowerShell.
  • Configuration learning of SQL Server Agent.
  • The art of Encryption and Auditing of SQL Server databases.
  • Configuring and assigning Permissions.
  • How to Authenticate and Authorize Users.

2. How many types of System Databases does one Instance of SQL Server 2014 have?

There are 5 types of System databases, each instance of SQL Server 2014 have. Types of databases are as follows:

  • Master: Stores all system-level configuration.
  • Msdb: Holds SQL Server Agent configuration data.
  • Model: Provides the template for new databases.
  • Tempdb: Holds temporary data.
  • Resource: Contains system objects that are mapped to the sys schema of databases

3. How can we move the Master Database in SQL Server 2014?

Follow the below mentioned steps to move Master Database in SQL Server 2014:

  • Open SQL Server Configuration Manager.
  • In the SQL Server Services node, right-click the instance of SQL Server, click Properties and then click the Startup Parameters tab.
  • Edit the Startup Parameters values to point to the planned location for the master database data (-d parameter) and log (-l parameter) files.
  • Stop the Instance of SQL Server.
  • Move the master.mdf and mast.ldf file to the new location.
  • Restart the instance of SQL Server.

4. What is the function of SQL Profiler in SQL Server 2014?

The main functions of SQL Server Profiler are as follows:

  • Create, Capture, and view details of events in a SQL Server instance.
  • Based on the SQL Trace programming interface.
  • Used in scenarios such as, debugging, performance monitoring and deadlock monitoring.
  • It can also Replay functionality for stress testing.

More Information

More Information
BrandMicrosoft
SubjectsIT Ops & Management
Lab AccessYes
TechnologyMicrosoft
Learning StyleVirtual Classroom
Learning TypeCourse
DifficultyIntermediate
Course Duration5 Days
LanguageEnglish
SATV Value5
VPA DiscountVPA Discount

Reviews

Write Your Own Review
Only registered users can write reviews. Please Sign in or create an account

Course Expert:

Author

Tom Robertson
(Data Science Enthusiast)

Tom is an innovator first, and then a Data Scientist & Software Architect. He has integrated expertise in business, product, technology and management. Tom has been involved in creating category defining new products in AI and big data for different industries, which generated more than hundred million revenue cumulatively, and served more than 10 million users.
As a Data Scientist and Software Architect Tom has extensive experience in data science, engineering, architecture and software development. To date Tom has accumulated over a decade of experience in R, Python & Linux Shell programming.

Tom has expertise on Python, SQL, and Spark. He has worked on several libraries including but not limited to Scikit-learn, Pandas, NumPy, Matplotlib, Seaborn, SciPy, NLTK, Keras, and Tensorflow.

Customer Reviews
  1. Administering Microsoft SQL Server Databases (MS­20462)
    Overall Satisfaction
    60%
    Quality of Instructor
    60%
    Course Quality
    60%
    My lecture instructor was great, the lab instructor was essentially non­existent. The labs are also formatted in a way that is not very informative, they are just procedural steps without any explanation of the technical details (how's and why's) of what it is that you are doing. This is not helped by the fact that they are separated entirely from the lecture portion of the course.

    Review by

    Posted on

  2. Administering Microsoft SQL Server Databases (MS­20462)
    Overall Satisfaction
    100%
    Quality of Instructor
    100%
    Course Quality
    100%
    Clear and efficient learning.

    Review by

    Posted on

  3. Course Quality
    60%
    Course Value
    80%
    Quality of Instructor
    100%
    Overall Satisfaction
    100%
    Appreciate with accommodating my time zone to attend the course.

    Review by

    Posted on

  4. Course Quality
    60%
    Course Value
    80%
    Quality of Instructor
    100%
    Overall Satisfaction
    100%
    Online classes are great and accommodating with different time zones. Will definitely recommend to my fellow co­workers to look into QuickStart IT courses.

    Review by

    Posted on

  5. Course Quality
    80%
    Course Value
    80%
    Quality of Instructor
    80%
    Overall Satisfaction
    80%
    Abdulah was easy to follow and efficient in covering the material. He seems to know the material vey well.

    Review by

    Posted on

  6. Course Quality
    80%
    Course Value
    80%
    Quality of Instructor
    80%
    Overall Satisfaction
    80%
    I found this class to be an efficient way to get a broad overview of the basics of SQL Server administration. The balance of theory and hands­on practical how­to was just right.

    Review by

    Posted on

  7. Course Quality
    80%
    Course Value
    80%
    Quality of Instructor
    80%
    Overall Satisfaction
    60%
    Overall the class provided information that will help with my current job needs.

    Review by

    Posted on

  8. Course Quality
    80%
    Course Value
    80%
    Quality of Instructor
    80%
    Overall Satisfaction
    100%
    Abdullah was very informative and was able to incorporate real world examples I asked about.

    Review by

    Posted on

  9. Course Quality
    80%
    Course Value
    80%
    Quality of Instructor
    80%
    Overall Satisfaction
    80%
    Overall a good class, very informative.

    Review by

    Posted on

  10. Course Quality
    80%
    Course Value
    80%
    Quality of Instructor
    80%
    Overall Satisfaction
    80%
    The course was good and very informative.

    Review by

    Posted on

  11. Course Quality
    100%
    Course Value
    100%
    Quality of Instructor
    100%
    Overall Satisfaction
    100%
    Knowledgeable and friendly.

    Review by

    Posted on

  12. Course Quality
    100%
    Course Value
    100%
    Quality of Instructor
    100%
    Overall Satisfaction
    100%
    Fast registration process and knowledgeable instructors.

    Review by

    Posted on

  13. Course Quality
    80%
    Course Value
    80%
    Quality of Instructor
    80%
    Overall Satisfaction
    60%
    No issues.

    Review by

    Posted on

  14. Course Quality
    100%
    Course Value
    100%
    Quality of Instructor
    100%
    Overall Satisfaction
    100%
    I like that he was able to answer questions and was very knowledgeable; he knows the material he is teaching.

    Review by

    Posted on

  15. Course Quality
    100%
    Course Value
    100%
    Quality of Instructor
    100%
    Overall Satisfaction
    100%
    Trying out the one year access and I really like it. I think it is worth the money and time.

    Review by

    Posted on

  16. Course Quality
    80%
    Course Value
    60%
    Quality of Instructor
    80%
    Overall Satisfaction
    80%
    Instruction is clear and easy to understand.

    Review by

    Posted on

  17. Course Quality
    80%
    Course Value
    60%
    Quality of Instructor
    80%
    Overall Satisfaction
    80%
    The class is a good instruction and hope there are more interactions between instructors and students during the instructions.

    Review by

    Posted on

  18. Excellent material
    Course Quality
    100%
    Course Value
    80%
    Quality of Instructor
    100%
    Overall Satisfaction
    100%
    Highly recommend him to other future students I wish we an extended time to use the lab even after the class is over.

    Review by

    Posted on

  19. Enjoyable
    Course Quality
    80%
    Course Value
    80%
    Quality of Instructor
    80%
    Overall Satisfaction
    100%

    Review by

    Posted on

  20. Pleasing
    Course Quality
    80%
    Quality of Instructor
    80%
    Overall Satisfaction
    100%

    Review by

    Posted on

  21. Course Value
    100%
    Quality of Instructor
    100%
    Overall Satisfaction
    100%

    Review by

    Posted on

  22. Course Value
    100%
    Quality of Instructor
    100%
    Overall Satisfaction
    100%

    Review by

    Posted on

  23. Course Value
    100%
    Quality of Instructor
    100%
    Overall Satisfaction
    100%
    His concepts about SQL were very solid.He always demonstrated practical examples to go through the training instead of just using the slides. I have worked 7-10 years in the IT industry when taking this training.

    Review by

    Posted on

  24. Course Value
    100%
    Quality of Instructor
    100%
    Overall Satisfaction
    100%
    Jeff was excellent personable and exceptionally knowledgeable.There was only one change I would make and that is to not load up all instruction in the morning and all labs in the afternoon. It may be just my personal learning style I have worked over 10 years in the IT industry when taking this training.

    Review by

    Posted on

  25. Course Value
    100%
    Quality of Instructor
    100%
    Overall Satisfaction
    100%
    The instructor's lectures were very clear. I have worked over 10 years in the IT industry when taking this training.

    Review by

    Posted on

  26. Course Value
    100%
    Quality of Instructor
    100%
    Overall Satisfaction
    100%
    Well versed in DBA aspects was excellent at explaining how things worked. Two specific things Jeff did that I liked: Drawing out concepts on the screen / demonstrating from within SSMS not just reading the slides and saying 'do the lab' The anecdotes and stories are a great tool to help remember simple things that are important. (I will always make sure to checkbox 'user must change password at next login' !!) I have worked 3-5 years in the IT industry when taking this training.

    Review by

    Posted on

  27. Course Value
    100%
    Quality of Instructor
    100%
    Overall Satisfaction
    100%

    Review by

    Posted on

  28. Course Value
    100%
    Quality of Instructor
    100%
    Overall Satisfaction
    100%
    Instructor had good real world SQL knowledge I have worked over 10 years in the IT industry when taking this training.

    Review by

    Posted on

  29. Course Value
    100%
    Quality of Instructor
    100%
    Overall Satisfaction
    100%
    Jeff knows the subject matter inside and out. He is a tremendously talented instructor very personable. Leads the class well. I have worked over 10 years in the IT industry when taking this training.

    Review by

    Posted on

  30. Course Value
    100%
    Quality of Instructor
    100%
    Overall Satisfaction
    100%
    One of the best online training courses I've ever taken. I have worked over 10 years in the IT industry when taking this training.

    Review by

    Posted on

  31. Course Value
    100%
    Quality of Instructor
    100%
    Overall Satisfaction
    100%
    Overall the instructor was very good I have worked over 10 years in the IT industry when taking this training.

    Review by

    Posted on

  32. Course Value
    100%
    Quality of Instructor
    100%
    Overall Satisfaction
    100%
    Jeff is an accomplished and mature instructor i.e. he is always optimistic and makes his attendees feel comfortable I have worked over 10 years in the IT industry when taking this training.

    Review by

    Posted on

  33. Overall Satisfaction
    100%
    Greatly appreciate the experience stories on 'why' certain topics are very important. N/A New Career Path

    Review by

    Posted on

  34. Course Quality
    80%
    Overall Satisfaction
    100%
    I really enjoyed the lectures in the morning and labs in the afternoon format. Please keep this! Jeff did a great job of using the slides / canned materials and adding to them with examples.

    Review by

    Posted on

  35. Course Quality
    80%
    Quality of Instructor
    80%
    Overall Satisfaction
    80%
    I was following book 2462D for the first 3 days which is the latest version, but on the 4th day I switched to 2462C and this book was more accurate to what the instructor was teaching and the slides he used.

    Review by

    Posted on

  36. Course Quality
    80%
    Quality of Instructor
    80%
    Overall Satisfaction
    80%

    Review by

    Posted on

  37. Overall Satisfaction
    100%
    Easy to understand, and good training workflow.

    Review by

    Posted on

  38. Course Quality
    60%
    Overall Satisfaction
    80%
    I have managed SQL for some time so about 7% of this class was reinforcing what I already do, but the new things were very helpful Manish was great, clear and easy to understand and worked with the class well with examples and help during labs

    Review by

    Posted on

  39. Quality of Instructor
    80%
    Overall Satisfaction
    100%

    Review by

    Posted on

  40. Quality of Instructor
    100%
    It was as required for the course. Fine!

    Review by

    Posted on

  41. Overall Satisfaction
    80%

    Review by

    Posted on

  42. Overall Satisfaction
    100%

    Review by

    Posted on

  43. Quality of Instructor
    60%
    Quality of Instructor
    60%
    Overall Satisfaction
    80%

    Review by

    Posted on

  44. Course Quality
    60%
    Overall Satisfaction
    80%

    Review by

    Posted on

  45. Overall Satisfaction
    80%
    Excellent instructor and very helpful

    Review by

    Posted on

  46. Overall Satisfaction
    100%
    For the most part the classroom environment was great. Did have an issue with a link to the Lab environment on day 4. Very responsive to feedback

    Review by

    Posted on

  47. Course Quality
    80%
    Instructor was very knowledgeable and helpful with all of the course material.

    Review by

    Posted on

  48. Quality of Instructor
    80%
    Overall Satisfaction
    80%

    Review by

    Posted on

  49. Course Quality
    80%
    Overall Satisfaction
    80%

    Review by

    Posted on

  50. Course Quality
    80%
    Overall Satisfaction
    80%

    Review by

    Posted on

  51. Quality of Instructor
    80%

    Review by

    Posted on

  52. Quality of Instructor
    100%
    Course Quality
    80%
    Quality of Instructor
    80%

    Review by

    Posted on

  53. Overall Satisfaction
    100%

    Review by

    Posted on

  54. Course Quality
    80%
    Overall Satisfaction
    80%

    Review by

    Posted on

  55. Overall Satisfaction
    100%
    Jeff Rathjen is an outstanding instructor. He was able to teach to beginners like me without losing the more advanced students. I am unsure it was terrific training!

    Review by

    Posted on

  56. Course Quality
    80%
    Course Value
    80%
    Overall Satisfaction
    100%
    Labs were good example and maybe able to use to apply to real working environment. Provided sample of real working experiences. More examples of how the currently trends or situations in working environments.

    Review by

    Posted on

  57. Overall Satisfaction
    80%
    Training sessions recording will help us to replay if we missed anything during the class.

    Review by

    Posted on

  58. Course Quality
    80%
    Quality of Instructor
    80%
    Overall Satisfaction
    100%

    Review by

    Posted on

  59. Course Quality
    80%
    Overall Satisfaction
    100%

    Review by

    Posted on

  60. Course Quality
    60%
    Course Value
    80%
    Overall Satisfaction
    80%

    Review by

    Posted on

  61. Overall Satisfaction
    100%

    Review by

    Posted on

  62. Overall Satisfaction
    80%

    Review by

    Posted on

  63. Course Quality
    80%
    Overall Satisfaction
    100%

    Review by

    Posted on

  64. Overall Satisfaction
    100%
    Congenial, professional, good at driving individuals

    Review by

    Posted on

  65. Overall Satisfaction
    80%
    It is hard to use the lab environment.

    Review by

    Posted on

  66. Overall Satisfaction
    100%
    Jeff is an excellent Instructor and I enjoyed the class very much. I also learned a lot. He was very helpful and patient at explaining concepts that I found confusing. He was a great teacher

    Review by

    Posted on

  67. Overall Satisfaction
    100%
    The information and labs were spot on Gave really good examples to answer questions

    Review by

    Posted on

  68. Course Quality
    60%
    Overall Satisfaction
    80%

    Review by

    Posted on

  69. Overall Satisfaction
    100%

    Review by

    Posted on

  70. Quality of Instructor
    80%
    Overall Satisfaction
    100%

    Review by

    Posted on

  71. Overall Satisfaction
    100%

    Review by

    Posted on

  72. Overall Satisfaction
    100%

    Review by

    Posted on

  73. Overall Satisfaction
    100%

    Review by

    Posted on

  74. Course Quality
    80%
    Overall Satisfaction
    100%

    Review by

    Posted on

  75. Overall Satisfaction
    100%

    Review by

    Posted on

  76. Overall Satisfaction
    100%

    Review by

    Posted on

  77. Course Quality
    80%
    Overall Satisfaction
    100%

    Review by

    Posted on

  78. Course Quality
    80%
    Quality of Instructor
    80%
    Overall Satisfaction
    100%

    Review by

    Posted on

  79. Overall Satisfaction
    100%

    Review by

    Posted on

  80. Overall Satisfaction
    100%

    Review by

    Posted on

  81. Overall Satisfaction
    100%

    Review by

    Posted on

  82. Course Quality
    80%
    Overall Satisfaction
    80%

    Review by

    Posted on

  83. Overall Satisfaction
    100%

    Review by

    Posted on

  84. Overall Satisfaction
    100%
    I enjoyed Jeff's class. He is very knowledgeable and a great instructor.

    Review by

    Posted on

  85. Overall Satisfaction
    100%
    I wish we can have more in depth knowledge (theory) coved in the class, than the operation of the GUI. Jeff is knowledgable in the material and real work experience. in class training as an option.

    Review by

    Posted on

  86. Overall Satisfaction
    100%
    Jeff was fantastic at explaining many concepts with real world scenarios. You could tell that he wasn't simply regurgitating content from the book. It was obvious that is real world experience allowed him to provide a more thorough training experience.

    Review by

    Posted on

  87. Course Quality
    80%
    Overall Satisfaction
    100%
    Jeff was wonderful, considering he was not our assigned instructor. He jumped in immediately and we were lucky to learn from his experience. Funny and helpful. I would take more courses that he taught.

    Review by

    Posted on

  88. Overall Satisfaction
    100%

    Review by

    Posted on

  89. Quality of Instructor
    80%
    Overall Satisfaction
    80%
    Overall pleased with the courseware. If instructor gave an occasional relevant example of an issue they encountered in their career and how they resolved it. Even two or three of these during the week would be good.

    Review by

    Posted on

  90. Course Quality
    80%
    Overall Satisfaction
    100%

    Review by

    Posted on

  91. Overall Satisfaction
    100%

    Review by

    Posted on

  92. Overall Satisfaction
    100%

    Review by

    Posted on

  93. Course Value
    80%
    Overall Satisfaction
    100%

    Review by

    Posted on

  94. Course Quality
    80%
    Quality of Instructor
    80%
    Overall Satisfaction
    100%

    Review by

    Posted on

  95. Course Quality
    80%
    Overall Satisfaction
    100%

    Review by

    Posted on

  96. Course Value
    80%
    Overall Satisfaction
    100%
    Richard gave real world experiences that matter

    Review by

    Posted on

  97. Overall Satisfaction
    100%
    Richard is interesting to listen to

    Review by

    Posted on

  98. Overall Satisfaction
    100%
    Richard was interesting, entertaining, and conveyed concepts in a very clear manner.

    Review by

    Posted on

  99. Course Value
    60%
    Quality of Instructor
    80%
    Overall Satisfaction
    100%
    SQL Server is too big for someone to know everything.

    Review by

    Posted on

  100. Overall Satisfaction
    100%
    This is a great class for IT professionals. Instructor provided valuable historical and technological context not mentioned in textbook.

    Review by

    Posted on

  101. Course Quality
    80%
    Quality of Instructor
    80%
    Quality of Instructor
    60%
    Overall Satisfaction
    100%

    Review by

    Posted on

  102. Course Quality
    80%
    Overall Satisfaction
    80%

    Review by

    Posted on

  103. Overall Satisfaction
    100%

    Review by

    Posted on

  104. Overall Satisfaction
    80%

    Review by

    Posted on

  105. Course Quality
    80%
    Overall Satisfaction
    100%

    Review by

    Posted on

  106. Overall Satisfaction
    100%

    Review by

    Posted on

  107. Overall Satisfaction
    100%
    Labs and Lab environment are excellent, very satisfied. I cannot recommend any improvement at this time. Thank you! Instructor did an over the top, excellent job of making the class content relevant to real world applications. Awesome!

    Review by

    Posted on

  108. Course Quality
    80%
    Overall Satisfaction
    80%
    Richard was definitely able to bring real world examples and scenarios to the context.

    Review by

    Posted on

  109. Course Value
    80%
    Overall Satisfaction
    100%
    The information was very helpful. Understand this is a foundation for more learning and experience to build upon.

    Review by

    Posted on

  110. Overall Satisfaction
    100%
    Very knowledgeable and prepared well

    Review by

    Posted on

  111. Course Quality
    80%
    Overall Satisfaction
    80%

    Review by

    Posted on

  112. Course Quality
    80%
    Overall Satisfaction
    80%

    Review by

    Posted on

  113. Overall Satisfaction
    80%

    Review by

    Posted on

  114. Overall Satisfaction
    80%

    Review by

    Posted on

  115. Overall Satisfaction
    100%

    Review by

    Posted on

  116. Overall Satisfaction
    100%
    Good comfortable environments Good well pace presentation and labs. It shows that Jeff has done this before and knows the range of student skills and personalities I would have like to have this course condensed into three days

    Review by

    Posted on

  117. Course Quality
    80%
    Overall Satisfaction
    100%
    The instructor was very knowledgeable, helpful and carried out sessions in a very refreshing manner. It makes you always want to pay attention so that you don't miss anything. The course is excellent as it is.

    Review by

    Posted on

  118. Quality of Instructor
    60%
    Quality of Instructor
    60%
    The labs are very crucial to the learning environment, especially through online.

    Review by

    Posted on

  119. Course Quality
    80%
    Overall Satisfaction
    100%
    The Labs were really nice. I found it more helpful to do the lab while listening to his instruction. Jeff was a great instructor. really enjoyed it.

    Review by

    Posted on

  120. Overall Satisfaction
    100%

    Review by

    Posted on

  121. Overall Satisfaction
    100%

    Review by

    Posted on

  122. Overall Satisfaction
    100%

    Review by

    Posted on

  123. Overall Satisfaction
    100%
    Energized personality! Student looking to get back into SQL

    Review by

    Posted on

  124. Overall Satisfaction
    100%
    Excellent instructor. Provided explicit examples and very thorough on explaining the subject matter concepts.

    Review by

    Posted on

  125. Overall Satisfaction
    100%
    I appreciated Richard breadth and depth of SQL knowledge and ability to articulate the concepts

    Review by

    Posted on

  126. Overall Satisfaction
    100%

    Review by

    Posted on

click here