Thank you for your effort, I am really a beginner in SQL language and your tutorials is opening for me to enter in SQL language. I would love to begin my journey with advance level soon. Thanks
PostgreSQL Databases Course With PgAdmin For Beginners
Intro To SQL and PostgreSQL for Creating Databases and Writing SQL Queries using PostgreSQL and PgAdmin 4
Business,Business Analytics & Intelligence,PostgreSQL
Lectures -24
Duration -1.5 hours
30-days Money-Back Guarantee
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
Course Description
PostgreSQL Databases with PgAdmin for Beginners will help you set up and utilize PostgreSQL databases using the PgAdmin 4 interface. There are various databases from which one may choose. However, Postgres is quick, easy to use, and is consistently rated as one of the best databases for anything from simple web development to data analytics.
Course Overview
This PostgreSQL course is perfect for anyone who wants to learn how to use PostgreSQL with PgAdmin 4. The course requires no prior knowledge and offers a 100% 30-day money-back guarantee if you're not completely satisfied with it.
PostgreSQL Job Roles
Database administrator (DBA): DBAs are responsible for the day-to-day administration of databases, including tasks such as installing, configuring, and maintaining databases, as well as monitoring performance and troubleshooting problems.
Data analyst: Data analysts use their skills in SQL and data visualization to extract insights from data and help businesses make better decisions.
Data Engineer: Data engineers build and maintain the infrastructure that stores and processes data. This includes tasks such as designing and implementing data warehouses and pipelines.
Software engineer: Software engineers who work with databases may develop applications that interact with databases, or they may develop tools and utilities for database administration.
Web developer: Web developers who work with databases may develop dynamic websites and web applications that use databases to store and retrieve data.
- Business analyst: Business analysts use their skills in SQL and data analysis to help businesses understand their data and identify opportunities for improvement.
Goals
Use PostgreSQL and PgAdmin 4 to manage a database.
Learn the basics of databases.
Install PostgreSQL and PgAdmin 4 on your computer.
Create a database and table.
Learn how to insert, update, and delete data from a database using PgAdmin 4.
Explore the data in your database using queries.
Create basic reports with the data from your database.
Learn SQL commands, such as SELECT, WHERE, AND, OR, NOT, ORDER BY, and INSERT INTO.
Learn other SQL commands, such as UPDATE, DELETE, LIMIT, INNER JOIN, and more.
Understand primary keys and foreign keys.
Learn how to backup and restore databases and tables.
Prerequisites
Windows, Mac, or Linux computer
You don't need any prior database experience.
Curriculum
Check out the detailed breakdown of what’s inside the course
Introduction
23 Lectures
-
Introduction 02:22 02:22
-
Installing pgAdmin and PostgreSQL 08:48 08:48
-
What Is A Database 06:17 06:17
-
PgAdmin Overview 05:50 05:50
-
Create Table Columns 06:25 06:25
-
Add Data To A Table 07:02 07:02
-
PostgreSQL Select Statements 03:30 03:30
-
PostgreSQL Where Clause 03:56 03:56
-
PostgreSQL Wildcards 03:49 03:49
-
PostgreSQL AND OR NOT 02:52 02:52
-
PostgreSQL Order By 02:40 02:40
-
PostgreSQL Insert Into 02:49 02:49
-
PostgreSQL Update 03:05 03:05
-
PostgreSQL Delete 02:30 02:30
-
PostgreSQL Limit 03:27 03:27
-
PgAdmin Menu Walkthru 05:39 05:39
-
PostgreSQL Foreign Keys 08:50 08:50
-
PostgreSQL Inner Join 07:10 07:10
-
PostgreSQL Join Where Hack 03:49 03:49
-
PostgreSQL Delete Table 02:20 02:20
-
PostgreSQL Import and Export Tables 04:32 04:32
-
PostgreSQL Backup and Restore Database 04:48 04:48
-
Conclusion 04:40 04:40
Instructor Details
![John Elder](https://www.tutorialspoint.com/assets/profiles/216351/profile/200_239454-1594318698.png)
John Elder
Course Certificate
Use your certificate to make a career change or to advance in your current career.
![sample Tutorialspoint certificate](/market/public/assets/newDesign/img/primePacks/V-certificate.png)
Our students work
with the Best
![adobe logo](/market/public/assets/newDesign/img/adobe.png)
![adp logo](/market/public/assets/newDesign/img/adp.png)
![apple logo](/market/public/assets/newDesign/img/apple.png)
![armani logo](/market/public/assets/newDesign/img/armani.jpg)
![bosch logo](/market/public/assets/newDesign/img/bosch.png)
![capegemini logo](/market/public/assets/newDesign/img/capegemini.png)
![cisco logo](/market/public/assets/newDesign/img/cisco.png)
![hdfc bank logo](/market/public/assets/newDesign/img/hdfcbank.png)
![ibm logo](/market/public/assets/newDesign/img/ibm.png)
![intel logo](/market/public/assets/newDesign/img/intel.png)
![mastercard logo](/market/public/assets/newDesign/img/mastercard.png)
![netflix logo](/market/public/assets/newDesign/img/netflix.png)
![qualcomm logo](/market/public/assets/newDesign/img/qualcomm.png)
![samsung logo](/market/public/assets/newDesign/img/samsung.png)
![sony logo](/market/public/assets/newDesign/img/sony.png)
![unilever logo](/market/public/assets/newDesign/img/unilever.png)
![walmart logo](/market/public/assets/newDesign/img/walmart.png)
![adobe logo](/market/public/assets/newDesign/img/adobe.png)
![adp logo](/market/public/assets/newDesign/img/adp.png)
![apple logo](/market/public/assets/newDesign/img/apple.png)
![armani logo](/market/public/assets/newDesign/img/armani.jpg)
![bosch logo](/market/public/assets/newDesign/img/bosch.png)
![capegemini logo](/market/public/assets/newDesign/img/capegemini.png)
![cisco logo](/market/public/assets/newDesign/img/cisco.png)
![hdfcbank logo](/market/public/assets/newDesign/img/hdfcbank.png)
![ibm logo](/market/public/assets/newDesign/img/ibm.png)
![intel logo](/market/public/assets/newDesign/img/intel.png)
![mastercard logo](/market/public/assets/newDesign/img/mastercard.png)
![netflix logo](/market/public/assets/newDesign/img/netflix.png)
![qualcomm logo](/market/public/assets/newDesign/img/qualcomm.png)
![samsung logo](/market/public/assets/newDesign/img/samsung.png)
![sony logo](/market/public/assets/newDesign/img/sony.png)
![unilever logo](/market/public/assets/newDesign/img/unilever.png)
![walmart logo](/market/public/assets/newDesign/img/walmart.png)
Feedbacks
Thanks! Great for beginners like me! : )
Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe now![Annual Membership Annual Membership](/market/public/assets/newDesign/img/membership-large-small.jpg)
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now![Online Certifications Online Certifications](/market/public/assets/newDesign/img/traning-for-a-team.png)