Updated on Apr, 2024
Language - English
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.
PostgreSQL Databases with PgAdmin for Beginners 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
What will you learn in this course:
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
What are the prerequisites for this course?
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
Founder of CodemyJohn 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.
John graduated with honors with a degree in Economics from Washington University in St. Louis where he was an ArtSci Scholar.
Course Certificate
Use your certificate to make a career change or to advance in your current career.
Our students work
with the Best
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
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now