MCSA Implementing a Data Warehouse with Microsoft SQL Server 2012/2014 Video Course

70-463: MCSA Implementing a Data Warehouse with Microsoft SQL Server 2012/2014

Your Microsoft 70-463 exam is just around the corner, right? So, it's high time to find an effective preparation tool! Our training course is what you really need! This is a series of videos led by the experienced IT instructors who will provide you with a detailed overview of the 70-463 certification test. Ace your Microsoft 70-463 at the first attempt and obtain the MCSA Implementing a Data Warehouse with Microsoft SQL Server 2012/2014 credential with ease.

# of Students
105
# of Lectures
60
Course Length
6 h
Course Rating
4.5
Price $32.99
Today $29.99

Curriculum for 70-463 Video Course

Introduction Data Warehousing 2012

  Video Name Time
  1. What You Will Learn 03:06
  2. Data Warehouse Concepts And Architecture 05:10
  3. Data Warehouse Solutions 05:07
  Video Name Time
  1. Data Warehouse Challenges - Memory 06:20
  2. Data Warehouse Challenges - Physical 04:52
  3. Data Warehouse Architectures 07:13
  4. Data Warehouse Appliances 04:03
  Video Name Time
  1. Data Warehouse Logical Design 07:19
  2. Data Warehouse Physical Design 08:28
  3. Exercise: Implementing A Data Warehouse Schema 02:05
  4. Solution For Implementing A Data Warehouse Schema 06:19
  Video Name Time
  1. ETL And SSIS 10:14
  2. Defining A Data Source 07:32
  3. Implementing A Data Flow - Part 1 08:14
  4. Implementing A Data Flow - Part 2 09:03
  5. Exercise: Implementing A SSIS Package 03:38
  6. Solution For Implementing A SSIS Package 06:05
  Video Name Time
  1. Introduction To Control Flows 09:48
  2. Dynamic Packages 11:07
  3. Defining Containers - Part 1 06:55
  4. Defining Containers - Part 2 07:35
  5. Manage Consistency 06:19
  6. Exercise: Implement Control Flows In SSIS 02:51
  7. Solution For Implementing Control Flow SSIS 04:18
  Video Name Time
  1. Debugging SSIS 09:35
  2. Error Log Providers 07:38
  3. Error Handling And SSIS - Part 1 07:57
  4. Error Handling And SSIS - Part 2 05:25
  5. Exercise: Debugging And Troubleshooting SSIS 02:53
  6. Solution For Debugging And Troubleshooting SSIS 04:38
  Video Name Time
  1. Introduction To Incremental ETL Processes 09:50
  2. Extract Modified Data - Part 1 09:26
  3. Extract Modified Data - Part 2 07:09
  4. Load Modified Data 09:45
  5. Exercise: Load Incremental Data 05:09
  6. Solution For Incremental Load 09:57
  Video Name Time
  1. Data Cleansing 07:22
  2. Data Quality Services 06:55
  3. Data Quality Services And Matching Data 09:04
  4. Exercise Cleansing Data 04:30
  5. Solution For Cleansing Data 09:12
  6. Exercise: De-Duplicating Data 05:31
  7. Solution For De-Duplicating Data 09:42
  Video Name Time
  1. What Is Master Data Services 07:54
  2. Implementing Master Data Services 09:18
  3. Excel Add-In For Master Data Services 07:33
  Video Name Time
  1. Custom SSIS Components 05:43
  2. Scripting And SSIS - Part 1 07:17
  3. Scripting And SSIS - Part 2 08:17
  Video Name Time
  1. Overview Of SSIS Deployment 08:08
  2. Deploying SSIS Packages - Part 1 07:16
  3. Deploying SSIS Packages - Part 2 09:16
  4. Planning SSIS Package Execution 08:40
  5. Exercise: Deploying An SSIS Package 03:31
  6. Solution For Deploying SSIS Package 06:41
  Video Name Time
  1. Data Warehouse Using Excel 08:31
  2. Using PowerPivot And Data Warehouse 08:05
  3. Data Warehouse And SSRS 08:06
  4. Exercise: Using Excel And PowerPivot 03:02
  5. Solution For Excel And PowerPivot 05:38

Student Feedback

5 Stars
4 Stars
3 Stars
2 Stars
1 Star
4.5
Rating: 4.5
Overall Rating: Good.

Similar Courses

Only Registered Members can View Training Courses

Please fill out your email address below in order to view Training Courses. Registration is Free and Easy, You Simply need to provide an email address.

  • Trusted by 1.2M IT Certification Candidates Every Month
  • Hundreds Hours of Videos
  • Instant download After Registration

Already Member? Click here to Login

A confirmation link will be sent to this email address to verify your login

1200+ IT Certification Exams available: Get a free sample of any exam right now!
Try Free Demo

Try Free Demo

  • ABA
  • ACAMS
  • ACFE
  • ACI
  • ACSM
  • Adobe
  • AHIMA
  • AHIP
  • AHLEI
  • AICPA
  • AIWMI
  • Alfresco
  • AMA
  • Amazon
  • AndroidATC
  • APBM
  • API
  • APICS
  • Apple
  • Arista
  • Aruba
  • ASIS
  • ASQ
  • Atlassian
  • Autodesk
  • Avaya
  • Axis Communications
  • BACB
  • BCS
  • BICSI
  • Blockchain
  • Blue Coat
  • Blue Prism
  • Brocade
  • C++ Institute
  • CA Technologies
  • Checkpoint
  • CIMA
  • Cisco
  • Citrix
  • CIW
  • Cloudera
  • CompTIA
  • CSA
  • CWNP
  • CyberArc
  • Dell
  • DMI
  • DSCI
  • ECCouncil
  • EMC
  • Esri
  • Exin
  • Extreme Networks
  • F5
  • FileMaker
  • FINRA
  • Fortinet
  • GAQM
  • GARP
  • Genesys
  • GIAC
  • Google
  • Guidance Software
  • H3C
  • HFMA
  • HIPAA
  • Hitachi
  • HP
  • HRCI
  • Huawei
  • IAPP
  • IBM
  • IFPUG
  • IIA
  • IIBA
  • Informatica
  • Isaca
  • iSAQB
  • ISC
  • iSQI
  • ISTQB
  • ITIL
  • Juniper
  • Linux Foundation
  • Logical Operations
  • LPI
  • Magento
  • Marketo
  • McAfee
  • Microsoft
  • Mulesoft
  • NACVA
  • NCMA
  • Network Appliance
  • NI
  • Nokia
  • Novell
  • Nuage Networks
  • OMG
  • Palo Alto Networks
  • Pegasystems
  • PEOPLECERT
  • PMI
  • PRINCE2
  • Python Institute
  • QlikView
  • RedHat
  • Riverbed
  • RSA
  • Salesforce
  • SANS
  • SAP
  • SAS Institute
  • Scrum
  • SDI
  • ServiceNow
  • Six Sigma
  • SNIA
  • SOA
  • Software Certifications
  • SolarWinds
  • Splunk
  • SpringSource
  • Symantec
  • The Open Group
  • Tibco
  • VCE
  • Veeam
  • Veritas
  • Vmedu
  • VMware
  • WatchGuard
  • WorldatWork
  • Zend
Next Step
Next Step

Try Free Demo

  • Microsoft
Next Step
Next Step

Summer Sale! Get 25% Discount on All Your Purchases!

Passguide Products

Enter Your Email Address to Receive Your 25%
OFF
Discount Code Plus... Our Exclusive Weekly Deals

* We value your privacy. We will not rent or sell your email address