Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Learn Database Design using PostgreSQL
Introduction
Introduction
Relational Database Overview
PostgreSQL Overview
PostgreSQL vs MySQL
Getting Started With PostgreSQL
Install PostgreSQL & pgAdmin
XAMPP Installation
Using the psql Commaind Line
phpPgAdmin
Database Development
Naming Conventions
Best Practices & Normalization
Structuring and Diagramming
Creating and Populating a Database
Database Import and Export
Writing SQL
SQL Fundamentals
Selecting and Viewing Data
Insert, Update and Delete Statements
Table Joins
Putting it all together
SQL Functions & Operators
String Functions
Basic Math Functions
Aggregate Functions & Group By
Union, In and Concat
PHP & Postgres Web Application
Application UI
Connect To PostgreSQL
Select and Display Data
Adding Data
Update & Delete Data
Course Summary
Course Summary
Structuring and Diagramming
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock