Tutorialspoint

Introduction To PostgreSQL Databases With PgAdmin For Beginners

Intro To SQL and PostgreSQL for Creating Databases and Writing SQL Queries using PostgreSQL and PgAdmin 4

Description

In this course I'll teach you how to setup and use PostgreSQL databases with the PgAdmin 4 interface! 

There's a reason why Postgres is so popular, find out why in this course!

You have many databases to choose from, and even many free databases to choose from. But Postgresql is constantly ranked a top database for everything from data analytics to basic web development - and everything in between. 

Postgres is pretty easy to use!  You'll be amazed at how quick and easy it is to dive in and get started!

In this course, you learn to:

  • Install pgAdmin and PostgreSQL

  • What Is A Database

  • pgAdmin Overview

  • Create Table Columns

  • Add Data To A Table

  • PostgreSQL Select Statements

  • PostgreSQL Where Clause

  • PostgreSQL Wildcards

  • PostgreSQL AND OR NOT

  • PostgreSQL Order By

  • PostgreSQL Insert Into

  • PostgreSQL Update

  • PostgreSQL Delete

  • PostgreSQL Limit

  • pgAdmin Menu Walkthru

  • PostgreSQL Foreign Keys

  • PostgreSQL Inner Join

  • PostgreSQL Join Where Hack

  • PostgreSQL Delete Table

  • PostgreSQL Import and Export Tables

  • PostgreSQL Backup and Restore Database

  • And More!

This course is perfect for anyone just starting out, you don't need any special skills or prior knowledge to take this course.

And as always, we offer a 100% money back guarantee if you aren't completely happy with the course.  No questions asked!

What are you waiting for, let's learn some PostgreSQL database wizardry!

-John Elder

CEO Codemy. com

Who this course is for:

  • Anyone who wants to use the PostgreSQL database with the PgAdmin 4 Interface

Goals

  • Understand how to use PostgreSQL Database with PgAdmin 4
  • Understand the basics of what a Database can do
  • How to Install PostgreSQL and PgAdmin 4
  • You'll Learn How To Create a Database and Table
  • How to put data in and take data out using PgAdmin
  • How to update and delete data from the database
  • How to explore what's in the database whenever you want
  • How to create basic reports with the data from your database
  • SQL Commands such as SELECT, WHERE, AND, OR, NOT, ORDER BY, and INSERT INTO
  • SQL Commands like UPDATE, DELETE, LIMIT, INNER JOIN, and more
  • All about Primary Keys
  • All About Foreign Keys
  • How To Backup and Restore Database
  • How To Backup and Restore Tables

Prerequisites

  • You don't need any special tools, we'll download everything we need for free. You just need a Windows, Mac, or Linux computer
  • You don't need any prior database experience, I'll walk you through everything
Show More

Curriculum

  • Introduction
    02:22
    Preview
  • Installing pgAdmin and PostgreSQL
    08:48
    Preview
  • What Is A Database
    06:17
    Preview
  • PgAdmin Overview
    05:50
  • Create Table Columns
    06:25
  • Add Data To A Table
    07:02
  • PostgreSQL Select Statements
    03:30
  • PostgreSQL Where Clause
    03:56
  • PostgreSQL Wildcards
    03:49
  • PostgreSQL AND OR NOT
    02:52
  • PostgreSQL Order By
    02:40
  • PostgreSQL Insert Into
    02:49
  • PostgreSQL Update
    03:05
  • PostgreSQL Delete
    02:30
  • PostgreSQL Limit
    03:27
  • PgAdmin Menu Walkthru
    05:39
  • PostgreSQL Foreign Keys
    08:50
  • PostgreSQL Inner Join
    07:10
  • PostgreSQL Join Where Hack
    03:49
  • PostgreSQL Delete Table
    02:20
  • PostgreSQL Import and Export Tables
    04:32
  • PostgreSQL Backup and Restore Database
    04:48
  • Conclusion
    04:40
Feedbacks
4.3
Course Rating
33%
67%
0%
0%
0%

    Feedbacks (3)

  • Sujeet Toppo
    Sujeet Toppo

    Thank you for your effort, I am really a beginner in SQL language and your tutorials is opening for me to enter in SQL language. I would love to begin my journey with advance level soon. Thanks

  • Norma Espinosa
    Norma Espinosa

    Thanks! Great for beginners like me! : )

  • Viswa Manaswini Pisapaty
    Viswa Manaswini Pisapaty

Introduction To PostgreSQL Databases With PgAdmin For Beginners
This Course Includes
  • 1.5 hours
  • 23 Lectures
  • Completion Certificate
  • Lifetime Access
  • 30-Days Money Back Guarantee

Sample Certificate

Use your certification to make a career change or to advance in your current career. Salaries are among the highest in the world.

We have 30 Million registgered users and counting who have advanced their careers with us.

X

Sample Certificate