Скачать или смотреть Differences between PostgreSQL and Other Databases | 3-Week PostgreSQL Workshop | Board Infinity

Want to brush up on your database skills with PostgreSQL? Understand and master the various tools you have at your disposal when working with a relational database.

This is the second 2-hour session on differences between PostgreSQL and Other Databases taken by Coach Karmugilan. He has 5 years of experience with strong expertise in R, Python, SQL, Excel & Tableau, Machine learning, Deep learning algorithms & BI solutions for Data and Business Analytics.

The following topics will be covered -

PostgreSQL vs MySQL
The Path of a Query
Additional Output Formats
Describing Explain Output
Adding the ANALYZE Option
Test and Rollback
Analyze a Join Statement Tools Used: PostgreSQL Skills: Query Language

Timestamps:-
0:00 - Introduction
2:49 - Workshop Agenda
8:06 - Overview of PG admin
23:12 - Data Types
25:20 - What is SQL and Postgre SQL?
26:06 - Difference between Postgre SQL and other Databases
27:03 - Datatypes supported - Traditional
40:16 - Datatypes supported - Complex
50:48 - Other Datatypes supported
1:07:50 - Views
1:13:07 - Triggers
1:15:32 - Quick Recap

-------------------------

Say Hello to us on Social Media:
► Follow us on Instagram: https://bit.ly/3q3jsMS
► Follow us on Facebook: https://bit.ly/3hTq2Te
► Follow us on LinkedIn: https://bit.ly/3noYMgl
► Follow us on Twitter: https://bit.ly/3s6I35d

Learn more about our courses: https://www.boardinfinity.com/