L07
Database services and their ports
Cram this first — memory hook
PostgreSQL 5432 is a countdown: five-four-three-two. MySQL's cabinet is 3306; Structured Query Language Server's shelf is 1433; Oracle's desk is 1521.
Exam trap
is a language; Server is a product. There is no single universal port.
The slide facts
The database slide lists relational systems and NoSQL, with Oracle *Net Transmission Control Protocol 1521, Microsoft Server 1433, MySQL/MariaDB 3306 and PostgreSQL 5432.
If you have time — extra
A database service stores information and answers structured requests. A website may ask it for a learner's marks or a product's stock count. A Relational Database Management System () organizes related data, usually in tables; Structured Query Language () is commonly used to query relational systems. NoSQL describes several non-relational approaches, not one product or one port. The port is the conventional listener for a product, and administrators can configure alternatives. A database should be reachable by the application components that require it, not automatically every client on the internet. Authentication, authorization and encrypted connections remain separate requirements.
Walkthrough
The browser requests a page from the web server. The web application queries the database listener. The database checks access and returns the result. The application sends the final page to the browser.