The Complete SQL Database in Python Bundle

What's Included

Intro to PostgreSQL Databases with PgAdmin for Beginners

John Elder
23 Lessons (1h)
Lifetime

• Experience level required: Beginner
• Access 23 lectures & 1 hour of content 24/7
• Length of time users can access this course: Lifetime

Course Curriculum

23 Lessons (1h)

• Intro To PostgreSQL Databases With PgAdmin For Beginners
  • Introduction 2:22
  • Install pgAdmin 8:48
  • What Is A Database 6:17
  • PGAdmin Overview 5:50
  • Create Table Columns 6:25
  • Add Data To Table 7:02
  • Select Statements 3:30
  • Where Clause 3:56
  • Wildcards 3:49
  • AND OR NOT 2:52
  • Order By 2:40
  • Insert Into 2:49
  • Update 3:05
  • Delete 2:30
  • Limit 3:27
  • PGAdmin Menu Explained 5:39
  • Foreign Keys 8:50
  • Inner Join 7:10
  • Join Where Hack 3:49
  • Delete Table 2:20
  • Import Export Tables 4:32
  • Backup Restore Entire Database 4:48
  • Conclusion Bonus 4:40

Description

Learn how to set up and use PostgreSQL databases with the PgAdmin 4 interface in just an hour. PostgreSQL is constantly ranked as a top database for everything, from data analytics to basic web development. Postgres is pretty easy to use and you'll be amazed at how quick and easy it is to dive in and get started. With 23 lectures, you'll learn how to install pgAdmin & PostgreSQL, understand what a database is, get a pgAdmin overview, create table columns, add data to a table, learn PostgreSQL tools, and more.

• Access 23 lectures & 1 hour of content 24/7
• Understand how to use PostgreSQL Database w/ PgAdmin 4
• Learn how to put data in & take data out using PgAdmin
• Know SQL Commands such as select, where, and, or, not, order by, insert into, & more
• Understand the basics of what a Database can do
• Learn how to create basic reports w/ the data from your database

Specs

Important Details

• Length of time users can access this course: lifetime
• Access options: web & mobile streaming
• Certification of completion included
• Redemption deadline: redeem your code within 30 days of purchase
• Experience level required: basic

System Requirements