PostgreSQL

PostgreSQL is an open-source, object-relational database management system (DBMS) known for its robustness, reliability, and extensive features. It provides a scalable and high-performance solution for storing, organizing, and retrieving structured and semi-structured data.

Beginner 0(0 Ratings) 26 Students enrolled English
Created by Hut to Hut Solutions
Last updated Mon, 02-Oct-2023
+ View more
Course overview

PostgreSQL supports a wide range of data types, including numeric, text, JSON, and spatial data, and offers advanced features such as transactions, concurrency control, and full-text search. It also supports SQL queries and supports the integration of programming languages like Python, Java, and C++. With its strong emphasis on standards compliance and extensibility, PostgreSQL is widely used in various industries and applications, from small-scale projects to large enterprise systems.

What will i learn?

  • By completing this course, you will develop a strong understanding of the foundational concepts of databases and querying information
Requirements
  • Being comfortable using a computer for basic tasks
Curriculum for this course
41 Lessons 01:52:07 Hours
Introduction to PostgreSQL - Installing PostgreSQL
2 Lessons 00:12:36 Hours
  • Installing PostgreSQL
    00:12:36
  • Installing PostgreSQL
    0:00:00
Introduction to PostgreSQL - Start and stop PostgreSQL server
2 Lessons 00:02:23 Hours
  • Start and stop PostgreSQL server
    00:02:23
  • Start and stop PostgreSQL server
    0:00:00
Introduction to PostgrSQL - PgAdmin 4 overview
2 Lessons 00:08:21 Hours
  • PgAdmin 4 overview
    00:08:21
  • PgAdmin 4 overview
    0:00:00
Running Queries - Filtering with the WHERE clause
2 Lessons 00:02:53 Hours
  • Filtering with the WHERE clause
    00:02:53
  • Filtering with the WHERE clause
    0:00:00
Connecting to Desktop GIS - Using QGIS desktop to load data
2 Lessons 00:05:51 Hours
  • Using QGIS desktop to load data
    00:05:51
  • Using QGIS desktop to load data
    0:00:00
Running Queries - Using the GROUP BY clause
2 Lessons 00:09:59 Hours
  • Using the GROUP BY clause
    00:09:59
  • Using the GROUP BY clause
    0:00:00
Managing Databases - Setting user rights and privileges
2 Lessons 00:06:44 Hours
  • Setting user rights and privileges
    00:06:44
  • Setting user rights and privileges
    0:00:00
Running Queries - Select with COUNT
2 Lessons 00:02:17 Hours
  • Select with COUNT
    00:02:17
  • Select with COUNT
    0:00:00
Running Queries - Select distinct
2 Lessons 00:02:38 Hours
  • Select distinct
    00:02:38
  • Select distinct
    0:00:00
Running Queries - Select statement
2 Lessons 00:07:25 Hours
  • Select statement
    00:07:25
  • Select statement
    0:00:00
Running Queries - Order By and Aggregate functions
2 Lessons 00:09:29 Hours
  • Order By and Aggregate functions
    00:09:29
  • Order By and Aggregate functions
    0:00:00
Running Quries - HAVING and WHERE clauses with GROUP BY
2 Lessons 00:03:07 Hours
  • HAVING and WHERE clauses with GROUP BY
    00:03:07
  • HAVING and WHERE clauses with GROUP BY
    0:00:00
Running Queries - Filtering with the WHERE IN clause
2 Lessons 00:02:53 Hours
  • Filtering with the WHERE IN clause
    00:02:53
  • Filtering with the WHERE IN clause
    0:00:00
Running Quries - Filtering with the LIKE and I LIKE pattern clauses
2 Lessons 00:08:38 Hours
  • Filtering with the LIKE and I LIKE pattern clauses
    00:08:38
  • Filtering with the LIKE and ILIKE pattern clauses
    0:00:00
Managing Datasets & Items - Creating spatial databases using the GUI
2 Lessons 00:05:30 Hours
  • Creating spatial databases using the GUI
    00:05:30
  • Creating spatial databases using the GUI
    0:00:00
Managing Databases & Items - Creating spatial databases using the query tool
2 Lessons 00:02:43 Hours
  • Creating spatial databases using the query tool
    00:02:43
  • Creating Spatial Databases Using the Query Tool
    0:00:00
Running Queries
1 Lessons 00:01:38 Hours
  • Running queries
    00:01:38
Data Types in PostgreSQL
2 Lessons 00:04:48 Hours
  • Data types in PostgreSQL
    00:04:48
  • Data Types in PostgreSQL
    0:00:00
Managing Databases and Items
1 Lessons 00:04:31 Hours
  • Creating a database with tables
    00:04:31
Using the PostGIS Shapefile Manager
1 Lessons 00:04:27 Hours
  • Using the PostGIS shpapefile manager
    00:04:27
Connecting to Desktop GIS - Using ArcGIS Desktop with PostGIS
2 Lessons 00:03:16 Hours
  • Using ArcGIS Desktop with PostGIS
    00:03:16
  • Using ArcGIS Desktop with PostGIS
    0:00:00
Course Recourses
1 Lessons 00:00:00 Hours
  • Course Materials
    .
Final Assessment
1 Lessons 00:00:00 Hours
  • PostgreSQL Final Assessment
    0:00:00

Frequently asked question

Is this course suitable for beginners
Yes. This course introduces learners to database concepts and the SQL query language
+ View more
Other related courses
03:02:16 Hours
No-Code Database Development
Updated Tue, 12-Dec-2023
0 16 $9.99
About instructor

Hut to Hut Solutions

11 Reviews | 537 Students | 40 Courses
Web Development Design Productivity Tools Information systems Databases GIS
Student feedback
0
0 Reviews
  • (0)
  • (0)
  • (0)
  • (0)
  • (0)

Reviews

Preview this course
$4.99
Includes: