Intro To PostgreSQL Databases With PgAdmin For Beginners
Intro To PostgreSQL Databases With PgAdmin For Beginners, available at $64.99, has an average rating of 4.48, with 29 lectures, based on 4261 reviews, and has 17595 subscribers.
You will learn about 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 This course is ideal for individuals who are Anyone who wants to use the PostgreSQL database with the PgAdmin 4 Interface It is particularly useful for Anyone who wants to use the PostgreSQL database with the PgAdmin 4 Interface.
Enroll now: Intro To PostgreSQL Databases With PgAdmin For Beginners
Summary
Title: Intro To PostgreSQL Databases With PgAdmin For Beginners
Price: $64.99
Average Rating: 4.48
Number of Lectures: 29
Number of Published Lectures: 24
Number of Curriculum Items: 29
Number of Published Curriculum Objects: 24
Original Price: $199.99
Quality Status: approved
Status: Live
What You Will Learn
- 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
Who Should Attend
- Anyone who wants to use the PostgreSQL database with the PgAdmin 4 Interface
Target Audiences
- Anyone who wants to use the PostgreSQL database with the PgAdmin 4 Interface
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!
This course is perfect for anyone just starting out, you don’t need any special skills or prior knowledge to take this course.
And as always, we offer a 100% money back guarantee if you aren’t completely happy with the course. No questions asked!
My name is John Elder and I have nearly 40 courses here at udemy, with close to 45,000 students and over 105,000 enrollments. I’ve been writing code and developing neat things online for over 20 years and I’d love to teach you what I know!
What are you waiting for, let’s learn some PostgreSQL database wizardry!
-John Elder
CEO Codemy. com
Course Curriculum
Chapter 1: Introduction
Lecture 1: Introduction
Lecture 2: First Things First: How To Get Support Fast!
Lecture 3: Installing pgAdmin and PostgreSQL
Lecture 4: What Is A Database
Lecture 5: pgAdmin Overview
Lecture 6: Create Table Columns
Lecture 7: Add Data To A Table
Lecture 8: PostgreSQL Select Statements
Lecture 9: PostgreSQL Where Clause
Lecture 10: PostgreSQL Wildcards
Lecture 11: PostgreSQL AND OR NOT
Lecture 12: PostgreSQL Order By
Lecture 13: PostgreSQL Insert Into
Lecture 14: PostgreSQL Update
Lecture 15: PostgreSQL Delete
Lecture 16: PostgreSQL Limit
Lecture 17: pgAdmin Menu Walkthru
Lecture 18: PostgreSQL Foreign Keys
Lecture 19: PostgreSQL Inner Join
Lecture 20: PostgreSQL Join Where Hack
Lecture 21: PostgreSQL Delete Table
Lecture 22: PostgreSQL Import and Export Tables
Lecture 23: PostgreSQL Backup and Restore Database
Lecture 24: Bonus Lecture
Instructors
-
John Elder
Founder of Codemy
Rating Distribution
- 1 stars: 43 votes
- 2 stars: 110 votes
- 3 stars: 670 votes
- 4 stars: 1701 votes
- 5 stars: 1737 votes
Frequently Asked Questions
How long do I have access to the course materials?
You can view and review the lecture materials indefinitely, like an on-demand channel.
Can I take my courses with me wherever I go?
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!
You may also like
- Digital Marketing Foundation Course
- Google Shopping Ads Digital Marketing Course
- Multi Cloud Infrastructure for beginners
- Master Lead Generation: Grow Subscribers & Sales with Popups
- Complete Copywriting System : write to sell with ease
- Product Positioning Masterclass: Unlock Market Traction
- How to Promote Your Webinar and Get More Attendees?
- Digital Marketing Courses
- Create music with Artificial Intelligence in this new market
- Create CONVERTING UGC Content So Brands Will Pay You More
- Podcast: The top 8 ways to monetize by Podcasting
- TikTok Marketing Mastery: Learn to Grow & Go Viral
- Free Digital Marketing Basics Course in Hindi
- MailChimp Free Mailing Lists: MailChimp Email Marketing
- Automate Digital Marketing & Social Media with Generative AI
- Google Ads MasterClass – All Advanced Features
- Online Course Creator: Create & Sell Online Courses Today!
- Introduction to SEO – Basic Principles of SEO
- Affiliate Marketing For Beginners: Go From Novice To Pro
- Effective Website Planning Made Simple