Relational Database EXPLAINED | PostgreSQL Step-by-Step From Scratch скачать в хорошем качестве

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.