Master PostgreSQL Administration, Performance Tuning, Security and Backups.
Sub Category
- Database Design & Development
{inAds}
Objectives
- Introduction of PostgreSQL
- Installing and Setting Up PostgreSQL
- PostgreSQL Tools
- Understanding Databases, Tables, and Schemas
- Numeric, Text, Date, Boolean, JSON
- Creating, Updating, and Deleting Tables
- Primary Keys, Foreign Keys, and Constraints
- SELECT, INSERT, UPDATE, and DELETE Statements
- Filtering Data with WHERE, ORDER BY, and LIMIT
- Using DISTINCT, GROUP BY, and HAVING
- INNER, LEFT, RIGHT, FULL
- One-to-One, One-to-Many, and Many-to-Many Relationships
- Composite Keys and Foreign Key Constraints
- JSON and JSONB Data Types in PostgreSQL
- Understanding Indexes in PostgreSQL
- Optimizing Queries for Large Datasets
- Creating and Managing Users and Roles
Pre Requisites
- Basic SQL knowledge is helpful but not required
- No prior PostgreSQL administration experience needed
FAQ
- Q. How long do I have access to the course materials?
- A. You can view and review the lecture materials indefinitely, like an on-demand channel.
- Q. Can I take my courses with me wherever I go?
- A. Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
{inAds}
Coupon Code(s)