Information Technology

The Non-Credit Computer Education Department delivers basic and advanced technology training leading to employment, and for personal enrichment. 

IT Certifications   See all Computer Courses

  • CompTIA, Cisco, Cybersecurity, Open Technologies
  • Office Technology
  • Accounting Technology
  • Drafting and Computer-Aided Design (CAD)
  • Professional Skills Development (1 to 3-day classes)
  • Software Programming
  • Web Design and Development
  • Database Administration

Course Details & Registration Information

Course
70-462 Administering Microsoft SQL Server 2012/2014 Databases Certification Exam
Name
DBA-3110C2
Available Classes
Not currently offered.
Description Course Outline Requirements Intended Audience More Details
Intended Audience
Anyone who has wants to pass the 70-462 Administering Microsoft SQL Server 2012/2014 Databases certification exam who is seeking to evidence technical knowledge and skills regarding SQL Server 2012 or SQL Server 2014.
Description
Learners who take and pass this certification can use it as credit towards obtaining a Microsoft Certified Professional (MCP), Microsoft Certified Solutions Associate (MCSA), or Microsoft Certified Systems Engineer (MCSE) certification program. In this course, students will be prepared to pass the 70-462 Administering Microsoft SQL Server 2012/2014 Databases certification exam in order to measure and validate the candidate's technical skills and knowledge. Course content will cover all exam objectives, such as installing and configuring, maintaining instances and databases, optimizing and troubleshooting, managing data, implementing security, and implementing high availability. Classrooms will provide each student with a computer installed with software.
Course Objectives
  1. Know how to design an installation plan
  2. Install SQL Server and related services, implement a migration strategy, configure additional SQL Server components, and manage SQL Server Agent
  3. Manage and configure databases, configure SQL Server instances, implement a SQL Server clustered instance, and manage SQL Server instances
  4. Identify and resolve concurrency problems, collect and analyze troubleshooting data, audit SQL Server instances
  5. Configure and maintain a back-up strategy, restore databases, implement and maintain indexes, and import and export data
  6. Manage logins, server roles, database security, users, database roles, and troubleshoot security
  7. Implement AlwaysOn and replication
  8. Pass the 70-461 Querying Microsoft SQL Server 2012/2014 Certification Exam 98-364
Outline of Instruction
  1. Introduction
  2. Install and configure
  3. Maintain instances and databases
  4. Optimize and troubleshoot
  5. Manage data
  6. Implement security
  7. Implement high availability
  8. Practice
  9. Exam certification
Contact Hours
36
CEU's
3.6
Industry Standard, State, or National Certification
Yes
Certification
Microsoft
Website URL
http://www.microsoft.com
Certification Learning Outcomes/Requirements
  1. Install and configure
  2. Maintain instances and databases
  3. Optimize and troubleshoot
  4. Manage data
  5. Implement security
  6. Implement high availability
CE to CU Articulation
No
Prerequisites
Students should have a basic knowledge of the Microsoft Windows operating system, the Windows operating system core functions, experience with database design, and a working knowledge of Transact-SQL and relational databases.
Text and Supplies Needed
One 64GB USB flash drive (Optional)
Clinical Site/Special Facilities
Requirements for Successful Completion of this Course
  1. Attendance 90% or above
  2. Participation
  3. Requirements for successful completion of a NON-CERTIFICATION CLASSES:
    Demonstrate an understanding of at least 70% of course material taught. If a student has extenuating circumstances causing absences greater than 10% of the class time, the student must make arrangements with the instructor to provide evidence of keeping up with the class material and making up the work, exercises, and projects missed; or demonstrate competency in the course objectives. Students with irregular attendance, less than 90% attendance, or is unable to demonstrate competency will receive a grade of NG (no grade).

    Requirements for successful completion of CERTIFICATION CLASSES:
    Students are required to take AND pass the official course certification exam before the class program ends AND provide visual evidence of successfully passing the official course certification exam to the course teaching faculty. Students who do not pass the official course certification exam, will not receive a class certificate AND will receive a grade of NG (no grade).

  4. Refund requests and withdrawals must be made in writing by the student (NO EXCEPTIONS).
    o A 100-percent refund shall be made if the student officially withdraws from the class before the first class meeting by submitting a written request.
    o A 75-percent refund shall be made if the student officially withdraws from the class prior to or on the 10-percent date of scheduled hours.
    o Provided that the class has not completed the 10-percent scheduled hours.
    o Community school, facility, and lab fees are not refundable.
    o A full refund shall be made for classes cancelled by the college.
    o You do not have to request a refund.


    NOTE:
    All refunds are sent from the State of North Carolina as checks to the address on file. Please be sure that your address is correct. If you need to update your address or any other information, please complete a change form well in advance of your refund, using the Wake Tech Permanent Change Form 728. It can take up to six weeks to get a refund check for a class. By law, Wake Technical Community College must submit all monies collected to the State of North Carolina. Wake Technical Community College does not keep money on hand for refunds.

  5. Transfer requests must be in writing by the student (NO EXCEPTIONS)
    o Requests received after the 10-percent deadline will not be considered, and a refund will not be processed.
    o Transfers to a different course in the same semester are allowed up to the 10-percent point of the total number of hours for both classes.
    o A student may not transfer to a course that has passed the 10-percent point.
    o Transfers from one semester to another are not allowed.
    o Anyone with questions concerning refunds or transfers should call 919-866-5800.
Accreditation/Special Approval Requirements
Intended Audience
Anyone who has wants to pass the 70-462 Administering Microsoft SQL Server 2012/2014 Databases certification exam who is seeking to evidence technical knowledge and skills regarding SQL Server 2012 or SQL Server 2014.
Specific Industry or Business Support Needs
Industry or Job Titles Related to training Outcomes for Employment
Related Courses
Course Contact Information
Latisha Alford
919-532-5955