Microsoft SQL Server 2012 Master Data Services 2/E

Microsoft SQL Server 2012 Master Data Services 2/E

Microsoft SQL Server 2012 Master Data Services 2/E

  • Used Book in Good Condition

Deploy and Maintain an Integrated MDS Architecture

Harness your master data and grow revenue while reducing administrative costs. Thoroughly revised to cover the latest MDS features, Microsoft SQL Server 2012 Master Data Services, Second Edition shows how to implement and manage a centralized, customer-focused MDS framework. See how to accurately model business processes, load and cleanse data, enforce business rules, eliminate redundancies, and publish data to external systems. Security, SOA and Web services, and legacy data integration are also covered in this practical guide.

  • Install Microsoft SQL Server 2012 Master Data Services
  • Build custom MDS models and entityspecific staging tables
  • Load and cleanse data from disparate sources
  • Logically group assets into collections and hierarchies
  • Ensure integrity using versioning and business rules
  • Configure security at functional, object, and attribute levels
  • Extend functionality with SOA and Web services
  • Facilitate collaboration using the MDS Excel Add-In
  • Export data to subscribing systems through SQL views

List Price: $ 50.00

Price: [wpramaprice asin=”0071797858″]

[wpramareviews asin=”0071797858″]

Data Modeling Made Simple with CA ERwin Data Modeler r8

Data Modeling Made Simple with CA ERwin Data Modeler r8

Data Modeling Made Simple with CA ERwin Data Modeler r8 will provide the business or IT professional with a practical working knowledge of data modeling concepts and best practices, and how to apply these principles with CA ERwin Data Modeler r8. You’ll build many CA ERwin data models along the way, mastering first the fundamentals and later in the book the more advanced features of CA ERwin Data Modeler. This book combines real-world experience and best practices with down to earth advice, humor, and even cartoons to help you master the following ten objectives:

  1. Understand the basics of data modeling and relational theory, and how to apply these skills using CA ERwin Data Modeler
  2. Read a data model of any size and complexity with the same confidence as reading a book
  3. Understand the difference between conceptual, logical, and physical models, and how to effectively build these models using CA ERwin’s Data Modelers Design Layer Architecture
  4. Apply techniques to turn a logical data model into an efficient physical design and vice-versa through forward and reverse engineering, for both top down and bottom-up design
  5. Learn how to create reusable domains, naming standards, UDPs, and model templates in CA ERwin Data Modeler to reduce modeling time, improve data quality, and increase enterprise consistency
  6. Share data model information with various audiences using model formatting and layout techniques, reporting, and metadata exchange
  7. Use the new workspace customization features in CA ERwin Data Modeler r8 to create a workflow suited to your own individual needs
  8. Leverage the new Bulk Editing features in CA ERwin Data Modeler r8 for mass metadata updates, as well as import/export with Microsoft Excel
  9. Compare and merge model changes using CA ERwin Data Modelers Complete Compare features
  10. Optimize the organization and layout of your data models through the use of Subject Areas, Diagrams, Display Themes, and more

Section I provides an overview of data modeling: what it is, and why it is needed. The basic features of CA ERwin Data Modeler are introduced with a simple, easy-to-follow example.

Section II introduces the basic building blocks of a data model, including entities, relationships, keys, and more. How-to examples using CA ERwin Data Modeler are provided for each of these building blocks, as well as ‘real world’ scenarios for context.

Section III covers the creation of reusable standards, and their importance in the organization. From standard data modeling constructs such as domains to CA ERwin-specific features such as UDPs, this section covers step-by-step examples of how to create these standards in CA ERwin Data Modeling, from creation, to template building, to sharing standards with end users through reporting and queries.

Section IV discusses conceptual, logical, and physical data models, and provides a comprehensive case study using CA ERwin Data Modeler to show the interrelationships between these models using CA ERwin’s Design Layer Architecture. Real world examples are provided from requirements gathering, to working with business sponsors, to the hands-on nitty-gritty details of building conceptual, logical, and physical data models with CA ERwin Data Modeler r8.

From the Foreword by Tom Bilcze, President, CA Technologies Modeling Global User Community:

Data Modeling Made Simple with CA ERwin Data Modeler r8 is an excellent resource for the ERwin community. Through the liberal use of illustrations, the inexperienced data modeler is graphically walked through the components of data models and how to create them in CA ERwin r8. As an experienced data modeler, Steve and Donna give me a handbook for effectively using the new and enhanced features of r8 to bring my art form to life.

List Price: $ 79.95

Price: [wpramaprice asin=”1935504096″]

[wpramareviews asin=”1935504096″]
Related Products

6 comments

  1. 3.0 out of 5 stars
    Probably the best MDS book available, but more content and guidance is needed, April 18, 2014
    By 
    T. Huguelet (Evanston, IL, USA) –
    (REAL NAME)
      

    Verified Purchase(What’s this?)
    I found the opening chapters quite good. However as I read further in the book, it seemed like it turned into a “click here” catalog. I found myself engaging in exercises without really understanding _why_ I was doing so. While I do think it’s valuable to have exercises to expose the capabilities of the product, with a book like this, I look as much for concepts and “why” behind the product. It seemed like the author started in that direction and then backed off from the higher-level conceptual stuff somewhat in favor of a features walk-through.

    I have deep expertise in SQL Server and Business Intelligence tools. This is a good book, and I recommend it, but I was definitely hoping for (and expecting) more. I would give 3.5 stars if 1/2 stars were allowed.

    0

    Help other customers find the most helpful reviews 

    Was this review helpful to you? Yes
    No

  2. 4.0 out of 5 stars
    Really good book but have nothing to compare it too. So it gets a 4., January 14, 2014
    By 
    Arthur L. Hill
    (REAL NAME)
      

    Verified Purchase(What’s this?)
    What you think of this book depends on the purpose for which you are using it. I was studying for the MS Exam 70-463 and found it to be fairly complete but missing some critical details, the subjects of which were included in the practice exam questions.

    If you are looking for a general overview of Master Data Management, this is not it. This is a tutorial on Microsoft’s tool for instituting Master Data Management. It does do a fairly good job of covering the subject of MDM, but it’s context is MS’s software.

    If you are a person who:
    1. is interested in learning about Microsoft MDS and what it can do.
    2. you have a system capable of running the example code
    3. you are SQL literate and comfortable with its vocabulary and syntax
    then this is a really good way of understanding what this product can do for your organization or your client’s organization.

    If you are studying for the exam and want a tertiary text that walks you thru the entire process of establishing, maintaining, and using the product, this is a good book.

    No matter what, If you are in management of any but the smallest of companies, you need to understand this subject matter. There is a book that you should read first before reading this or one concerning the same subject matter. That book is ‘Business Analytics for Managers: Taking Business Intelligence Beyond Reporting (Wiley & Sas Business Series) ‘

    0

    Help other customers find the most helpful reviews 

    Was this review helpful to you? Yes
    No

  3. 5.0 out of 5 stars
    Covers the entire product with usable examples, July 16, 2013
    By 
    Roger Wolter (Kirkland, WA, US) –

    Verified Purchase(What’s this?)
    This is a very complete and well-written book. I have the first edition and the new material in the second edition made it well-worth the price. The thing I like most about the book is that there is an example project that is carried through all the chapters so by the end you have seen an entire MDS project built. There are also code examples that teach you to do each operation through the Web Services API in addition to the UI. The explanation is much easier to understand than the Microsoft documentation

    0

    Help other customers find the most helpful reviews 

    Was this review helpful to you? Yes
    No

  4. 5 of 6 people found the following review helpful
    5.0 out of 5 stars
    Great Data Modeling Book, September 27, 2011
    By 
    Thanks

    This review is from: Data Modeling Made Simple with CA ERwin Data Modeler r8 (Paperback)
    Very good book! Whether you are new to Data Modeling, new to ERwin or both, this book is an excellent place to learn. From Normalization to Naming Standards, Diagrams to Datatypes, reusable objects and properties, the book is well thought out with a progressive flow through building and understanding Data Models. The step by step examples, including screen shots, were easy to follow and understand. Highly recommended

    0

    Help other customers find the most helpful reviews 

    Was this review helpful to you? Yes
    No

  5. 2 of 2 people found the following review helpful
    5.0 out of 5 stars
    Essential for ERwin r8!, September 3, 2012
    By 
    Michael Tozer (San Antonio, Texas United States) –
    (REAL NAME)
      

    Verified Purchase(What’s this?)
    This review is from: Data Modeling Made Simple with CA ERwin Data Modeler r8 (Paperback)
    This book by Steve Hoberman and Donna Burbank is both excellent and essential for the ERwin r8 user. The excellence is a probable result of the wonderful skills and depth of knowledge of the authors. But the book is also essential for users of ERwin r8, simply because it provides detailed and easy to follow coverage of the many advanced features of this completely modernized data modeling tool.

    Full disclosure requires me to report that I have the privilege of knowing Steve Hoberman personally. I met him this past March when I invited him to present his terrific Master Data Modeling class in our South Texas facility. The class was great, and my colleagues are still talking about it. Steve is an outstanding and entertaining instructor. But he is also much more: perhaps the most gifted active author relative to data modeling principles and practices, an obviously successful entrepenuer, and a very nice guy. His teaming with Donna Burbank on this important book is a match made in data modeling Heaven.

    Many of us have used ERwin as a data modeling tool for many years. But Erwin r8 represents one of the most radical upgrades of a software package I have experienced in thirty years in the data processing business. It may have been the marketing pressures from competing data modeling products that impelled Computer Associates to invest so much in this upgraded version. In any case, ERwin r8 is a vastly different product, with a great deal more functionality as compared to earlier versions. In the past, most folks probably learned earlier versions of ERwin intuitively and without formal training. This book absolutely fills in the gap for experienced users of previous versions of ERwin. But it is also an excellent text for users of other products or even for those entirely new to the discipline of data modeling. DBA’s will likewise be well edified by the many practical examples even of physical data modeling, forward, and reverse engineering contained within the text.

    Of the very many innovative aspects of this newly enriched product, I was perhaps most thrilled with the treatment of domains. To put this in context, I am a totally committed advocate of Dr. Codd’s relational model for database. In fact, I am even now rereading Dr. Codd’s magisterial “The Relational Model for Database Management: Version 2. Just this morning, I read over Chapter three, which details the centricity of domains in the relational model. Codd even holds that domains are “the glue that holds the relational model together”. In this context, the outstanding treatment of domains in ERwin r8 by Hoberman and Burbank is, in itself, worth the price of the entire book.

    Fellow colleagues, don’t complain that ERwin r8 has such an entirely new “look and feel” from previous versions. Rather, pick up this excellent and important book; and emerge as the thought leaders and technical experts within your organizations. Get to know this exciting and terrifically enhanced product with Hoberman and Burbank as your guides. God bless.

    0

    Help other customers find the most helpful reviews 

    Was this review helpful to you? Yes
    No

  6. 2 of 2 people found the following review helpful
    5.0 out of 5 stars
    An excellent introduction to data modeling using ERwin, November 6, 2011
    By 

    This review is from: Data Modeling Made Simple with CA ERwin Data Modeler r8 (Paperback)
    This book combines Donna Burbank’s deep knowledge of ERwin with Steve Hoberman’s knack for explaining data modeling in a lucid manner. The book has many modeling scenarios that walk a reader through the construction of a model using ERwin. The steps are easy to follow and reproduce given the many screen shots. This book is a must-read for new ERwin data modelers. The book is also relevant for experienced ERwin data modelers. I myself learned about two features of which I was unaware — domain inheritance and the different auto layout options.

    0

    Help other customers find the most helpful reviews 

    Was this review helpful to you? Yes
    No

Leave a Reply

Your email address will not be published. Required fields are marked *