“Riordan covers core skills for any developer—database design and development—in a perfect amount of detail. This book should be on every professional developer’s reading list.” — Duncan Mackenzie, developer, Microsoft (MSDN) “Designing a database is not a trivial subject. Riordan brings experience and clear explanations to a fundamental part of software development.” — Patrick Birch, database and technical writing consultant “If you buy only one book on database design, make it this one. Riordan has a talent for explaining technical issues in simple language, without over simplifying.” — Brendan Reynolds, developer, Dataset IT Systems and Microsoft Access MVP “A book that will expertly guide you in how to develop a database for a client— and how to do it right the first time!” — Kenneth D. Snell, Ph.D., ACCESS developer and Microsoft Access MVP “Riordan has produced a unique book that brings together a formal, yet commonsense, approach to relational database design...and then goes further! Many database designers will find immense value in the steps to developing practical data warehouse designs. If you are seeking a framework for designing transactional databases, or want to step out into the world of analytical databases, Riordan’s book excels at bridging both worlds.” — Paul Irvine, vice president, engineering, Via Training “Riordan takes a complex subject and makes it easy. If you’re over your head on a database design project, this book will help bail you out!” — Mike Gunderloy, contributing editor, Application Development Trends “This book covers a wide range of database design and data modeling topics in a well-organized, easy to understand format.” — Amy Sticksel, Sticksel Data Systems, Inc. “In Riordan’s style, wit, and attention to detail are outstanding.” Designing Effective Database Systems, — Sandra Daigle, Microsoft Access MVP The Software Developer’s Step-by-Step Guide to Database Design World-renowned expert Rebecca M. Riordan has written the definitive database design book for working developers who aren’t database experts. No matter how messy or complex your data challenge, shows you how to design an effective, high-performance database to solve it. Designing Effective Database Systems Riordan begins by thoroughly demystifying the principles of relational design, making them accessible to every professional developer. Next, she offers the field’s clearest introduction to dimensional database modeling—practical insight for designing today’s increasingly important analytical applications. One task at a time, the author illuminates every facet of database analysis and design for both traditional databases and the dimensional databases used for data warehousing, showing how to avoid common architectural pitfalls that complicate development and reduce extensibility. The book concludes with comprehensive, expert guidance on designing databases for maximum usability. This book will teach you to Understand relational database models, structures, relationships, and data integrity principles Define database system goals, criteria, scope, and work processes Construct accurate conceptual models: relationships, entities, domain analysis, and normalization Build efficient, secure database schema Master the elements of online analytical processing (OLAP) design: fact tables, dimension tables, snowflaking, and more Architect and construct easy, efficient interfaces for querying and reporting Learn from practice examples based on Microsoft’s Northwind sample database Riordan has helped thousands of professionals master database design and development, earning Microsoft’s coveted MVP honor for her exceptional contributions. Nobody is more qualified to help you master database design and apply it in your real-world environment.

“An excellent, early look at the emerging XML Query standard. The chapters on surprises and gotchas alone are worth the price of admission!” — Ashok Malhotra, Architect, Microsoft “XQuery is the most important XML standard to emerge in recent years, and is a language with which anyone using XML on a regular basis should become acquainted. Michael Brundage's accessible introduction to XQuery provides enough information on all aspects of the standard, including its dark corners, to allow any XML developer to jump right in and start coding.” — Damien Fisher, Kernel Team Member, Soda Technologies Pty Ltd “This book does an excellent job of distilling the essentials of XQuery in an understandable, straightforward and easily digestable manner. This book has already become an indispensible part of my library and is a welcome addition to my XML repertoire.” — Dare Obasanjo, Program Manager, Microsoft Corporation “Simply put, the emerging XQuery standard adds enormous value to XML data and this book is your key to unlocking that value. Here in one stop you will find an accessible introduction to XQuery and a complete reference. Practitioners will particularly value the sections on XQuery idioms and surprises where Michael shares his tricks of the trade.” — Dave Van Buren, Project Manager, Jet Propulsion Laboratory “It’s both a stupendous reference on XQuery and a good read. Michael writes with verve, authority, and an eminently readable style. What a rare delight to discover all this, and in a technical book too! When the sequel comes along, sign me up.” — Howard Katz, Owner, Fatdog Software Inc., Editor, XQuery from the Experts (Addison-Wesley, 2003) From corporate IT departments to academic institutions, XML has become the language of choice for storing and transmitting data across diverse application domains. XQuery, an XML Query Language invented by the World Wide Web Consortium, offers a powerful, standardized way to query all of that XML-encapsulated information. With its ability to integrate XML and non-XML data, XQuery seems poised to do for XML what SQL has done for relational data. Written by the Technical Lead for XML query processing at Microsoft, is an invaluable resource for XQuery novices and experts alike. For those new to XQuery, this example-rich text serves as a tutorial that brings readers quickly up to speed on XQuery's data model, type system, and core language features. More experienced XML and database developers will find an excellent reference on the nuances of various expressions, as well as a guide to using XQuery to accomplish specific tasks. XQuery: The XML Query Language Drawing on his experiences using XQuery, Michael Brundage offers an objective, inside look at this emerging technology. His unique perspective translates into an accessible and authoritative guide for readers using XML for documents, Web services, or databases. Key coverage includes: Data model and type system Path navigation Iteration, construction, arithmetic, text processing, type operators and user-defined functions Information beyond the standard—such as a look at update languages, performance benchmarks, query optimization, XQuery style, and much, much more Hundreds of examples The future of XQuery The appendixes provide in-depth information on XQuery's type system, core expressions, built-in functions, regular expressions, and grammar. Meanwhile, the companion Web site offers downloadable source code for all of the examples in the book, the latest on the XQuery standard, answers to readers' questions, XQuery tips and strategies, and more. will show developers, programmers, and database administrators how a single line of this deep and powerful new language can accomplish the equivalent of hundreds of lines written in C, C#, Java, and other general-purpose programming languages. XQuery

XQuery Kick Start delivers a concise introduction to the XQuery standard, and useful implementation advice for developers needing to put it into practice. The book starts by explaining the role of XQuery in the XML family of specifications, and its relationship with XPath. The authors then explain the specification in detail, describing the semantics and data model, before moving to examples using XQuery to manipulate XML databases and document storage systems. Later chapters discuss Java implementations of XQuery and development tools that facilitate the development of Web sites with XQuery. This book is up to date with the latest XQuery specifications, and includes coverage of new features for extending the XQuery language.

This book is for database designers and database administrators using Visio, which is the database component of Microsoft's Visual Studio .NET for Enterprise Architects suite, also included in MSDN subscriptions. This is the only guide to this product that tells DBAs how to get their job done. Although primarily focused on tool features, the book also provides an introduction to data modeling, and includes practical advice on managing database projects. The principal author was the program manager of VEA's database modeling solutions. · Explains how to model databases with Microsoft® Visio for Enterprise Architects (VEA), focusing on tool features.· Provides a platform-independent introduction to data modeling using both Object Role Modeling (ORM) and Entity Relationship Modeling (ERM), and includes practical advice on managing database projects.· Additional ORM models, course notes, and add-ins available online.

Business Intelligence describes the basic architectural components of a business intelligence environment, ranging from traditional topics such as business process modeling, data modeling, and more modern topics such as business rule systems, data profiling, information compliance and data quality, data warehousing, and data mining. This book progresses through a logical sequence, starting with data model infrastructure, then data preparation, followed by data analysis, integration, knowledge discovery, and finally the actual use of discovered knowledge. The book contains a quick reference guide for business intelligence terminology. Business Intelligence is part of Morgan Kaufmann's Savvy Manager's Guide series. * Provides clear explanations without technical jargon, followed by in-depth descriptions. * Articulates the business value of new technology, while providing relevant introductory technical background. * Contains a handy quick-reference to technologies and terminologies. * Guides managers through developing, administering, or simply understanding business intelligence technology. * Bridges the business-technical gap. * Is Web enhanced. Companion sites to the book and series provide value-added information, links, discussions, and more.

Concise and practical, this indispensable volume brings the world’s most popular Relational Database Management System (RDBMS), its query language SQL, and its programming language PL/SQL into clear focus for today’s busy database professional or business analyst. Covering the most commonly used Oracle features, is ideal for the developer or business user challenged with implementing, maintaining, and retrieving mission-critical data within the Oracle database environment. Oracle SQL and PL/SQL Handbook Broadly designed as both a basic reference and how-to, this book offers extensive coverage of Oracle’s SQL language and database concepts, providing an excellent review for the Oracle certification exams. The initial chapters offer a complete introduction to the relational database environment, including a discussion of how to use the logical data model to understand the database. Oracle database objects are explored, along with uses of the Data Definition Language (DDL), the Data Control Language (DCL), and the Data Manipulation Language (DML). Later chapters offer complete coverage of the Select command used to retrieve information from the database. Also included are coverage of Oracle’s new analytic functions, a chapter on performance-tuning techniqes needed for complex SQL, and a detailed overview of Oracle’s PL/SQL language. In addition, many chapters provide practice questions designed to reinforce newly introduced concepts, as well as numerous examples of SQL techniques. The broad-based and comprehensive coverage also includes: Understanding the database using entity relationship diagrams and database schema diagrams Applying the Data Definition, Data Control, and Data Manipulation languages to create and maintain the database Using the SQL language to retrieve information from the database Creating special business information using Oracle’s new analytic functions Making your SQL perform better with common troubleshooting techniques Producing business information with business objects Using Java with PL/SQL Authoritative and practical, provides today’s administrator and business analyst alike with the most comprehensive sourcebook of solutions and techniques for improving their use of Oracle. Oracle SQL and PL/SQL Handbook 0201752948B07152002

"Dan's book provides something that the formal standards and development manuals sorely lack: a context that helps developers understand how to use XML in their own projects." --Tim Kientzle, Independent Software Consultant is a guide for Web developers and database programmers interested in building robust XML applications backed by SQL databases. It makes it easier than ever for Web developers to create and manage scalable database applications optimized for the Internet. XML and SQL: Developing Web Applications The author offers an understanding of the many advantages of both XML and SQL and provides practical information and techniques for utilizing the best of both systems. The book explores the stages of application development step by step, featuring a real-world perspective and many examples of when and how each technology is most effective. Specific topics covered include: Project definition for a data-oriented application Creating a bullet-proof data model DTDs (document type definitions) and the design of XML documents When to use XML, and what parts of your data should remain purely relational Related standards, such as XSLT and XML Schema How to use the XML support incorporated into Microsoft's SQL Server™ 2000 The XML-specific features of J2EE™ (Java™ 2 Enterprise Edition) Throughout this book, numerous concrete examples illustrate how to use each of these powerful technologies to circumvent the other's limitations. If you want to use the best part of XML and SQL to create robust, data-centric systems then there is no better resource than this book. 0201657961B10152001

The new challenge of integrated solutions is to get more knowledge from data in order to build the most valuable solutions. This IBM Redbooks publication is a solution guide to address the business issues in health care by real usage experience and to position the value of DB2 Intelligent Miner for Data in a Business Intelligence architecture as an integrated solution. Typical health care issues are addressed in this book, such as: How to calculate weight for diagnoses related groups? Are there characteristic groups of patients in my population? Can we optimize medical tests for a specific disease? Can we detect precauses for a special medical condition? This book also describes a data mining method to ensure that the optimum results are obtained. It details for each business issue: - What common data model to use - How to source the data - How to evaluate the model - What data mining technique to use - How to interpret the results - How to deploy the model Business users who want to know the payback on their organization when using the DB2 Intelligent Miner for Data solution should read the sections about the business issues, how to interpret the results, and how to deploy the model in the enterprise. Implementers who want to start using mining techniques should read the sections about how to define the common data model to use, how to source the data, and how to choose the data mining techniques.

The new challenge of integrated solutions is to get more knowledge from data in order to build the most valuable solutions. This IBM Redbooks publication is a solution guide to address the business issues in telecommunications by real usage experience and to position the value of DB2 Intelligent Miner for Data in a Business Intelligence architecture as an integrated solution. Typical telecoms issues are addressed in this book, such as: What are the characteristics of your customers? Can you predict the customers who are likely to leave? How do you discover the true value of your customers? This book also describes a data mining method to ensure that the optimum results are obtained. It details for each business issue: - What common data model to use - How to source the data - How to evaluate the model - What data mining technique to use - How to interpret the results - How to deploy the model Business users who want to know the payback on their organization when using the DB2 Intelligent Miner for Data solution should read the sections about the business issues, how to interpret the results, and how to deploy the model in the enterprise. Implementers who want to start using mining techniques should read the sections about how to define the common data model to use, how to source the data, and how to choose the data mining techniques.

The new challenge of integrated solutions is to get more knowledge from data in order to build the most valuable solutions. This IBM Redbooks publication is a solution guide to address the business issues in banking by real usage experience and to position the value of DB2 Intelligent Miner For Data in a Business Intelligence architecture as an integrated solution. Typical banking issues are addressed in this book, such as: How can you discover the characteristics of your customers? Which products can you sell to which customers and how? This book also describes a data mining method to ensure that the optimum results are obtained. It details for each business issue: - What common data model to use - How to source the data - How to evaluate the model - What data mining technique to use - How to interpret the results - How to deploy the model Business users who want to know the payback on their organization when using the DB2 Intelligent Miner For Data solution should read the sections about the business issues, how to interpret the results, and how to deploy the model in the enterprise. Implementers who want to start using mining techniques should read the sections about how to define the common data model to use, how to source the data, and how to choose the data mining techniques.

The new challenge of integrated solutions is to get more knowledge from data in order to build the most valuable solutions. This IBM Redbooks publication is a solution guide to address the business issues in retail by real usage experience and to position the value of DB2 Intelligent Miner For Data in a Business Intelligence architecture. Typical retail issues are addressed in this book, such as: How can I characterize my customers from the mix of products that they purchase? How can I decide which products to recommend to my customers? How can I categorize my customers and identify new potential customers? This book also describes a data mining method to ensure that the optimum results are obtained. It details for each business issue: - What common data model to use - How to source the data - How to evaluate the model - What data mining technique to use - How to interpret the results - How to deploy the model Business users who want to know the payback on their organization when using the DB2 Intelligent Miner For Data solution should read the sections about the business issues, how to interpret the results, and how to deploy the model in the enterprise. Implementers who want to start using mining techniques should read the sections about how to define the common data model to use, how to source the data, and how to choose the data mining techniques.

A quick and reliable way to build proven databases for core business functions Industry experts raved about The Data Model Resource Book when it was first published in March 1997 because it provided a simple, cost-effective way to design databases for core business functions. Len Silverston has now revised and updated the hugely successful 1st Edition, while adding a companion volume to take care of more specific requirements of different businesses. This updated volume provides a common set of data models for specific core functions shared by most businesses like human resources management, accounting, and project management. These models are standardized and are easily replicated by developers looking for ways to make corporate database development more efficient and cost effective. This guide is the perfect complement to The Data Model Resource CD-ROM, which is sold separately and provides the powerful design templates discussed in the book in a ready-to-use electronic format. A free demonstration CD-ROM is available with each copy of the print book to allow you to try before you buy the full CD-ROM.

A quick and reliable way to build proven databases for core business functions Industry experts raved about The Data Model Resource Book when it was first published in March 1997 because it provided a simple, cost-effective way to design databases for core business functions. Len Silverston has now revised and updated the hugely successful First Edition, while adding a companion volume to take care of more specific requirements of different businesses. Each volume is accompanied by a CD-ROM, which is sold separately. Each CD-ROM provides powerful design templates discussed in the books in a ready-to-use electronic format, allowing companies and individuals to develop the databases they need at a fraction of the cost and a third of the time it would take to build them from scratch. With each business function boasting its own directory, this CD-ROM provides a variety of data models for specific implementations in such areas as financial services, insurance, retail, healthcare, universities, and telecom.

Data modeling is one of the most critical phases in the database application development process, but also the phase most likely to fail. A master data modeler must come into any organization, understand its data requirements, and skillfully model the data for applications that most effectively serve organizational needs. is a complete guide to becoming a successful data modeler. Featuring a requirements-driven approach, this book clearly explains fundamental concepts, introduces a user-oriented data modeling notation, and describes a rigorous, step-by-step process for collecting, modeling, and documenting the kinds of data that users need. Mastering Data Modeling Assuming no prior knowledge, sets forth several fundamental problems of data modeling, such as reconciling the software developer's demand for rigor with the users' equally valid need to speak their own (sometimes vague) natural language. In addition, it describes the good habits that help you respond to these fundamental problems. With these good habits in mind, the book describes the Logical Data Structure (LDS) notation and the process of controlled evolution by which you can create low-cost, user-approved data models that resist premature obsolescence. Also included is an encyclopedic analysis of all data shapes that you will encounter. Most notably, the book describes The Flow, a loosely scripted process by which you and the users gradually but continuously improve an LDS until it faithfully represents the information needs. Essential implementation and technology issues are also covered. Mastering Data Modeling You will learn about such vital topics as: The fundamental problems of data modeling The good habits that help a data modeler be effective and economical LDS notation, which encourages these good habits How to read an LDS aloud--in declarative English sentences How to write a well-formed (syntactically correct) LDS How to get users to name the parts of an LDS with words from their own business vocabulary How to visualize data for an LDS A catalog of LDS shapes that recur throughout all data models The Flow--the template for your conversations with users How to document an LDS for users, data modelers, and technologists How to map an LDS to a relational schema How LDS differs from other notations and why "Story interludes" appear throughout the book, illustrating real-world successes of the LDS notation and controlled evolution process. Numerous exercises help you master critical skills. In addition, two detailed, annotated sample conversations with users show you the process of controlled evolution in action.

This hands-on lab guides you through importing real-world data from CSV files into a Cloud SQL database. Using a flight dataset from the US Bureau of Transport Statistics, you'll gain hands-on experience with data ingestion and basic analysis. You'll learn to create a Cloud SQL instance and database, effectively import your data, and build a foundational data model using SQL queries.

If you register for a Learning Center lab, please ensure that you sign up for a Google Cloud Skills Boost account for both your work domain and personal email address. You will need to authenticate your account as well (be sure to check your spam folder!). This will ensure you can arrive and access your labs quickly onsite. You can follow this link to sign up!