IIRF Online > Development > Database Design & Development > PostgreSQL > Intro To PostgreSQL Databases With PgAdmin For Beginners
Intro To PostgreSQL Databases With PgAdmin For Beginners by Udemy
Intro To SQL and PostgreSQL for Creating Databases and Writing SQL Queries using PostgreSQL and PgAdmin 4
Course Highlights
- 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
Skills you will learn!
Curriculum
24 Topics
Introduction
First Things First: How To Get Support Fast!
Installing 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
Bonus Lecture
Intro To PostgreSQL Databases With PgAdmin For Beginners
Related PostgreSQL Courses
Thank You!
Your review has been submitted successfully.