Source: https://www.udemy.com/course/postgresql-mastery/What you’ll learn
- Master PostgreSQL fundamentals & core concepts
- Set up PostgreSQL on various platforms (local, cloud, containers)
- Create and manage essential database objects (tables, schemas, indexes)
- Perform robust data insertion, modification, and removal using DML
- Write powerful SQL queries for complex data retrieval and analysis
- Utilise PostgreSQL’s diverse data types and functions effectively
- Control database access and security with roles and privileges (DCL)
- Ensure data integrity and reliability using SQL transactions (TCL)
- Analyse and aggregate data using COUNT, SUM, AVG, MIN, MAX, GROUP BY, and HAVING
Requirements
- This course is designed to be beginner-friendly, and we start right from the fundamentals of data management and databases. You won’t need any prior database experience to get started.
- A computer (Windows, macOS, or Linux): We provide comprehensive, hands-on instructions for installing PostgreSQL across all major operating systems, including visual installers like EnterpriseDB for Windows and macOS, and terminal-based methods using package managers like APT, Homebrew, and Chocolatey
- Basic computer literacy: Familiarity with navigating a computer, using a web browser, and managing files is helpful.
- Internet access: To download the necessary software and access the course materials
- A desire to learn: An open mind and a willingness to follow along with the practical examples will be your greatest assets!
- While we delve into cloud-managed and containerised PostgreSQL deployments, you won’t need existing cloud accounts or Docker expertise to begin. We’ll guide you through setting these up from scratch, often leveraging free-tier options for hands-on practice
Download Links
Password: cms.ddpanda.org
