Course overview
The PostgreSQL course covers everything from basic commands to advanced features, including working with complex data types and transactions. You'll learn administration, security, replication, and performance optimization. It's suitable for both beginners and experienced developers looking to enhance their database management skills.
You will learn
Create complex SQL queries for data retrieval and processing
Improve query performance in PostgreSQL
Manage user access to the database
Administer the database
Table of contents
Meet PostgreSQL
Practice
7 min.
Database types
Theory
5 min.
Relational Databases
Theory
5 min.
What is PostgreSQL?
Theory
9 min.
Quiz: Introduction to DBMS
Quiz
8 min.
Overview of SQL
Theory
7 min.
Basic Data Manipulation Commands (DDL)
Practice
15 min.
Advanced SQL Commands for Modifying Tables
Practice
13 min.
Advanced Commands for Modifying Columns
Practice
12 min.
Data Types in SQL
Practice
21 min.
Retrieving Data from Tables
Practice
21 min.
Arithmetic and Comparison Operators
Practice
16 min.
Logical Operators
Practice
15 min.
Data Manipulation Commands
Practice
10 min.
Data Presentation
Practice
16 min.
Indexes for Performance Improvement
Practice
12 min.
Working with Complex Data Types
Practice
20 min.
Regular Expressions
Practice
12 min.
Working with Views
Practice
14 min.
Stored Procedures and Functions
Practice
26 min.
Triggers
Practice
13 min.
Sequences
Practice
10 min.
Transactions, Locks, and Deadlocks
Practice
12 min.
Configuring the PostgreSQL Server
Practice
15 min.
Routine Database Maintenance
Practice
29 min.
Granting and Revoking Privileges
Practice
46 min.
Using Data Encryption
Practice
13 min.
Frequently Asked Questions
A subscription to the platform gives you unlimited access to all courses, as well as access to an online trainer with practical exercises.
Additionally, with a Premium subscription or higher, you also get access to all pet projects and the opportunity to take technical interviews with an AI mentor.
You can cancel your subscription at any time, and you will still have access to the platform for the paid period. You can do this through your personal account in the 'Subscription Management' section.
Yes, you can upgrade to a new plan at any time. We will provide a discount based on the unused time of your current plan. You can change your plan in your personal account.
To request a refund for a paid plan, please contact us at support@upshell.io. We will process your refund for the unused portion of your subscription within 5 business days.
