AmigosCode - Advanced Databases (39 files)
 1-installing-postgres-00-03-34.mp4 |
25.26MB |
| 2-datagrip-00-03-07.mp4 |
22.52MB |
| 3-installing-datagrip-00-02-28.mp4 |
21.51MB |
| 4-configure-datagrip-00-05-15.mp4 |
34.07MB |
| 5-presentation-assistant-and-keymaps-00-03-05.mp4 |
8.98MB |
| 6-connecting-to-databases-using-terminal-00-07-49.mp4 |
43.45MB |
| 7-create-database-using-datagrip-00-01-42.mp4 |
5.62MB |
| 8-joins-00-04-08.mp4 |
21.99MB |
| 9-inner-joins-00-09-34.mp4 |
40.45MB |
| 10-left-joins-00-04-06.mp4 |
17.78MB |
| 11-right-join-00-03-23.mp4 |
15.82MB |
| 12-full-join-00-01-41.mp4 |
7.81MB |
| 13-inner-outer-joins-00-01-49.mp4 |
8.92MB |
| 14-why-transactions-00-04-51.mp4 |
16.88MB |
| 15-begin-commit-and-rollback-00-05-13.mp4 |
16.88MB |
| 16-nested-transactions-00-03-59.mp4 |
12.47MB |
| 17-primary-keys-and-indexes-00-04-40.mp4 |
14.52MB |
| 18-view-indexes-trough-terminal-00-03-55.mp4 |
10.56MB |
| 19-create-and-drop-indexes-00-04-34.mp4 |
16.27MB |
| 20-indexes-in-action-00-06-59.mp4 |
25.32MB |
| 21-multi-column-indexes-00-05-04.mp4 |
14.94MB |
| 22-unique-indexes-00-07-59.mp4 |
33.24MB |
| 23-partial-indexes-00-04-56.mp4 |
17.09MB |
| 24-function-skeleton-00-03-41.mp4 |
9.44MB |
| 25-create-functions-00-06-13.mp4 |
19.83MB |
| 26-view-and-drop-functions-00-01-59.mp4 |
5.62MB |
| 27-roles-00-03-12.mp4 |
10.40MB |
| 28-view-roles-00-04-05.mp4 |
11.81MB |
| 29-creating-roles-00-04-17.mp4 |
8.30MB |
| 30-privileges-00-05-50.mp4 |
15.38MB |
| 31-revoking-permissions-00-01-15.mp4 |
2.98MB |
| 32-member-roles-00-03-23.mp4 |
8.45MB |
| 33-what-are-schemas-00-03-35.mp4 |
8.88MB |
| 34-create-schemas-00-05-45.mp4 |
13.74MB |
| 35-schema-search-path-00-04-14.mp4 |
10.36MB |
| 36-grant-schema-usage-00-03-45.mp4 |
6.81MB |
| 37-backing-up-databases-00-04-38.mp4 |
21.37MB |
| 38-restore-database-00-04-42.mp4 |
14.68MB |
| 39-backup-all-databases-00-02-43.mp4 |
11.83MB |
Type: Course
Bibtex:
Tags:
Bibtex:
@article{,
title= {AmigosCode - Advanced Databases},
journal= {},
author= {},
year= {},
url= {},
abstract= {Embark on a journey to master advanced database concepts essential for crafting production-grade applications. As a software engineer, understanding these concepts will empower you to develop robust backend applications while gaining a comprehensive understanding of the underlying processes. This course will equip you with knowledge and skills in:
Joins: Learn how to effectively link data from two or more tables, a fundamental aspect of relational databases.
Indexes: Understand how to optimize your databases for faster, more efficient data retrieval.
Transactions: Gain insights into how databases maintain integrity even in the event of system failures.
Database Administration: Acquire the skills needed to manage and maintain a database system effectively.
Functions / Stored Procedures: Learn how to use these powerful tools to encapsulate and automate common database tasks.
Schemas: Understand the role of schemas in organizing database objects and controlling user access.
Database Backups: Learn the importance of regular backups and how to implement them to protect your data.},
keywords= {},
terms= {},
license= {},
superseded= {}
}