Oreilly - SQL Server 70-767: Implementing a Data Warehouse Using SQL - 9780135224779
Oreilly - SQL Server 70-767: Implementing a Data Warehouse Using SQL
by Scot J. Reagin | Released July 2018 | ISBN: 0135224772


8+ Hours of Video Instruction Prepare for Microsoft Exam 70-767: Implementing a Data Warehouse Using SQL, and develop practical skills to design, configure, and manage a data warehouse with SQL Server Overview In this video training, Scot Reagin couples discussion with demonstration to give you not only the technical and procedural aspects of implementing a data warehouse, but also a basis to make design choices that will make your job more efficient and effective.About the InstructorScot Reagin's technology career spans the entire history of what we now think of as Business Intelligence. Starting with software he developed for mini-computers in the early 1980s to the first Cube technologies of the 1990s and Self-Service BI and contemporary Predictive Analytics, Scot has consistently designed, developed, and delivered solutions for organizations across the evolving BI marketplace. Scot is a TDWI Certified Business Intelligence Professional and Board Member of the Colorado Data Warehouse Institute. He is also a Certified Data Vault Data Modeler and active member of the Genesee Academy. Scot is the author of Microsoft 70-768: Developing SQL Data Models LiveLessons (Video Training). Skill Level IntermediateLearn How ToDesign and implement dimension tables and fact tablesDesign Rowstore and Columnstore indexesDesign storage for a data solutionImplement SSIS packagesWho Should Take This CourseIT professionals responsible for designing, implementing, or administering SQL Server data warehousesBI developers pursuing Microsoft CertificationCourse RequirementsBasic understanding of extract, transform, and load (ETL) and data warehousesFamiliarity with Microsoft SQL Server client toolsAbout Pearson Video Training Pearson publishes expert-led video tutorials covering a wide selection of technology topics designed to teach you the skills you need to succeed. These professional and personal technology videos feature world-leading author instructors published by your trusted technology brands: Addison-Wesley, Cisco Press, Pearson IT Certification, Prentice Hall, Sams, and Que Topics include: IT Certification, Network Security, Cisco Technology, Programming, Web Development, Mobile Development, and more. Learn more about Pearson Video training at http://www.informit.com/video. Show and hide more
  1. Introduction
    • SQL Server 70-767: Introduction 00:03:32
  2. Lesson 1: Design and Implement Dimension Tables
    • Learning objectives 00:00:45
    • 1.1 Design Hierarchies 00:13:32
    • 1.2 Implementing Dimension Tables 00:16:34
    • 1.3 Determine keys and key relationships 00:17:08
    • 1.4 Design and maintain slowly changing dimensions 00:25:02
    • 1.5 Implement auditing and lineage 00:11:40
  3. Lesson 2: Design and Implement Fact Tables
    • Learning objectives 00:01:06
    • 2.1 Identify measures 00:17:06
    • 2.2 Identify dimension table relationships 00:12:48
    • 2.3 Design many-to-many relationships 00:07:54
  4. Lesson 3: Design an Indexed Solution
    • Learning objectives 00:00:41
    • 3.1 Design Rowstore indexes 00:12:46
    • 3.2 Design Columnstore indexes 00:10:37
  5. Lesson 4: Design a Storage Solution
    • Learning objectives 00:00:34
    • 4.1 Configure hardware and file layout 00:14:25
    • 4.2 Design partitions 00:17:15
  6. Lesson 5: Design and Implement SSIS Packages
    • Learning objectives 00:01:03
    • 5.1 Implement an SSIS control flow 00:15:35
    • 5.2 Implement an SSIS control flow - Demo 00:20:12
    • 5.3 Implement an SSIS data flow 00:08:34
    • 5.4 Implement an SSIS data flow - Demo 00:15:13
    • 5.5 Implement transformations 00:25:11
    • 5.6 Create variables and parameters 00:24:29
  7. Lesson 6: Design Advanced SSIS Packages
    • Learning objectives 00:00:31
    • 6.1 Implement fuzzy grouping and fuzzy lookup 00:29:06
    • 6.2 Implement checkpoints 00:12:42
    • 6.3 Implement data profiling 00:11:44
  8. Lesson 7: Design for Incremental Data Management
    • Learning objectives 00:00:41
    • 7.1 Configure SQL Server to use Change Data Capture 00:10:27
    • 7.2 Using Change Data Capture 00:11:16
  9. Lesson 8: Deploy and Administer SSIS Package and Projects
    • Learning objectives 00:00:59
    • 8.1 Diagnose errors using the debugger 00:35:39
    • 8.2 Deploy and configure packages 00:12:22
    • 8.3 Execute packages 00:07:52
  10. Lesson 9: Create a Knowledge Base with Data Quality Services
    • Learning objectives 00:00:45
    • 9.1 Implement Data Quality Services 00:05:58
    • 9.2 Configure Data Quality Services 00:15:08
    • 9.3 Implement Data Quality Services in SSIS 00:12:46
  11. Lesson 10: Manage Data with Master Data Services
    • Learning objectives 00:00:41
    • 10.1 Implement Master Data Services 00:07:47
    • 10.2 Configure Master Data Services 00:15:24
    • 10.3 Administer Master Data Services 00:09:13
  12. Summary
    • SQL Server 70-767: Summary 00:01:40
  13. Show and hide more

    Oreilly - SQL Server 70-767: Implementing a Data Warehouse Using SQL

    9780135224779.SQL.Server.70767.Implementing.a.Data.Warehouse.Using.SQL.part1.OR.rar

    9780135224779.SQL.Server.70767.Implementing.a.Data.Warehouse.Using.SQL.part2.OR.rar

    9780135224779.SQL.Server.70767.Implementing.a.Data.Warehouse.Using.SQL.part3.OR.rar

    9780135224779.SQL.Server.70767.Implementing.a.Data.Warehouse.Using.SQL.part4.OR.rar


 TO MAC USERS: If RAR password doesn't work, use this archive program: 

RAR Expander 0.8.5 Beta 4  and extract password protected files without error.


 TO WIN USERS: If RAR password doesn't work, use this archive program: 

Latest Winrar  and extract password protected files without error.


 Coktum   |  

Information
Members of Guests cannot leave comments.


SermonBox - Seasonal Collection

SermonBox - The Series Pack Collection

Top Rated News

  • Christmas Material
  • Laser Cut & Print Design Elements Bundle - ETSY
  • Daz3D - All Materials - SKU 37000-37999
  • Cgaxis - All Product - 2019 - All Retail! - UPDATED!!!
  • DigitalXModels Full Collections
  • Rampant Design Tools Full Collections Total: $4400
  • FilmLooks.Com Full Collection
  • All PixelSquid Product
  • The Pixel Lab Collection
  • Envato Elements Full Sources- 3200+ Files
  • Ui8.NET Full Sources
  • The History of The 20th Century
  • The Dover Collections
  • Snake Interiors Collections
  • Inspirational Collections
  • Veer Fancy Collections
  • All Ojo Images
  • All ZZVE Collections
  • All Sozaijiten Collections
  • All Image Broker Collections
  • Shuterstock Bundle Collections
  • Tattoo Collections
  • Blend Images Collections
  • Authors Tuorism Collections
  • Motion Mile - Big Bundle
  • PhotoBacks - All Product - 2018
  • Dekes Techniques - Photoshop & Illustrator Course - 1 to 673
Telegram GFXTRA Group
Udemy - Turkce Gorsel Ogrenme Setleri - Part 2
Videohive Wow Pack Series


rss