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-463 Implementing a Data Warehouse with Microsoft SQL Server 2012/2014 Certification Exam
Name
DBA-3110F2
Available Classes
Not currently offered.
Description Course Outline Requirements Intended Audience More Details
Intended Audience
Anyone who has wants to pass the 70-463 Implementing a Data Warehouse with Microsoft SQL Server 2012/2014 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-463 Implementing a Data Warehouse with 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 designing and implementing a data warehouse, extracting and transforming data, loading data, configuring and deploying SSIS solutions, and building data quality solutions. Classrooms will provide each student with a computer installed with software.
Course Objectives
  1. Design and implement dimensions and fact tables
  2. Define connection managers and manage SSIS package execution
  3. Design data flow, control flow
  4. Implement control flow, data flow, data load options, script tasks in SSIS, package logic by using SSIS variables and parameters, and script components in SSIS, auditing, logging, event handling, and master data management solutions
  5. Troubleshoot data integration issues
  6. Install and maintain SSIS components and data quality services
  7. Deploy SSIS solutions, configure SSIS security settings
  8. Create a data quality project to clean data
  9. Pass the 70-463 Implementing a Data Warehouse with Microsoft SQL Server 2012/2014 Certification Exam
Outline of Instruction
  1. Introduction
  2. Design and implement a data warehouse
  3. Extract and transform data
  4. Load data
  5. Configure and deploy SSIS solutions
  6. Build data quality solutions
  7. Practice
  8. 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. Design and implement a data warehouse
  2. Extract and transform data
  3. Load data
  4. Configure and deploy SSIS solutions
  5. Build data quality solutions
CE to CU Articulation
No
Prerequisites
Students should have some exposure to basic programming knowledge and skills, such as looping and branching and at least 2 years experience working with relational databases that should include: designing a normalized database, creating tables and relationships, querying with Transact-SQL.
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-463 Implementing a Data Warehouse with Microsoft SQL Server 2012/2014 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