Overview
Dive into a comprehensive one-hour tutorial on PostgreSQL for beginners. Learn the fundamentals of databases, install PostgreSQL on your system, and gain hands-on experience creating databases and tables using CREATE commands. Master essential PostgreSQL clauses like SELECT, WHERE, JOIN, and GROUP BY to effectively retrieve, manipulate, filter, and aggregate data. Explore advanced concepts and discover the powerful features that make PostgreSQL a popular, versatile, and extensible open-source database management system. By the end of this tutorial, you'll have a solid foundation in PostgreSQL and be ready to apply your new skills to real-world data management tasks.
Syllabus
Beginning
Introduction to Database
Introduction to PostgreSQL
Features of PostgreSQL
Installation of PostgreSQL
SQL Shell Hands-on
Pg Admin Hands-on
Clauses in PostgreSQL
Advanced Concepts in PostgreSQL
Taught by
Great Learning