4.48 out of 5
4.48
80 reviews on Udemy

Intro To PostgreSQL Databases With PgAdmin For Beginners

Intro To SQL and PostgreSQL for Creating Databases and Writing SQL Queries using PostgreSQL and PgAdmin 4
Instructor:
John Elder
3,163 students enrolled
English [Auto-generated]
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

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

Introduction

1
Introduction
2
First Things First: How To Get Support Fast!

Check out my student Facebook Group...

It's a great place to get fast support for this course from me, to interact with other students, to post your projects and code, and to access course announcements and extras...

Join Now!

https://www.facebook.com/groups/codemycom/

3
Installing pgAdmin and PostgreSQL
4
What Is A Database
5
pgAdmin Overview
6
Create Table Columns
7
Add Data To A Table
8
PostgreSQL Select Statements
9
PostgreSQL Where Clause
10
PostgreSQL Wildcards
11
PostgreSQL AND OR NOT
12
PostgreSQL Order By
13
PostgreSQL Insert Into
14
PostgreSQL Update
15
PostgreSQL Delete
16
PostgreSQL Limit
17
pgAdmin Menu Walkthru
18
PostgreSQL Foreign Keys
19
PostgreSQL Inner Join
20
PostgreSQL Join Where Hack
21
PostgreSQL Delete Table
22
PostgreSQL Import and Export Tables
23
PostgreSQL Backup and Restore Database
24
Bonus
You can view and review the lecture materials indefinitely, like an on-demand channel.
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!
4.5
4.5 out of 5
80 Ratings

Detailed Rating

Stars 5
39
Stars 4
23
Stars 3
12
Stars 2
5
Stars 1
2
1209dd984576b477b33eb0c6340ec214
30-Day Money-Back Guarantee

Includes

2 hours on-demand video
1 article
Full lifetime access
Access on mobile and TV
Certificate of Completion