MCSA: 70-462 Administering Microsoft SQL Server 2014 Databases (20462D)
This 5-day instructor led course is part of the MCSA SQL Server certification track. It provides students with the knowledge and skills to maintain a Microsoft SQL Server 2014 database. The course focuses on teaching individuals how to use SQL Server 2014 product features and tools related to maintaining a database. This course prepares students for exam 70-462.
MicroTrain offers Microsoft Certified instructors, in-classroom lessons and labs, supplemental training and study materials, and the MicroTrain Exam Pass Guarantee.
Who benefits from this course?
- Anyone pursuing MCSA SQL Server certification
- Anyone who is interested in learning how to administer and maintain SQL Server 2012 or SQL Server 2014
- Any individuals who have or desire roles that rely on databases and database administration
Prerequisites
About this Course
Upon successful completion of this course, students will be able to:
- Plan and install SQL Server 2014
- Configure SQL Server databases
- Describe SQL Server recovery models
- Back and restore databases
- Import and export data
- Authenticate and authorize users
- Use server and database roles
- Configure and assign permissions
- Use encryption and auditing
- Manage SQL Server Agent and jobs
- Configure security for SQL Server Agent
- Use PowerShell to manage SQL Server
- Configure Database Mail, alerts, and notifications
- Maintain databases
- Configure SQL Profiler and SQL Trace and use the Database Engine Tuning Advisor
- Monitor data by using Dynamic Management Views
Prerequisites
- Basic knowledge of the Microsoft Windows operating system and its core functionality.
- Working knowledge of Transact-SQL.
- Working knowledge of relational databases.
- Some experience with database design.
- 20461C: Querying Microsoft SQL Server 2014
Exam Details
Exam Pass Guarantee
At Microtrain we are committed to your success! Let us show you the return you get from great tech training. We will personally guarantee that if you take our class and follow our program you will be successfully certified!
Raves & Praise
Kaycee Ekufu
MCSA
The instructor [Al Khalfan] was very knowledgeable in the field. He presented the materials and concepts with a professional touch. He also frequently adds humor to his teachings, which made it easier for me to understand. The support staff was all nice, gentle, caring, and very helpful. The materials, rooms and amenities were excellent and exceeded expected standards.
David
A Cisco Success Story
I attended a resume writing seminar & conducted mock phone interviews with a Microtrain career counselor. These two activities gave me a leg up on distinguishing myself from all the other people looking for work. Since the career counselor's at Microtrain had a track record of getting people hired, their insight and positive past experiences helped me tremendously in getting hired with a Cisco Voice Systems Integrator in the Chicago area. I was hired as a Cisco Voice Tech Engineer with a starting salary of $65,000 / year with a Cisco voice systems reseller located in the Chicagoland area. Microtrain was very instramental in making this a reality. From expediting my WIA grant, to providing excellent hands-on training from knowledgable instructors I was able to achieve becoming certified with my CCNP. Microtrain's career services was the final catalyst in connecting me with this company by communicating with them on my behalf and with me in setting up the interview. One week later and I was hired. No joke. Thanks Microtrain!
Robert Graf
MCSA
Microtrain presents the course material in an interesting and concise manner. Microtrain gives the student all the resources necessary to pass the certification exams. Both the Chicago and Lombard facilities were excellent, and the staff goes to any length to accommodate any student changes.
Scott Wilson - Team Bradley
Employer Partner Feedback
Dawn has been a pleasure to work with. She is diligent in her efforts to give MicroTrain’s students the best opportunities to connect and network with various companies and players in the job market. The curriculums and certification programs are in line with today’s current IT needs. It’s good to see that they evolve with what employers are most seeking out there. I would recommend to any employer that hires skilled IT workers that they look into MicroTrain’s career services department as a potential source of candidates. The business of hiring can be quite costly, and Dawn and her staff provide a free service to outside companies. This value-add for MicroTrain’s students aligns with their mission in both training and job assistance to set up a win/win scenario for all involved.
D. Easter
PMP Certification Training, November 2008
Thanks Microtrain for conducting a great PMP course that set me on a successful path to obtain my PMP certification. I have passed the test!
Connect with MicroTrain
Begin building a successful long-term career pathway.