Video description
Create databases and write SQL queries using PostgreSQL and PgAdmin 4
About This Video
- Learn to install PostgreSQL and PgAdmin 4
- Discover how to use PostgreSQL databases with PgAdmin 4
In Detail
Although there are a variety of databases to choose from, PostgreSQL is constantly ranked as a top database for everything from data analytics to basic web development.
With this interactive course, you’ll learn how to set up and use PostgreSQL databases with the PgAdmin 4 interface. You’ll start by learning how to install PgAdmin and PostgreSQL, along with understanding all about a database. Next, the course will help you develop the skills you need to create table columns. You’ll then use a variety of SQL commands to easily add, sort, update, delete, and perform other data management tasks. Toward the end, the course will help you grasp the technique of relating data between tables with the help of inner join. In addition to this, you will be able to use the WHERE clause to filter results from statements such as INSERT, DELETE, UPDATE, and SELECT.
By the end of this book, you will have developed the skills you need to confidently manage data using PostgreSQL and PgAdmin.
Table of contents
-
Chapter 1 : Introduction
- Introduction 00:01:34
- Installing pgAdmin and PostgreSQL 00:08:48
- What Is A Database 00:06:17
- pgAdmin Overview 00:05:51
- Create Table Columns 00:06:26
- Add Data To A Table 00:07:03
- PostgreSQL Select Statements 00:03:31
- PostgreSQL Where Clause 00:03:56
- PostgreSQL Wildcards 00:03:49
- PostgreSQL AND OR NOT 00:02:52
- PostgreSQL Order By 00:02:40
- PostgreSQL Insert Into 00:02:50
- PostgreSQL Update 00:03:05
- PostgreSQL Delete 00:02:31
- PostgreSQL Limit 00:03:27
- pgAdmin Menu Walkthru 00:05:40
- PostgreSQL Foreign Keys 00:08:51
- PostgreSQL Inner Join 00:07:10
- PostgreSQL Join Where Hack 00:03:49
- PostgreSQL Delete Table 00:02:21
- PostgreSQL Import and Export Tables 00:04:32
- PostgreSQL Backup and Restore Database 00:04:49
- Bonus 00:00:49
Product information
- Title: Introduction to PostgreSQL Databases with PgAdmin for Beginners
- Author(s):
- Release date: May 2019
- Publisher(s): Packt Publishing
- ISBN: 9781838983062
You might also like
video
Python Fundamentals
51+ hours of video instruction. Overview The professional programmer’s Deitel® video guide to Python development with …
book
Practical SQL
"Practical SQL is an approachable and fast-paced guide to SQL (Structured Query Language), the standard programming …
book
Learning PostgreSQL 11
Leverage the power of PostgreSQL 11 to build powerful database and data warehousing applications Key Features …
video
Linux Fundamentals
10+ Hours of Video Instruction Linux Fundamentals LiveLessons has more than 10 hours of comprehensive video …