Database Foundations: Application Development

Course details

While learning about the individual components of a software development stack like databases, programming languages, and interfaces is important, combining multiple technologies that each contribute a piece to the whole is where all the knowledge really comes together. In this fifth and final course of his Database Foundations series, database expert Adam Wilbert explores the role of relational databases in the larger landscape of application development. He examines the architecture of modern apps and how databases integrate with presentation and logic, and how all these building blocks of software development fit together. To do so, Adam shows two different approaches of how to integrate a database with a web server and details the components that allow you to build custom interfaces for your data, in order to provide end users access to your databases from any web browser.

Concepts

Introduction

Integrating databases with an application
What you should know
The exercise files

Application Layers

Multitier architectures
Communicate with the data layer
Databases on the web
Project overview

PostgreSQL and PHP

What is PHP and Apache
Create a PHP web server
Connect to the PHP server
PostgreSQL functions
Use PHP variables
Use if else to handle errors
Add data to a database
Format SELECT query results
Filter results with form controls
Add data to a table with form controls

SQL Server and ASP.NET Core

What is ASP.NET Core
Create the ASP.NET Core web server with Docker
Add a database to SQL Server
ASP.NET modularity
Model tabular data
Controller classes
URL segments

Conclusion

Next steps