در این آموزش تصویری با مباحث مربوط به گواهینامه Microsoft SQL Server 2012 آزمون 70-463 آشنا می شوید.

این دوره آموزشی محصول موسسه Infiniteskills است.

سرفصل های این دوره:

  • پیاده سازی Data Flow
  • عیب یابی SSIS
  • حذف داده ها
  • برنامه نویسی و SSIS
  • استفاده از PowerPivot و Data Warehouse
  • مفاهیم Data Warehouse
  • آشنایی با Data Warehousing 2012
  • طراحی و پیاده سازی Data Warehousing
  • طراحی و پیاده سازی طرح Data Warehousing
  • طراحی فیزیکی Data Warehouse
  • طراحی منطقی Data Warehouse
  • پیاده سازی طرح Data Warehouse
  • راه حل برای اجرای طرح Data Warehouse
  • اجرای  Data Flow
  • پیاده سازی پکیج SSIS
  • اجرای پکیج SSIS
  • Control Flows و پکیج SSIS
  • اشکال زدایی و رفع عیب پکیج SSIS
  • Error Handling و SSIS
  • افزایش ETL
  • استخراج داده های اصلاح شده
  • تعیین کیفیت داده ها
  • خدمات داده ها
  • توسعه SSIS
  • برنامه نویسی و SSIS
  • اجرای پکیج SSIS
  • توسعه پکیج SSIS
  • داده های مصرفی
  • استفاده از PowerPivot و Data Warehouse
  • Data Warehouse و SSRS
  • استفاده از Excel و PowerPivot
  • Master Data چیست؟
  • پیاده سازی سرویس Master Data

عنوان دوره: Infiniteskills Microsoft SQL Server 2012 Certification – Exam 70-463 Training Video

نویسنده: Steve Hamilton

مدت دوره: 7 ساعت و 61 دقیقه

Microsoft SQL Server 2012 Certification - Exam 70-463 Training Video

n this SQL Server 70-463 Exam training course, expert Steve Hamilton will teach you everything you need to know to pass the Implementing a Data Warehouse with Microsoft SQL Server 2012 test. It is required that you pass the 70-463 exam in order to achieve your MCSA and MCSE certifications from Microsoft.

Steve Hamilton takes you through each of the topics that you will have to master to pass the SQL Server 2012 70-463 exam. Throughout this tutorial video, you will learn how to design and implement a data warehouse, extract and transform data, load data, configure and deploy SSIS solutions and build data quality solutions. Each topic is broken down into step-by-step lessons, allowing you to learn quickly, and retain what you learn more effectively.

Once you have completed this video based training course for the Microsoft SQL Server 70-463 Exam, you will have a comprehensive understanding of how to Implement a Data Warehouse with SQL Server 2012. You will be fully prepared to write, and pass, your 70-463 exam and continue towards earning your MCSA and MCSE certifications.

What You Will Learn
Learn About Me
Data Warehouse Challenges - Physical
Implementing A Data Flow - Part 1
Debugging SSIS
Data Cleansing
Data Quality Services
Scripting And SSIS - Part 1
Using PowerPivot And Data Warehouse
01. Introduction Data Warehousing 2012
0101 What You Will Learn
0102 Data Warehouse Concepts And Architecture
0103 Data Warehouse Solutions
02. Data Warehouse Hardware
0201 Data Warehouse Challenges - Memory
0202 Data Warehouse Challenges - Physical
0203 Data Warehouse Architectures
0204 Data Warehouse Appliances
03. Designing And Implementing A Data Warehouse
0301 Data Warehouse Logical Design
0302 Data Warehouse Physical Design
0303 Exercise: Implementing A Data Warehouse Schema
0304 Solution For Implementing A Data Warehouse Schema
04. Design And Implement A Data Warehouse Schema
0401 ETL And SSIS
0402 Defining A Data Source
0403 Implementing A Data Flow - Part 1
0404 Implementing A Data Flow - Part 2
0405 Exercise: Implementing A SSIS Package
0406 Solution For Implementing A SSIS Package
05. Control Flows And SSIS Package
0501 Introduction To Control Flows
0502 Dynamic Packages
0503 Defining Containers - Part 1
0504 Defining Containers - Part 2
0505 Manage Consistency
0506 Exercise: Implement Control Flows In SSIS
0507 Solution For Implementing Control Flow SSIS
06. Debugging And Troubleshooting SSIS Packages
0601 Debugging SSIS
0602 Error Log Providers
0603 Error Handling And SSIS - Part 1
0604 Error Handling And SSIS - Part 2
0605 Exercise: Debugging And Troubleshooting SSIS
0606 Solution For Debugging And Troubleshooting SSIS
07. Incremental ETL Process
0701 Introduction To Incremental ETL Processes
0702 Extract Modified Data - Part 1
0703 Extract Modified Data - Part 2
0704 Load Modified Data
0705 Exercise: Load Incremental Data
0706 Solution For Incremental Load
08. Enforcing Data Quality
0801 Data Cleansing
0802 Data Quality Services
0803 Data Quality Services And Matching Data
0804 Exercise Cleansing Data
0805 Solution For Cleansing Data
0806 Exercise: De-Duplicating Data
0807 Solution For De-Duplicating Data
09. Master Data Services
0901 What Is Master Data Services
0902 Implementing Master Data Services
0903 Excel Add-In For Master Data Services
10. Extending SSIS
1001 Custom SSIS Components
1002 Scripting And SSIS - Part 1
1003 Scripting And SSIS - Part 2
11. Deploying SSIS Packages
1101 Overview Of SSIS Deployment
1102 Deploying SSIS Packages - Part 1
1103 Deploying SSIS Packages - Part 2
1104 Planning SSIS Package Execution
1105 Exercise: Deploying An SSIS Package
1106 Solution For Deploying SSIS Package
12. Consuming Data
1201 Data Warehouse Using Excel
1202 Using PowerPivot And Data Warehouse
1203 Data Warehouse And SSRS
1204 Exercise: Using Excel And PowerPivot
1205 Solution For Excel And PowerPivot
13. About The Author
1301 Learn About Me