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/
Смотрите видео Differences between PostgreSQL and Other Databases | 3-Week PostgreSQL Workshop | Board Infinity онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Board Infinity 01 Январь 1970, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 42 раз и оно понравилось 2 людям.