Introduction to PostgreSQL
Hands-on introduction to PostgreSQL covering setup, querying relational data with SQL, creating and managing databases and tables with constraints, and integrating PostgreSQL with Python for automation and reporting, plus context versus MySQL, Oracle, and MongoDB.
What you'll learn
- Understand PostgreSQL’s role among relational and open-source databases
- Set up and connect to a PostgreSQL database using standard tools
- Write SQL queries to extract, filter, aggregate, and join relational data
- Create and manage databases, tables, data types, and constraints
- Integrate PostgreSQL with Python for automation, ETL, and reporting
Skills you'll gain
- Set up and connect to a PostgreSQL database using standard tools
- Write SQL queries to extract, filter, and aggregate relational data
- Create and manage structured databases and tables with constraints
- Integrate PostgreSQL with Python to automate and extend workflows
- Compare PostgreSQL capabilities with MySQL, Oracle, and MongoDB
- Use joins, aggregate functions, and conditional expressions in SQL
- Apply data types and primary/foreign key constraints to ensure integrity
- Automate reporting tasks and lightweight ETL using PostgreSQL and Python
Provider
New Horizons
Related Courses
Python Certification
This course teaches you the fundamentals of Python programming and guides you through projects and an exam to earn a Python Certification on freeCodeCamp.
Certificate in Systems Analysis and Design (CSAD)
EPOL 472: Instructional and Training System Design
Provides instruction and practice in selecting, organizing, and preparing content for instructional programs in business and technical settings, offering a theoretical orientation to instructional design and hands-on experience developing instructional materials.
Ace The Machine Learning System Design Interview
A focused 59-minute course that teaches a repeatable system for ML system design interviews, emphasizing structure, communication, real-world trade-offs, and what interviewers actually care about so you can demonstrate seniority and pass with confidence.
Low Level Design BootCamp @SUPRA Batch
A comprehensive Low Level Design program covering fundamentals, OOP, UML, SOLID principles, design patterns, and real-world design problems to prepare beginners and experienced programmers for technical interviews and placement exams.
Learn TypeScript
TypeScript has been gaining incredible market share against vanilla JavaScript in recent years. Master TypeScript from start to finish in this comprehensive, immersive, hands-on course while solving real-world type challenges each step of the way.