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
Certificate
{{startDate}}
9:00 AM - 5:00 PM CST
Duration - 0 Days -
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.
Practice Certification Exam
Exam Test Sample:70-462 Administering Microsoft SQL Server Databases
More Information
| Brand | Microsoft |
|---|---|
| Subjects | IT Ops & Management |
| Lab Access | Yes |
| Technology | Microsoft |
| Learning Style | Virtual Classroom |
| Learning Type | Course |
| Difficulty | Intermediate |
| Course Duration | 5 Days |
| Language | English |
| SATV Value | 5 |
| VPA Discount | VPA Discount |
Reviews
Write Your Own Review
Related Courses
Analyzing Data with Microsoft SQL Server Reporting Services (MS-10990)
- Virtual Classroom
- 5 Days
$2,995.00
Administering a Microsoft SQL Server Database Infrastructure (MS-20764)
- Virtual Classroom
- 5 Days
$2,995.00
Course Expert:
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
-
Administering Microsoft SQL Server Databases (MS20462)My lecture instructor was great, the lab instructor was essentially nonexistent. 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.
Posted on
-
Administering Microsoft SQL Server Databases (MS20462)Clear and efficient learning.
Posted on
-
Appreciate with accommodating my time zone to attend the course.
Posted on
-
Online classes are great and accommodating with different time zones. Will definitely recommend to my fellow coworkers to look into QuickStart IT courses.
Posted on
-
Abdulah was easy to follow and efficient in covering the material. He seems to know the material vey well.
Posted on
-
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 handson practical howto was just right.
Posted on
-
Overall the class provided information that will help with my current job needs.
Posted on
-
Abdullah was very informative and was able to incorporate real world examples I asked about.
Posted on
-
Overall a good class, very informative.
Posted on
-
The course was good and very informative.
Posted on
-
Knowledgeable and friendly.
Posted on
-
Fast registration process and knowledgeable instructors.
Posted on
-
No issues.
Posted on
-
I like that he was able to answer questions and was very knowledgeable; he knows the material he is teaching.
Posted on
-
Trying out the one year access and I really like it. I think it is worth the money and time.
Posted on
-
Instruction is clear and easy to understand.
Posted on
-
The class is a good instruction and hope there are more interactions between instructors and students during the instructions.
Posted on
-
Excellent materialHighly recommend him to other future students I wish we an extended time to use the lab even after the class is over.
Posted on
-
Enjoyable
Posted on
-
Pleasing
Posted on
-
Posted on
-
Posted on
-
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.
Posted on
-
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.
Posted on
-
The instructor's lectures were very clear. I have worked over 10 years in the IT industry when taking this training.
Posted on
-
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.
Posted on
-
Posted on
-
Instructor had good real world SQL knowledge I have worked over 10 years in the IT industry when taking this training.
Posted on
-
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.
Posted on
-
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.
Posted on
-
Overall the instructor was very good I have worked over 10 years in the IT industry when taking this training.
Posted on
-
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.
Posted on
-
Greatly appreciate the experience stories on 'why' certain topics are very important. N/A New Career Path
Posted on
-
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.
Posted on
-
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.
Posted on
-
Posted on
-
Easy to understand, and good training workflow.
Posted on
-
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
Posted on
-
Posted on
-
It was as required for the course. Fine!
Posted on
-
Posted on
-
Posted on
-
Posted on
-
Posted on
-
Excellent instructor and very helpful
Posted on
-
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
Posted on
-
Instructor was very knowledgeable and helpful with all of the course material.
Posted on
-
Posted on
-
Posted on
-
Posted on
-
Posted on
-
Posted on
-
Posted on
-
Posted on
-
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!
Posted on
-
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.
Posted on
-
Training sessions recording will help us to replay if we missed anything during the class.
Posted on
-
Posted on
-
Posted on
-
Posted on
-
Posted on
-
Posted on
-
Posted on
-
Congenial, professional, good at driving individuals
Posted on
-
It is hard to use the lab environment.
Posted on
-
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
Posted on
-
The information and labs were spot on Gave really good examples to answer questions
Posted on
-
Posted on
-
Posted on
-
Posted on
-
Posted on
-
Posted on
-
Posted on
-
Posted on
-
Posted on
-
Posted on
-
Posted on
-
Posted on
-
Posted on
-
Posted on
-
Posted on
-
Posted on
-
Posted on
-
I enjoyed Jeff's class. He is very knowledgeable and a great instructor.
Posted on
-
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.
Posted on
-
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.
Posted on
-
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.
Posted on
-
Posted on
-
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.
Posted on
-
Posted on
-
Posted on
-
Posted on
-
Posted on
-
Posted on
-
Posted on
-
Richard gave real world experiences that matter
Posted on
-
Richard is interesting to listen to
Posted on
-
Richard was interesting, entertaining, and conveyed concepts in a very clear manner.
Posted on
-
SQL Server is too big for someone to know everything.
Posted on
-
This is a great class for IT professionals. Instructor provided valuable historical and technological context not mentioned in textbook.
Posted on
-
Posted on
-
Posted on
-
Posted on
-
Posted on
-
Posted on
-
Posted on
-
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!
Posted on
-
Richard was definitely able to bring real world examples and scenarios to the context.
Posted on
-
The information was very helpful. Understand this is a foundation for more learning and experience to build upon.
Posted on
-
Very knowledgeable and prepared well
Posted on
-
Posted on
-
Posted on
-
Posted on
-
Posted on
-
Posted on
-
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
Posted on
-
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.
Posted on
-
The labs are very crucial to the learning environment, especially through online.
Posted on
-
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.
Posted on
-
Posted on
-
Posted on
-
Posted on
-
Energized personality! Student looking to get back into SQL
Posted on
-
Excellent instructor. Provided explicit examples and very thorough on explaining the subject matter concepts.
Posted on
-
I appreciated Richard breadth and depth of SQL knowledge and ability to articulate the concepts
Posted on
-
Posted on
