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
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!
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
Who this course is for:
Anyone who wants to use the PostgreSQL database with the PgAdmin 4 Interface
What you'll 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
Requirements
- You will need a copy of Adobe XD 2019 or above. A free trial can be downloaded from Adobe.
- No previous design experience is needed.
- No previous Adobe XD skills are needed.
