Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Advanced Databases
Getting Started
Join the Community
Download The Diagram
Installing Postgres
Connecting to Databases Using Terminal
Datagrip
Installing Datagrip
Configure Datagrip (5:14)
Presentation assistant and Keymaps
Create Database Using Datagrip
Joins
Joins (4:07)
Inner Joins
Left Joins
Right Join
Full Join
Inner & Outer Joins (1:48)
Database Transactions
Why Transactions
Begin, Commit and Rollback
Nested Transactions
Indexes
Primary Keys and Indexes
View Indexes Trough Terminal (3:54)
Create and Drop Indexes
Indexes in action (6:58)
Multi Column Indexes
Unique Indexes (7:58)
Partial Indexes
Functions
Function skeleton
Create functions
View and Drop Functions
Database Administration
Roles
View Roles
Creating roles
Privileges (5:49)
Revoking Permissions
Member Roles
Schemas
What are Schemas
Create Schemas
Schema Search Path (4:13)
Grant Schema Usage
Database Backups and Restores
Backing up Databases
Restore Database
Backup All databases
Download The Diagram
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock