5:30 Networking
6:00 Presentation
Exploring PostgreSQL: Features, Strengths, and Comparisons with SQL Server
PostgreSQL has become a powerhouse in the database world, known for its open-source nature and extensive capabilities. This presentation will introduce PostgreSQL, highlighting its strengths and weaknesses, compare it with SQL Server, and delve into its environment setup, basic functionalities, and advanced features.
In this session, we will cover:
● Introduction to PostgreSQL: Learn about PostgreSQL, its core focus areas, and where it excels or may not be ideal for use.
● Comparison: PostgreSQL vs. SQL Server: An in-depth comparison of key aspects like licensing, platform support, data types, tools, performance, support, and backup/recovery options.
● PostgreSQL Environment & Setup: Explore various installation methods (Linux, Windows, macOS, Docker, Cloud-based), initial configurations, and key tools for interacting with PostgreSQL.
● Basic PostgreSQL Functionality: Understand how to connect to PostgreSQL, create schemas and tables, perform data queries, and manage transactions.
● Advanced PostgreSQL Features: Dive into advanced functionalities such as partitioning, Foreign Data Wrappers (FDWs), replication, high availability, performance tuning, and query optimization.
● Recap, Resources, & Q&A: We'll summarize key concepts, provide resources for further learning, and open the floor for questions.
You will leave this session with a comprehensive understanding of PostgreSQL and how it compares to SQL Server, gaining insights into its features, setup, and how it can be leveraged for various data management needs.
Leo Custodio
Leo Custodio is a data specialist and SQL enthusiast with over 15 years of expertise in data analysis, data security, systems architecture, and software design. With a master’s degree in computer science and numerous industry certifications, he has worked extensively with a variety of data science tools, including R, SPSS, Databricks, Spark, and MongoDB, to build robust data infrastructures. His experience spans deriving insights from complex datasets and implementing security measures to protect sensitive information. Passionate about the latest in database technologies, Leo actively shares his knowledge with the technical community, making advanced concepts accessible and practical.
