| 1. Introduction.mp4 | 1.9 MB | ||
| 1. Introduction.srt | 921.6 B | ||
| 1. Lesson Overview - The Source Data, the Transformation and Destination Table.mp4 | 90.9 MB | ||
| 1. Lesson Overview - The Source Data, the Transformation and Destination Table.srt | 17.6 KB | ||
| 1. What is SQL Server, SSMS and Visual Studio and how are they used.mp4 | 44.7 MB | ||
| 1. What is SQL Server, SSMS and Visual Studio and how are they used.srt | 9.5 KB | ||
| 10. Step 9 Test the Lesson 1 Package.mp4 | 17.8 MB | ||
| 10. Step 9 Test the Lesson 1 Package.srt | 2.3 KB | ||
| 10. What are Dimension Tables.mp4 | 8.9 MB | ||
| 10. What are Dimension Tables.srt | 2.6 KB | ||
| 11. The Star and Snowflake Schema.mp4 | 4.1 MB | ||
| 11. The Star and Snowflake Schema.srt | 1.2 KB | ||
| 2. Install SQL Server and SQL Server Management Studio (SSMS).mp4 | 44.7 MB | ||
| 2. Install SQL Server and SQL Server Management Studio (SSMS).srt | 5.4 KB | ||
| 2. Step 1 Create a New Integration Services Project.mp4 | 17.7 MB | ||
| 2. Step 1 Create a New Integration Services Project.srt | 3.6 KB | ||
| 2. What is a Data Warehouse.mp4 | 11.7 MB | ||
| 2. What is a Data Warehouse.srt | 3.5 KB | ||
| 2.1 SampleCurrencyData.txt | 45.3 KB | ||
| 3. Download and Restore AdventureWorks Database.mp4 | 32.2 MB | ||
| 3. Download and Restore AdventureWorks Database.srt | 4.8 KB | ||
| 3. Step 2 Add and Configure a Flat File Connection Manager.mp4 | 62.3 MB | ||
| 3. Step 2 Add and Configure a Flat File Connection Manager.srt | 8.8 KB | ||
| 3. Why do we need a Data Warehouse.mp4 | 8.2 MB | ||
| 3. Why do we need a Data Warehouse.srt | 3.8 KB | ||
| 4. Download Visual Studio Community.mp4 | 40.5 MB | ||
| 4. Download Visual Studio Community.srt | 4.2 KB | ||
| 4. Step 3 Add and Configure an OLE DB Connection Manager.mp4 | 16.2 MB | ||
| 4. Step 3 Add and Configure an OLE DB Connection Manager.srt | 2.7 KB | ||
| 4. What does a Data Warehouse look like.mp4 | 14.9 MB | ||
| 4. What does a Data Warehouse look like.srt | 2.7 KB | ||
| 5. Install the SQL Server Integration Services Extension.mp4 | 31.2 MB | ||
| 5. Install the SQL Server Integration Services Extension.srt | 3.4 KB | ||
| 5. Step 4 Add a Data Flow Task to the Package.mp4 | 12.3 MB | ||
| 5. Step 4 Add a Data Flow Task to the Package.srt | 1.8 KB | ||
| 5. The Ideal Data Warehouse.mp4 | 2.8 MB | ||
| 5. The Ideal Data Warehouse.srt | 1.9 KB | ||
| 6. Step 5 Add and Configure the Flat File Source.mp4 | 18.9 MB | ||
| 6. Step 5 Add and Configure the Flat File Source.srt | 2.7 KB | ||
| 6. The Difference Between OLTP and OLAP.mp4 | 5.2 MB | ||
| 6. The Difference Between OLTP and OLAP.srt | 2.6 KB | ||
| 6. Visual Studio Navigation Overview.mp4 | 40.2 MB | ||
| 6. Visual Studio Navigation Overview.srt | 6.7 KB | ||
| 7. Step 6 Add and Configure the Lookup Transformations.mp4 | 58.6 MB | ||
| 7. Step 6 Add and Configure the Lookup Transformations.srt | 7.5 KB | ||
| 7. What is Extract, Transform and Load (ETL).mp4 | 11.2 MB | ||
| 7. What is Extract, Transform and Load (ETL).srt | 3.4 KB | ||
| 8. Step 7 Add and Configure the OLE DB Destination.mp4 | 26.6 MB | ||
| 8. Step 7 Add and Configure the OLE DB Destination.srt | 3.3 KB | ||
| 8. What is Dimensional Modeling.mp4 | 11.9 MB | ||
| 8. What is Dimensional Modeling.srt | 4.3 KB | ||
| 9. Step 8 Make the Lesson 1 Package Easier to Understand.mp4 | 11.1 MB | ||
| 9. Step 8 Make the Lesson 1 Package Easier to Understand.srt | 1.2 KB | ||
| 9. What are Fact Tables.mp4 | 11.1 MB | ||
| 9. What are Fact Tables.srt | 3.8 KB | ||
| Bonus Resources.txt | 307.2 B | ||
| Get Bonus Downloads Here.url | 204.8 B | ||
| ▲ 57 total files | |||
Introduction to Data Warehousing
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 27 lectures (1h 48m) | Size: 529 MB
An introduction to data warehouses, using SQL Server 2019, SSMS, Visual Studio & SSIS. Covers topics in the 70-463 exam
What you'll learn:
Define and describe common data warehousing concepts
Install SQL Server, SSMS and Visual Studio with the SSIS package
Create an ETL package in SSIS
Integrate data from text files and databases
Requirements
A Windows computer or virtual machine with at least 2GB of RAM and about 10GB of hard drive space.
Description
This course is an overview of basic data warehousing concepts, a guide for installing software and a step-by-step tutorial on using the software. This course is divided into three main sections:
Data Warehousing Basics
https://TutGator.com
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 3 GB | freecoursewb | 2 weeks | 23 | 3 | |
| 992.4 MB | freecoursewb | 2 weeks | 6 | 3 | |
| 3.1 GB | freecoursewb | 4 weeks | 25 | 24 | |
| 3.8 GB | freecoursewb | 1 month | 4 | 5 | |
| 1.6 GB | freecoursewb | 1 month | 5 | 3 |
All Comments