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-461 Querying Microsoft SQL Server 2012/2014 Certification Exam
Name
DBA-3110D2
Available Classes
Not currently offered.
Description Course Outline Requirements Intended Audience More Details
Intended Audience
Anyone who has wants to pass the 70-461 Querying Microsoft SQL Server 2012/2014 Certification Exam 98-364 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-461 Querying Microsoft SQL Server 2012/2014 certification exam in order to measure and validate the candidate's technical skills and knowledge. Course content will cover all exam objectives, such as creating database objects, working with data, modifying data, and troubleshooting and optimizing. Classrooms will provide each student with a computer installed with software.
Course Objectives
  1. Create and alter tables using T-SQL syntax (simple statements), views (simple statements), DML triggers, create and modify constraints (simple statements), design views, stored procedures (simple statements)
  2. Query data by using SELECT statements, and query and manage XML data
  3. Implement sub-queries, data types, aggregate queries, error handling
  4. Modify data by using INSERT, UPDATE, and DELETE statements, combine datasets, and work with functions
  5. Optimize queries, manage transactions, and evaluate the use of row-based operations vs. set-based operations
  6. Pass the 70-461 Querying Microsoft SQL Server 2012/2014 Certification Exam 98-364
Outline of Instruction
  1. Introduction
  2. Create database objects
  3. Work with data
  4. Modify data
  5. Troubleshoot and optimize
  6. Practice
  7. 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. Understanding core database concepts
  2. Create database objects
  3. Work with data
  4. Modify data
  5. Troubleshoot and optimize
CE to CU Articulation
No
Prerequisites
Students should have a basic knowledge of the Microsoft Windows operating system, the Windows operating system core functions, and a working knowledge of 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-461 Querying Microsoft SQL Server 2012/2014 Certification Exam 98-364 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