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.
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)
Career & Salary Insight
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.
Our experts featured on QuickStart are driven by our ExpertConnect platform, a community of professionals focused on IT topics and discussions. Interact with these experts, create project opportunities, gain help and insights on questions you may have, and more.
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)
Overall Satisfaction
60%
Quality of Instructor
60%
Course Quality
60%
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.
Review byJustin
Posted on
Administering Microsoft SQL Server Databases (MS20462)
Overall Satisfaction
100%
Quality of Instructor
100%
Course Quality
100%
Clear and efficient learning.
Review byPatrick
Posted on
Course Quality
60%
Course Value
80%
Quality of Instructor
100%
Overall Satisfaction
100%
Appreciate with accommodating my time zone to attend the course.
Review byJenny Perkins
Posted on
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 coworkers to look into QuickStart IT courses.
Review byBoyd Newton
Posted on
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 byLena Bass
Posted on
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 handson practical howto was just right.
Review byRick Meyer
Posted on
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 byChristy Moody
Posted on
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 byMaureen Barker
Posted on
Course Quality
80%
Course Value
80%
Quality of Instructor
80%
Overall Satisfaction
80%
Overall a good class, very informative.
Review byLindsey Norton
Posted on
Course Quality
80%
Course Value
80%
Quality of Instructor
80%
Overall Satisfaction
80%
The course was good and very informative.
Review byErik Phillips
Posted on
Course Quality
100%
Course Value
100%
Quality of Instructor
100%
Overall Satisfaction
100%
Knowledgeable and friendly.
Review byKeith Schultz
Posted on
Course Quality
100%
Course Value
100%
Quality of Instructor
100%
Overall Satisfaction
100%
Fast registration process and knowledgeable instructors.
Review byLeah Jackson
Posted on
Course Quality
80%
Course Value
80%
Quality of Instructor
80%
Overall Satisfaction
60%
No issues.
Review byCharlie Rhodes
Posted on
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 byKenny Townsend
Posted on
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 byTricia Wagner
Posted on
Course Quality
80%
Course Value
60%
Quality of Instructor
80%
Overall Satisfaction
80%
Instruction is clear and easy to understand.
Review byAdam Gilbert
Posted on
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 byAlyssa Kelley
Posted on
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 byMelody Salinas
Posted on
Enjoyable
Course Quality
80%
Course Value
80%
Quality of Instructor
80%
Overall Satisfaction
100%
Review byRebecca Underwood
Posted on
Pleasing
Course Quality
80%
Quality of Instructor
80%
Overall Satisfaction
100%
Review byNathan Moreno
Posted on
Course Value
100%
Quality of Instructor
100%
Overall Satisfaction
100%
Review byRichard Davis
Posted on
Course Value
100%
Quality of Instructor
100%
Overall Satisfaction
100%
Review byMartin Partin
Posted on
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 byJennifer Jones
Posted on
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 byTeresa Oneil
Posted on
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 byDennis Mendoza
Posted on
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 byMyesha Lopez
Posted on
Course Value
100%
Quality of Instructor
100%
Overall Satisfaction
100%
Review byCharles Wilder
Posted on
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 byKathleen Torres
Posted on
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 byRochelle Jenkins
Posted on
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 byEddie Newlin
Posted on
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 byVickie Yoho
Posted on
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 byAustin Holton
Posted on
Overall Satisfaction
100%
Greatly appreciate the experience stories on 'why' certain topics are very important. N/A New Career Path
Review byIvan Hayes
Posted on
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 byHarriet Beardsley
Posted on
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 byMartin Sprankle
Posted on
Course Quality
80%
Quality of Instructor
80%
Overall Satisfaction
80%
Review byCurtis Mendez
Posted on
Overall Satisfaction
100%
Easy to understand, and good training workflow.
Review byMatthew Lucas
Posted on
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 byJohnathon Neal
Posted on
Quality of Instructor
80%
Overall Satisfaction
100%
Review byGladys Dulaney
Posted on
Quality of Instructor
100%
It was as required for the course. Fine!
Review byElizabeth Goodwin
Posted on
Overall Satisfaction
80%
Review byAndre Weaver
Posted on
Overall Satisfaction
100%
Review byFrederick Korte
Posted on
Quality of Instructor
60%
Quality of Instructor
60%
Overall Satisfaction
80%
Review byWilliam Reeves
Posted on
Course Quality
60%
Overall Satisfaction
80%
Review byEddie Martini
Posted on
Overall Satisfaction
80%
Excellent instructor and very helpful
Review byHoward Person
Posted on
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 byRichard Johnson
Posted on
Course Quality
80%
Instructor was very knowledgeable and helpful with all of the course material.
Review byCarlene Romig
Posted on
Quality of Instructor
80%
Overall Satisfaction
80%
Review byFred Gerard
Posted on
Course Quality
80%
Overall Satisfaction
80%
Review byAnn Taylor
Posted on
Course Quality
80%
Overall Satisfaction
80%
Review byEstella Hall
Posted on
Quality of Instructor
80%
Review byNathan Aleman
Posted on
Quality of Instructor
100%
Course Quality
80%
Quality of Instructor
80%
Review byCarolyn Caudill
Posted on
Overall Satisfaction
100%
Review byRandi Evans
Posted on
Course Quality
80%
Overall Satisfaction
80%
Review byRachel Hunter
Posted on
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 byTiffany Rodriquez
Posted on
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 byJohn Delbosque
Posted on
Overall Satisfaction
80%
Training sessions recording will help us to replay if we missed anything during the class.
Review byMariana Nadler
Posted on
Course Quality
80%
Quality of Instructor
80%
Overall Satisfaction
100%
Review byJohn Palm
Posted on
Course Quality
80%
Overall Satisfaction
100%
Review byLisa Puckett
Posted on
Course Quality
60%
Course Value
80%
Overall Satisfaction
80%
Review byJames Johnson
Posted on
Overall Satisfaction
100%
Review byGwendolyn Laster
Posted on
Overall Satisfaction
80%
Review byJerrie Engel
Posted on
Course Quality
80%
Overall Satisfaction
100%
Review byGary Sandy
Posted on
Overall Satisfaction
100%
Congenial, professional, good at driving individuals
Review byThomas Faulkner
Posted on
Overall Satisfaction
80%
It is hard to use the lab environment.
Review byPhil Green
Posted on
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 byAnne Hunt
Posted on
Overall Satisfaction
100%
The information and labs were spot on Gave really good examples to answer questions
Review byLynn Ross
Posted on
Course Quality
60%
Overall Satisfaction
80%
Review byChristina Johnson
Posted on
Overall Satisfaction
100%
Review byArturo Odom
Posted on
Quality of Instructor
80%
Overall Satisfaction
100%
Review byJames Alvord
Posted on
Overall Satisfaction
100%
Review byWilliam Jones
Posted on
Overall Satisfaction
100%
Review byCornelius Flowers
Posted on
Overall Satisfaction
100%
Review byJohn Jack
Posted on
Course Quality
80%
Overall Satisfaction
100%
Review byCharles Donelson
Posted on
Overall Satisfaction
100%
Review byJason Andersen
Posted on
Overall Satisfaction
100%
Review byAlma Green
Posted on
Course Quality
80%
Overall Satisfaction
100%
Review byMae Hall
Posted on
Course Quality
80%
Quality of Instructor
80%
Overall Satisfaction
100%
Review byPatrick Fagan
Posted on
Overall Satisfaction
100%
Review byJohn Adams
Posted on
Overall Satisfaction
100%
Review byKris Ortega
Posted on
Overall Satisfaction
100%
Review byJohn Oliver
Posted on
Course Quality
80%
Overall Satisfaction
80%
Review byAnn Kirk
Posted on
Overall Satisfaction
100%
Review byKelsey Choice
Posted on
Overall Satisfaction
100%
I enjoyed Jeff's class. He is very knowledgeable and a great instructor.
Review byChristopher Wagner
Posted on
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 byRichard Harrell
Posted on
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 byMilissa Buse
Posted on
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 byWilliam Cox
Posted on
Overall Satisfaction
100%
Review byJames Brizendine
Posted on
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 byJamie Garibay
Posted on
Course Quality
80%
Overall Satisfaction
100%
Review byDanette Wright
Posted on
Overall Satisfaction
100%
Review byCaroline Dawson
Posted on
Overall Satisfaction
100%
Review byRuby McLean
Posted on
Course Value
80%
Overall Satisfaction
100%
Review byPaula Elizondo
Posted on
Course Quality
80%
Quality of Instructor
80%
Overall Satisfaction
100%
Review byKristine Shire
Posted on
Course Quality
80%
Overall Satisfaction
100%
Review byJoan Firth
Posted on
Course Value
80%
Overall Satisfaction
100%
Richard gave real world experiences that matter
Review byPhillip Boyles
Posted on
Overall Satisfaction
100%
Richard is interesting to listen to
Review byGlenn Kimzey
Posted on
Overall Satisfaction
100%
Richard was interesting, entertaining, and conveyed concepts in a very clear manner.
Review byJanet Johnson
Posted on
Course Value
60%
Quality of Instructor
80%
Overall Satisfaction
100%
SQL Server is too big for someone to know everything.
Review byHermina Stevens
Posted on
Overall Satisfaction
100%
This is a great class for IT professionals. Instructor provided valuable historical and technological context not mentioned in textbook.
Review byHeidi Meyers
Posted on
Course Quality
80%
Quality of Instructor
80%
Quality of Instructor
60%
Overall Satisfaction
100%
Review byBryan Hillyard
Posted on
Course Quality
80%
Overall Satisfaction
80%
Review byFrances Fultz
Posted on
Overall Satisfaction
100%
Review byBrandon Maffei
Posted on
Overall Satisfaction
80%
Review byKimberly Foster
Posted on
Course Quality
80%
Overall Satisfaction
100%
Review byVincent Boyd
Posted on
Overall Satisfaction
100%
Review byEdna Oakley
Posted on
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 byJean Mosby
Posted on
Course Quality
80%
Overall Satisfaction
80%
Richard was definitely able to bring real world examples and scenarios to the context.
Review byElla Borrego
Posted on
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 byRosa Walker
Posted on
Overall Satisfaction
100%
Very knowledgeable and prepared well
Review byMichael Teneyck
Posted on
Course Quality
80%
Overall Satisfaction
80%
Review byJoyce Sullivan
Posted on
Course Quality
80%
Overall Satisfaction
80%
Review byWayne Kull
Posted on
Overall Satisfaction
80%
Review byMollie Gonzalez
Posted on
Overall Satisfaction
80%
Review bySalvatore Clevenger
Posted on
Overall Satisfaction
100%
Review byGary Thresher
Posted on
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 bySarah Hatfield
Posted on
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 byPaulette Hanks
Posted on
Quality of Instructor
60%
Quality of Instructor
60%
The labs are very crucial to the learning environment, especially through online.
Review byExie Prater
Posted on
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 byCorrinne Hart
Posted on
Overall Satisfaction
100%
Review bySusan Page
Posted on
Overall Satisfaction
100%
Review byRenee Casper
Posted on
Overall Satisfaction
100%
Review byAnthony Larson
Posted on
Overall Satisfaction
100%
Energized personality! Student looking to get back into SQL
Review byLawrence Baldridge
Posted on
Overall Satisfaction
100%
Excellent instructor. Provided explicit examples and very thorough on explaining the subject matter concepts.
Review byKeith Simmons
Posted on
Overall Satisfaction
100%
I appreciated Richard breadth and depth of SQL knowledge and ability to articulate the concepts