Database Foundations: Application Development

This capstone to the Database Foundations series demonstrates how the RDBMS fits into the wider world of app development, as well as what it means to be a full-stack developer.

Introduction

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

1. Application Layers

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

2. 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

3. 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