Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Advanced Databases
Getting Started
Join the Community
Download The Diagram
Newsletter
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
Next Steps
MongoDB
Download The Diagram
Download
diagram.drawio
open the file
diagram.drawio
with
https://www.diagrams.net/
Complete and Continue
1 - Follow us on
LinkedIn
2 - Subscribe to our Newsletter