Relational Database EXPLAINED | PostgreSQL Step-by-Step From Scratch
In this PostgreSQL tutorial, we will cover how to create tables and establish table relationships with One-to-Many and Many-to-Many connections step-by-step with a simplified real-world project.
Here, I also provide a few examples of how this is relevant in the real job, including a few notes from my current work as a Senior Data Scientist in one of the leading P&C insurance companies in Canada, Definity, along the way. Definity is always hiring, so check out open positions :-)
With this, we are one step closer to a real-world scenario of working with databases in production. In the next tutorial, I will share how to create postgres DB inside a Docker container and why I would recommend doing so!
========================================
These are the timestamps for your convenience:
00:00 Brief Intro
03:30 One-to-Many
04:17 Tip for Naming Foreign Keys
04:53 How to Insert Values in a Table
05:54 Debugging: How to Change Data Manually in PGAdmin 4 / Atomicity Concept
07:21 One-to-Many / Data Analysis Explained
09:00 My Experiences as a Sr. Data Scientist
09:44 Many-to-Many Relations
10:50 Junction Table - SQL Concept
11:77 Practical Many-to-Many Example
15:37 Data Analysis Example
16:13 Real-Life Example of Fraud Analysis in Insurance
17:53 Teaser to Postgres on Docker (next video)
========================================
What to watch next:
A SQL playlist:
• Machine Learning in SQL? But I Am Python E...
6 Practical SQL Style Guidelines | Google BigQuery | Tips and Tricks
• 6 Practical SQL Style Guidelines | Google ...
PostgreSQL Stored Procedures
• PostgreSQL Stored Procedures EXPLAINED | S...
SQL Procedures Automation. (Triggers)
• SQL Automation | PostgreSQL Triggers EXPLA...
========================================
Ways to connect:
Subscribe!
https://bit.ly/RBrilenkovYT
LinkedIn
/ ruslan-brilenkov
Medium
/ ruslan-brilenkov
========================================
If you are interested in generating royalty-free background music with AI software, check out the Mix.audio tool. It can potentially save you a lot of time. Use the promo link below to get a 30% discount on your first monthly subscription payment, and by doing so, you will also support the channel at no extra cost to you:
https://bit.ly/ruslanpromoAI
========================================
Disclaimer: Everything presented in this video is my own opinion and is intended to educate and share information. Nothing mentioned or described here constitutes legal or financial advice. Ruslan Brilenkov is not responsible for any profits or losses associated with your investment. So, please be responsible for your own actions.