The Complete SQL Database in Python Bundle

3 Reviews
422 Enrolled
5 Courses & 7 Hours
$19.00$1,000.00
You save 98% -

What's Included

Intro to PostgreSQL Databases with PgAdmin for Beginners
  • Certification included
  • 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
    Introduction2:22
    Install pgAdmin8:48
    What Is A Database6:17
    PGAdmin Overview5:50
    Create Table Columns6:25
    Add Data To Table7:02
    Select Statements3:30
    Where Clause3:56
    Wildcards3:49
    AND OR NOT2:52
    Order By2:40
    Insert Into2:49
    Update3:05
    Delete2:30
    Limit3:27
    PGAdmin Menu Explained5:39
    Foreign Keys8:50
    Inner Join7:10
    Join Where Hack3:49
    Delete Table2:20
    Import Export Tables4:32
    Backup Restore Entire Database4:48
    Conclusion Bonus4:40

Intro to PostgreSQL Databases with PgAdmin for Beginners

JE
John Elder

Instructor

John Elder is a pioneer in Web Development who created one of the first Internet advertising networks back in 1997. He sold it to a publicly-traded company at the height of the dot com boom and then went on to create the best-selling Submission-Spider search engine submission software that's been used by over 3 million individuals and small businesses in over 45 countries.

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

  • PC or Mac
  • Internet access required

Terms

  • Unredeemed licenses can be returned for store credit within 30 days of purchase. Once your license is redeemed, all sales are final.