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/
Watch video Differences between PostgreSQL and Other Databases | 3-Week PostgreSQL Workshop | Board Infinity online without registration, duration hours minute second in high quality. This video was added by user Board Infinity 01 January 1970, don't forget to share it with your friends and acquaintances, it has been viewed on our site 42 once and liked it 2 people.