Nonfiction » Computers and Internet » Data modeling & design

Oracle Quick Guides - Part 2 - Oracle Database Design    by Malcolm Coxall
Price: $3.00 USD. 24450 words. Language: English. Published on May 13, 2013. Nonfiction » Computers and Internet » Data modeling & design.

This is Part 2 of a series of quick learning guides for Oracle designers, developers & managers. Part 2 introduces completely new entrants to concepts of Oracle database analysis and design, database normalisation, the logical data model, E-R modelling and diagrams, logical to physical transformation in Oracle Designer, physical database design,de-normalization and database design for performance.
Informatica DataStage Cognos MicroStrategy ETL Testing Quick Reference    by Sibashis Nanda
Price: $6.99 USD. 31600 words. Language: English. Published on April 17, 2013. Nonfiction » Computers and Internet » Data modeling & design.

This quick reference book is meant for IT professionals who want a jump-start in their careers as data warehouse and ETL developer or tester. All the relevant topics are covered in a compressed summarized way, followed by interview questions. A must companion for job interviews! Topics Covered: Data Warehousing Basics, Informatica, DataStage, Cognos, MicroStrategy, ETL Testing
Journey to Actionable Intelligence Leveraging Big Data    by Keith B Carter
Price: $23.88 USD. 23280 words. Language: English. Published on February 18, 2013. Nonfiction » Business & Economics » Information management.

Businesses have gathered volumes of data on their companies, environment, and customers. Has this data been leveraged to its fullest? Is it in the right form to be valuable? It’s not enough just having data, it’s what you do with data to make better decisions. In the right hands, with the right approach, Big Data can deliver Actionable Intelligence, and Actionable Intelligence can deliver results!
How to Use Microsoft Excel 2010    by Gerard Strong
Price: $2.99 USD. 4630 words. Language: English. Published on January 8, 2013. Nonfiction » Computers and Internet » Data modeling & design.

Overview o An introduction to the basics of Microsoft Excel 2010. o It can be used by professionals, teachers, parents or children. o It shows you how spreadsheet may be used in a range of different situations. o It is divided in a series of lessons/chapters which you can follow at your own pace. o You will need no additional assistance.
Best Practices for Business Intelligence    by James Seymour
Price: $5.00 USD. 6140 words. Language: English. Published on August 3, 2012. Nonfiction » Business & Economics » Decision-making & problem solving.

The purpose of this document is to understand how business intelligence (BI) works in general and what are considered some of the best practices when doing a project within business intelligence.
Naming Conventions for Physical Database Objects    by James Seymour
Price: $5.00 USD. 5960 words. Language: English. Published on July 25, 2012. Nonfiction » Computers and Internet » Data modeling & design.

The purpose of this document is to convey the naming conventions for physical database objects such as tables, columns, relationships, and relationships. While physical object names should be derived from logical object names (e.g. entity, attribute, and relationship names), this document does not address logical names.
Naming Conventions for Logical Database Objects    by James Seymour
Price: $5.00 USD. 2750 words. Language: English. Published on July 23, 2012. Nonfiction » Computers and Internet » Data modeling & design.

The purpose of this document is to convey the naming conventions for logical database objects such as entities, attributes and relationships. The goal of these naming conventions is to provide a uniform method for naming logical database objects.
Best Practices for Referential Integrity    by James Seymour
Price: $5.00 USD. 3030 words. Language: English. Published on July 22, 2012. Nonfiction » Computers and Internet » Data modeling & design.

The purpose of this document is to understand referential integrity (RI) as a very important element in data integrity enforcement in database design and database management. It was standardized first with ANSI-89 – also approximately when ANSI and ISO started working together regarding international standardization of SQL.
Best Practices for Indexes and Their Use    by James Seymour
Price: $5.00 USD. 2910 words. Language: English. Published on July 20, 2012. Nonfiction » Computers and Internet » Data modeling & design.

The purpose of this document is to convey best practices for planning for the use of indexes in a database and for testing the functionality and worth of an index over other approaches.
Best Practices for Check Constraints    by James Seymour
Price: $5.00 USD. 2500 words. Language: English. Published on July 20, 2012. Nonfiction » Computers and Internet » Data modeling & design.

The purpose of this document is to understand check constraints as a very important general concept in data integrity enforcement in both database design and database management.