PostgreSQL Schema Search Path

Published: 20 August 2024
on channel: Very Academy
200
13

Advanced Database Structural Testing | PostgreSQL Schema Search Path

Playlist:


Udemy Course:


Source Code:


This module is designed to equip learners with advanced skills in database schema management, automated testing, and workflow integration using modern tools like PostgreSQL, Django, and Docker. Through a blend of theoretical knowledge and hands-on exercises, participants will explore structural testing, schema creation, and advanced features such as Docker HealthCheck, Pytest fixtures, and Django migrations.

Key topics include creating and managing PostgreSQL schemas, setting up testing workflows with Docker, utilising Pytest for validating table structures and relationships, and enforcing custom constraints. Learners will also gain practical experience in building test databases, working with FactoryBoy and Faker for model factories, and testing stored procedures and triggers.

By the end of this module, learners will be able to effectively manage complex database schemas, automate testing workflows, and integrate these processes within a Dockerized environment to ensure robust and scalable applications.


Watch video PostgreSQL Schema Search Path online without registration, duration 14 minute 51 second in high hd quality. This video was added by user Very Academy 20 August 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 200 once and liked it 13 people.