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!
