Database Foundations: Application Development

Database Foundations: Application Development

English | MKV | AVC 1280×720 | AAC 44KHz 2ch | 1h 49m | 355 MB

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.

Table of Contents

1 integrating databases with an application
2 what you should know
3 the exercise files
4 multitier architectures
5 communicate with the data layer
6 databases on the web
7 project overview
8 what is php and apache
9 create a php web server
10 connect to the php server
11 postgresql functions
12 use php variables
13 use ifelse to handle errors
14 add data to a database
15 format select query results
16 filter results with form controls
17 add data to a table with form controls
18 what is core
19 create the core web server with docker
20 add a database to sql server
21 modularity
22 model tabular data
23 controller classes
24 url segments
25 next steps