How to Guides

Daniel Cave

How to Use Data APIs to Reduce Form Complexity

Where to start when using APIs to reduce form completion complexity within your orgnisation. The questions you need to ask to get the best data and service.

Continue Reading

Clifford McDowell

How to Use Open Data in any Business

This guide is a practical guide of how you can integrate Open Data into any data-driven process using Doorda's unique Open Data API and hosted datasets

Continue Reading

Clifford McDowell

Query Optimization for Presto on DoordaHost

DoordaHost uses Presto for its main query engine, get the most out of it by using our tips below on how to get the best Query Optimization for Presto.

Continue Reading

Barry

4 easy ways to Optimize SQL Queries and Enhance Security

Poorly designed tables and queries can lead to a two-second query taking 30 minutes or more to execute. Learn the easiest way to Optimize your SQL Queries

Continue Reading

Barry

Using INNER JOIN versus CROSS JOIN in SQL

Using the right JOIN statement in your SQL code is critical for accurate results. When should INNER JOIN be used versus CROSS JOIN in SQL.

Continue Reading

Clifford McDowell

Assets Less Liabilities, calculating Company Net Worth

Company Assets less liabilities can be used as a quick snapshot, or statement of financial position, for a Company on a specific date.

Continue Reading