PostgreSQL Tutorial Full Course 2022

Course Feature

Cost

Free
Provider

Youtube
Certificate

Paid Certification
Language

English
Start Date

On-Demand
Learners

No Information
Duration

4.00
Instructor

Derek Banas

Add to Favorites

2.0

2 Ratings

This course provides an introduction to PostgreSQL, a powerful open-source database. It covers why Postgres is useful, how to design and create a database, and how to add and view data. It also covers custom types, functions, and triggers. By the end of the course, users will have a comprehensive understanding of PostgreSQL.

Show All

Go to class

Course Overview

❗The content presented here is sourced directly from Youtube platform. For comprehensive course details, including enrollment information, simply click on the 'Go to class' link on our website.

Updated in [February 21st, 2023]

Intro
Why Use Postgres?
What is a Database
Change Database Theme
Create a Database
Design a Database
Turn Invoice into a Database
Make a Table
Data Types
Adding Data to Table
To See Data
SELECT
Create Custom Type
Change Column Data Type
Thinking About Tables
Breaking Up Tables
Primary & Foreign Keys
Foreign & Primary Keys
Altering Tables Many Examples
Getting Data from One Table
Where
Conditional Operators
Logical Operators
Order By
Limit
GROUP BY
Distinct
Getting Data from Multiple Tables
Inner Join
Join 3 Tables
Arithmetic Operators
Join with Where
Outer Joins
Cross Joins
Unions
Extract
IS NULL
SIMILAR LIKE & ~
GROUP BY
HAVING
AGGREGATE FUNCTIONS
WORKING WITH VIEWS
SQL Functions
Dollar Quotes
Functions that Return Void
Get Maximum Product Price
Get Total Value of Inventory
Get Number of Customers
Named Parameters
Return a Row & Composite
Get Multiple Rows
PL&pgSQL
Variables in Functions
Store Rows in Variables
IN INOUT and OUT
Using Multiple Outs
Return Query Results
IF ELSEIF and ELSE
CASE Statement
Loop Statement
FOR LOOP
Result Sets Blocks & Raise Notice
For Each and Arrays
While Loop
Continue
Stored Procedures
Triggers
Cursors
Installation

Show All

Recommended Courses

PostgreSQL Tips From a Pro Cloud Simplified

1.5

Youtube 1 learners

Learn More

This course provides an introduction to PostgreSQL, a powerful open source database. It covers topics such as getting started, creating a new user and database, creating a database backup, restoring after a hack, and useful extensions. It also provides tips and shortcuts from a pro, as well as instructions on how to drop a database. This course is ideal for those looking to learn the basics of PostgreSQL.

Intro To PostgreSQL Databases With PgAdmin For Beginners

4.5

Udemy 0 learners

Learn More

Learn how to use PostgreSQL databases with PgAdmin 4 in this course! With no prior knowledge or special skills required, you'll be amazed at how quick and easy it is to dive in and get started. You'll learn how to install PostgreSQL and PgAdmin 4, create databases and tables, add data, write SQL queries, and more. Plus, you'll get to explore why Postgres is so popular and why it's constantly ranked a top database for everything from data analytics to basic web development. With a 100% money back guarantee, what are you waiting for? Let's learn some PostgreSQL database wizardry!

PostgreSQL: Client Applications

5.0

LinkedIn Learning 0 learners

Learn More

This course provides an introduction to the PostgreSQL command line utilities, which are essential tools for database administrators. It covers the basics of how to use the utilities to manage remote database servers, as well as more advanced topics such as creating and managing databases, users, and tables. With this course, you will gain the knowledge and skills needed to effectively manage PostgreSQL databases.

Mastering SQL using Postgresql

4.5

Udemy 0 learners

Learn More

Mastering SQL using Postgresql is a course designed to help professionals gain key database skills for application development, data engineering, testing, business analysis and more. Learn how to create database objects, write effective queries, setup Postgres Database using Docker, connect to Postgres using different interfaces, understand utilities to load the data, perform CRUD or DML Operations, create tables, constraints and indexes, use pre-defined functions provided by Postgresql and more. This self-paced course includes reference material, code snippets and videos to help you gain the skills you need.