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: