Intro To PostgreSQL Databases With PgAdmin For Beginners

Intro To PostgreSQL Databases With PgAdmin For Beginners, available at $64.99, has an average rating of 4.48, with 29 lectures, based on 4261 reviews, and has 17595 subscribers.

You will learn about 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 This course is ideal for individuals who are Anyone who wants to use the PostgreSQL database with the PgAdmin 4 Interface It is particularly useful for Anyone who wants to use the PostgreSQL database with the PgAdmin 4 Interface.

Enroll now: Intro To PostgreSQL Databases With PgAdmin For Beginners

Summary

Title: Intro To PostgreSQL Databases With PgAdmin For Beginners

Price: $64.99

Average Rating: 4.48

Number of Lectures: 29

Number of Published Lectures: 24

Number of Curriculum Items: 29

Number of Published Curriculum Objects: 24

Original Price: $199.99

Quality Status: approved

Status: Live

What You Will Learn

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

Who Should Attend

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

Target Audiences

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

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!

My name is John Elder and I have nearly 40 courses here at udemy, with close to 45,000 students and over 105,000 enrollments. I’ve been writing code and developing neat things online for over 20 years and I’d love to teach you what I know!

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

-John Elder

CEO Codemy. com

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Lecture 2: First Things First: How To Get Support Fast!

Lecture 3: Installing pgAdmin and PostgreSQL

Lecture 4: What Is A Database

Lecture 5: pgAdmin Overview

Lecture 6: Create Table Columns

Lecture 7: Add Data To A Table

Lecture 8: PostgreSQL Select Statements

Lecture 9: PostgreSQL Where Clause

Lecture 10: PostgreSQL Wildcards

Lecture 11: PostgreSQL AND OR NOT

Lecture 12: PostgreSQL Order By

Lecture 13: PostgreSQL Insert Into

Lecture 14: PostgreSQL Update

Lecture 15: PostgreSQL Delete

Lecture 16: PostgreSQL Limit

Lecture 17: pgAdmin Menu Walkthru

Lecture 18: PostgreSQL Foreign Keys

Lecture 19: PostgreSQL Inner Join

Lecture 20: PostgreSQL Join Where Hack

Lecture 21: PostgreSQL Delete Table

Lecture 22: PostgreSQL Import and Export Tables

Lecture 23: PostgreSQL Backup and Restore Database

Lecture 24: Bonus Lecture

Instructors

John Elder
Founder of Codemy

Rating Distribution

1 stars: 43 votes
2 stars: 110 votes
3 stars: 670 votes
4 stars: 1701 votes
5 stars: 1737 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

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!

Menu