Database Explorer

Building a Complete Database Explorer Application

In this lab you will learn to build a simple, yet full-featured database application using Infinitera Database Explorer. The completed application is designed to allow a team of software developers to track their work for specific client projects. The application supports two security contexts; one for project managers to manage clients, projects and developers and the other for developers to log their time to the projects for which they have been assigned. The application also allows project managers to generate bills for clients. Total time is 44 minutes and 6 seconds.


The lab assumes that you have an Azure SQL Database provisioned with database owner permissions. You will also need to be assigned a license to use Infinitera Database Explorer along with consent to use it within your Azure Active Directory tenant.

For more information visit Getting Started.

The Completed Application (2 minutes, 44 seconds)

This module shows you how the application looks when it’s completed.

Building the Tables (10 minutes, 56 seconds)

This modules walks you through creating tables for Client, Developers, Projects, Assigned Developers, Work, Bills and Billed Work.


Building a Sub Form (4 minutes, 23 seconds)

The previous module demonstrated the use of sub tabs. This module will show the use of sub forms.

Integrating the Views (10 minutes, 59 seconds)

This module demonstrates how you can add value to the application by creating views that aggregate the data in useful ways.


Integrating a Stored Procedure (3 minutes, 14 seconds)

This module shows you how stored procedures can be used in your application to automate activities.


Securing the Application (10 minutes, 31 seconds)

In this module you’ll learn how to secure the application so users can only see and do the things for which they should be able to see and do based upon their role memberships.

Security Part 1.txt
Security Part 2.txt

Deploying to Teams (1 minute, 19 seconds)

In the last module you’ll learn how to make the application available to the members of your Microsoft Teams.