Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Learn Database Design using PostgreSQL
Introduction
Introduction (3:09)
Relational Database Overview (9:57)
PostgreSQL Overview (6:53)
PostgreSQL vs MySQL (10:56)
Getting Started With PostgreSQL
Install PostgreSQL & pgAdmin (9:20)
XAMPP Installation (6:57)
Using the psql Commaind Line (11:10)
phpPgAdmin (9:24)
Database Development
Naming Conventions (9:50)
Best Practices & Normalization (11:46)
Structuring and Diagramming (20:21)
Creating and Populating a Database (20:19)
Database Import and Export (8:39)
Writing SQL
SQL Fundamentals (10:43)
Selecting and Viewing Data (10:43)
Insert, Update and Delete Statements (5:36)
Table Joins (7:41)
Putting it all together (24:05)
SQL Functions & Operators
String Functions (13:44)
Basic Math Functions (6:33)
Aggregate Functions & Group By (14:14)
Union, In and Concat (11:18)
PHP & Postgres Web Application
Application UI (20:19)
Connect To PostgreSQL (6:53)
Select and Display Data (12:55)
Adding Data (25:40)
Update & Delete Data (19:48)
Course Summary
Course Summary (3:23)
Best Practices & Normalization
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock