Introduction to PostgreSQL
Get productive with PostgreSQL in two days.
About this course
Get productive with PostgreSQL in two days. You will install and configure the server, connect with psql and manage roles and permissions, write queries with filters, aggregates, GROUP BY and joins, design tables with keys and constraints, then connect your database to Python to automate reports and light ETL tasks.
What you'll learn
- 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 your workflow
Curriculum
- Install and configure PostgreSQL on your local machine
- Create a database and connect to it using psql
- Explore Postgres user roles and permissions
- Use PostgreSQL to manage schemas in an RDBMS context
- Learn SQL syntax to retrieve and filter relational data
- Analyze results using aggregate functions and GROUP BY
- Merge data across tables using JOINs
- Use string operations, logical operators, and conditional expressions
- Compare PostgreSQL’s query syntax to MySQL, Oracle, and MongoDB alternatives
- Create and manage new databases and structured tables
- Apply data types and constraints like primary/foreign keys
- Insert, update, and delete records with SQL
- Ensure relational integrity across multiple tables
- Connect a PostgreSQL database to Python scripts
- Use libraries to query, retrieve, and process data
- Automate reporting tasks and lightweight ETL
- Demonstrate how PostgreSQL supports integration for real-world automation
Who it's for
Analysts, developers and new database users starting out with relational data.
Before you start
No formal prerequisites. Bring curiosity and a willingness to practise.
Related courses
More in Programming & Web Development →AI-3019 Build AI Apps with Azure Database for PostgreSQL
Microsoft Copilot & Azure AI
View course →Cisco Webex Calling Premise-Based PSTN, Configuration, and Troubleshooting (WEBEX-CALL-PSTN)
Cisco
View course →DP-3021 Configure and migrate to Azure Database for PostgreSQL
Microsoft Data & Power BI
View course →Advanced Java 9
Programming & Web Development
View course →Android Studio Development Essentials
Programming & Web Development
View course →Blockchain: An Overview for Business Professionals
Programming & Web Development
View course →Let's plan your next step together.
Tell us the course or certification you have in mind and we'll send the outline, upcoming dates, fees and private-team options.