Nonfiction » Computers and Internet » Database management

To The Point… 100+ SQL Queries Jet SQL for Microsoft Office Access
By
Series: To The Point. Price: $7.99 USD. Words: 6,540. Language: English. Published: December 15, 2012. Category: Nonfiction » Computers and Internet » Programming
Learn to tame your Microsoft Office Access 2010 databases using Jet SQL. Create tables, select records, filter, sort, join tables and more. Over 100 SQL queries and statements along with images of results will help you learn, test your skills and get ahead in the workplace. Download your copy today, be more productive at work tomorrow.
Implement Oracle Business Intelligence
By
Price: $15.00 USD. Words: 45,140. Language: English. Published: October 19, 2012. Category: Nonfiction » Computers and Internet » Database management
Learn how to dig intelligence from the data mine to take informed decisions using Oracle BIEE
SQL in 30 Pages
By
Price: $2.99 USD. Words: 2,810. Language: English. Published: September 21, 2012. Category: Nonfiction » Computers and Internet » Database management
SQL in 30 Pages is a brief e-booklet of fewer than 4,000 words, designed to get you into SQL as fast as possible, as easily as possible. There is no bull in this Micro-Manual by popular online teacher U.Q. Magnusson. Simple yet comprehensive examples follow as you zip through, and each is explained in pithy detail.
Accounting In SQL Coding
By
Price: Free! Words: 2,910. Language: English. Published: August 21, 2012. Category: Nonfiction » Computers and Internet » Database management
Learn how to write SQL for an accounting system. You will learn how to develop various modular graphical user interface with strong business logic control, how to create accounting tables and how to write powerful SQL statement involving the use of joins, subqueries, cursors, advanced data filtering, constraints, stored procedures and triggers in building a complete functional accounting system.
Best Practices for Data Profiling
By
Price: $5.00 USD. Words: 6,990. Language: English. Published: August 14, 2012. Category: Nonfiction » Business & Economics » Business administration
The purpose of this document is to understand how data profiling works and how to do it.
Best Practices for Data Mapping
By
Price: $5.00 USD. Words: 4,630. Language: English. Published: August 13, 2012. Category: Nonfiction » Business & Economics » Business administration
The purpose of this document is to understand how data mapping works and how to do it.
Best Practices for Data Governance
By
Price: $5.00 USD. Words: 4,110. Language: English. Published: August 9, 2012. Category: Nonfiction » Computers and Internet » Database management
The purpose of this document is to understand how data governance works and how to do it.
Best Practices for Data Cleansing
By
Price: $5.00 USD. Words: 6,660. Language: English. Published: August 2, 2012. Category: Nonfiction » Business & Economics » Decision-making & problem solving
The purpose of this document is to understand how data cleansing works and how to do it. Besides being critical for the data from which decisions and services are done, there are now legal issues involved.
Best Practices for Coding SQL Statements
By
Price: $5.00 USD. Words: 2,760. Language: English. Published: July 26, 2012. Category: Nonfiction » Computers and Internet » Programming
The purpose of this document is to convey best practices for coding SQL statements. While there are dialects of SQL among the various database management system vendors, including many variations and extensions, this document will deal only with general conventions that apply to the SQL use within Microsoft, Oracle, and IBM DB2.
Naming Conventions for Physical Database Objects
By
Price: $5.00 USD. Words: 5,960. Language: English. Published: July 25, 2012. Category: 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
Price: $5.00 USD. Words: 2,750. Language: English. Published: July 23, 2012. Category: 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
Price: $5.00 USD. Words: 3,030. Language: English. Published: July 22, 2012. Category: 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 Primary Key and Unique Key Constraints
By
Price: $5.00 USD. Words: 4,210. Language: English. Published: July 22, 2012. Category: Nonfiction » Computers and Internet » Database management
The purpose of this document is to understand primary and unique key constraints as a very important general concept in data integrity enforcement in both database design and database management.
Best Practices for Check Constraints
By
Price: $5.00 USD. Words: 2,500. Language: English. Published: July 20, 2012. Category: 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.
Best Practices for Data Audit
By
Price: $5.00 USD. Words: 16,310. Language: English. Published: July 19, 2012. Category: Nonfiction » Business & Economics » Auditing
The purpose of this document is to convey best practices for auditing data changes to include such activities as inserting, updating, or deleting data in a database. Additionally auditing must include tracking of changes to authorizations/privileges, queries of sensitive data, and the logons and logouts of areas containing sensitive data.
Best Practices for Capacity Planning
By
Price: $5.00 USD. Words: 7,070. Language: English. Published: July 17, 2012. Category: Nonfiction » Computers and Internet » Database management
Without proper and thorough capacity planning, no business will continue to operate for very long. Costs and lack of performance in any and all systems will bring down even the largest corporation. This best practices book by James E. Seymour, Jr. presents proved processes by which to plan, develop, test, and implement successful capacity planning and implementation for any operation anywhere.
Advanced SAS Interview Questions You'll Most Likely Be Asked
By
Series: Job Interview Questions. Price: $9.99 USD. Words: 31,000. Language: English. Published: July 3, 2012. Category: Nonfiction » Computers and Internet » Database management / data mining
Advanced SAS Interview Questions You'll Most Likely Be Asked is a perfect companion to stand ahead above the rest in today’s competitive job market.
Oracle Ultimate DBA Interview Questions
By
Price: $9.99 USD. Words: 14,720. Language: English. Published: February 8, 2012. Category: Nonfiction » Reference » Study guides
The Ultimate Reference & Learning Guide for Oracle Database Administrators! 100 Certification Questions, Answers, and Explanations
Oracle Reports Interview Questions, Answers, and Explanations: Oracle Reports Certification Review
By
Price: $9.99 USD. Words: 14,040. Language: English. Published: February 8, 2012. Category: Nonfiction » Computers and Internet » Database management
100 Certification Questions, Answers, and Explanations Oracle has long been setting the standard in database technology, and to stay competitive applications professionals need to have a current understanding of Oracle’s newest improvements to Oracle Reports. With Oracle Reports Interview Questions even 10g issues are covered, so you will be current and competitive.
Oracle Database Security Interview Questions, Answers, and Explanations: Oracle Database Security Certification Review
By
Price: $9.99 USD. Words: 15,250. Language: English. Published: February 8, 2012. Category: Nonfiction » Computers and Internet » Database management
The Ultimate Reference & Learning Guide for IT Security and Oracle Database Professionals! Over 150 Oracle Security Interview Questions, Answers, and Explanations