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.
Overview
Syllabus
Introduction
- Integrating databases with an application
- What you should know
- The exercise files
- Multitier architectures
- Communicate with the data layer
- Databases on the web
- Project overview
- 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
- 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
- Next steps
Taught by
Adam Wilbert
