Relational Database and SQL Essentials thumbnail

Back to courses

Relational Database and SQL Essentials

Master table design, data management, and advanced database operations

Level: All (Junior, Mid, Senior Engineers)

author image


Course by

This course includes:

3 Hours

Certification Upon Completion

Lifetime Course Access

Access to Discord group


The tech stack you will in this course

sql logosql
postgres logopostgres
terminal logoterminal

What you'll learn

Database Creation and Table Design

Data Insertion, Retrieval, and Sorting

Advanced Data Filtering and Grouping

Working with Operators and Handling NULLs

Managing Dates and Timestamps

PostgreSQL Constraints

CRUD Operations

Data Relationships

Foreign Keys and Join Operations

Data Export to CSV

Welcome to the Relational Database and SQL Essentials, a deep dive into one of the most versatile open-source relational databases. Master the key aspects of data management, including creating, querying, and managing databases efficiently with SQL. This technical, skill-focused course delivers hands-on experience and provides the essential tools to navigate the dynamic world of Postgres. Enhance your developer skillset and explore the true power of data management with Postgres today!

  • Open Source: PostgreSQL is an open-source database system, meaning it's free and continuously improved by a community of developers
  • Comprehensive SQL Support: PostgreSQL uses and extends the SQL language combined with many features that safely store and scale complicated data workloads
  • Extensibility: PostgreSQL is highly extensible. It supports a number of advanced data types not available in other databases, like arrays and hstore (for key-value pairs)
  • Compatibility: PostgreSQL is compatible with various platforms and programming languages, making it versatile for different types of projects

Who is the course for?

If you want to learn how to use PostgreSQL and SQL, this course is for you. You will discover how to do various tasks, personalize your environment, and enhance your skills with SQL scripting. No matter if you are a student, a professional, a hobbyist, or a beginner, you will learn a lot and quickly. This course will also help you get ready for more advanced PostgreSQL endeavors.

Next.js Logo

4 Reasons to learn PostgreSQL

  1. Versatility: PostgreSQL is an open-source database management system that powers a wide range of applications. By learning PostgreSQL, you gain the ability to work with this versatile platform and expand your opportunities in various industries.
  2. Job Opportunities: PostgreSQL skills are highly sought after in the tech industry. Many companies rely on PostgreSQL for their data management, and professionals with PostgreSQL expertise are in high demand. By mastering PostgreSQL, you enhance your employability and open doors to exciting career opportunities.
  3. Development Environment: PostgreSQL provides a robust and flexible environment for data management. It offers a rich set of tools, making it an ideal choice for developers. Learning PostgreSQL enables you to leverage these resources and enhance your development capabilities.
  4. SQL Proficiency: PostgreSQL emphasizes SQL usage, which helps you develop a deeper understanding of how databases work. SQL skills are invaluable for tasks such as data analysis, automation, and troubleshooting. By mastering SQL, you become a more efficient and effective programmer.
Next.js Logo

Course Curriculum

This course has 16 sections including exercises

Getting Started

1 - Join the Community


2 - Before we start


3 - Newsletter


4 - Exercise Files

5 - What is a Database


6 - SQL - Structured Query Language

7 - SQL And Relational Databases

8 - Postgres


1 - Download Postgres (MAC OS)

2 - Download Postgres (Windows)

3 - GUI Client vs Terminal/CMD Client

4 - Set PSQL (Mac)

5 - Learn SQL the right way

Creating Database

1 - Creating a database


2 - Connecting to databases

3 - A very dangerous command

Creating Tables

1 - Create Table Syntax & Datatypes

2 - Create Table Without Constraints

3 - Create Table With Constraints

Inserting & Querying Data

1 - How to insert (Keynote)

2 - Inserting Data

3 - Retrieving Data

4 - Adding One Thousand Records

5 - Sorting Data

6 - Distinct keyword

Filtering Data

1 - Where Clause & AND

2 - Comparison Operators

3 - Limit, Offset & Fetch

4 - In

5 - Between


Grouping Data

1 - Group By

2 - Having

3 - Creating New Table

4 - Min Max Avg

5 - Sum


1 - The Basics of Arithmetic Operators

2 - Arithmetic Operations On Tables

3 - Aliases

Handling Nulls

1 - Coalesce

2 - Division By Zero with NULLIF

Working With Dates

1 - Timestamps & Dates

2 - Adding and Subtracting Dates With Interval

3 - Extracting Fields From Timestamp

4 - Age Function

Understanding PostgreSQL Constraints

1 - What Are Primary Keys

2 - Working With Primary Keys

3 - Adding Primary Key Constraint

4 - Unique Constraints

5 - Check Constraints

Modifying Data

1 - Deleting Records

2 - Updating Records

3 - Handling Conflicts



1 - Understanding Foreign Keys / Relationships

2 - Adding Relationship (FOREIGN KEY)

3 - Updating Foreign Key Columns

4 - Inner Joins

5 - Left Joins

6 - Deleting Records With Foreign Key

Exporting to CSV

1 - Exporting Query Results to CSV

Sequences, Extensions & UUID

1 - Understanding Sequences

2 - PosgtreSQL Extensions

3 - Generating UUIDs

4 - Using UUID's

Next steps

1 - Next steps

2 - Database Design Course Promo

What our students say

If you have any other questions - please get in touch

I am also grateful for the knowledge and guidance provided by Nelson Djalo, whose teaching style made the learning experience engaging and practical. I would like to express my gratitude to Amigoscode for providing a high-quality learning platform and the opportunity to enhance my software engineering skills. With this newfound expertise, I am excited to further strengthen my proficiency in version control and actively contribute to impactful projects in the software development community.

author image


Senior Developer

Questions & Answers

What makes Amigoscode programming courses different from others?

Amigoscode offers unique, practical, and industry-relevant programming courses taught by experienced instructors. We focus on real-world applications, giving you the skills you need to excel in your career.

Can I purchase your courses through my company's training budget?

Yes, many of our students purchase our courses through their company's training budget. Our courses are considered a valuable investment in employee skill development, and they can be expensed as part of your company's training and development initiatives.

How can Amigoscode courses help me advance my programming career?

Our courses are designed to bridge the gap between theory and practice. You'll gain hands-on experience, work on real projects, and build a portfolio that will impress employers and clients, opening up new opportunities for career growth.

Do you offer any certifications upon course completion?

Yes, we provide certificates of completion for all our courses. These certificates are recognized in the industry, and they can help you showcase your skills to potential employers or clients.

Can I access the course material at my own pace?

Absolutely! Amigoscode courses are self-paced, allowing you to learn at a speed that suits your schedule. You can revisit the material whenever you need, and you have lifetime access to the course content.

Do I need prior programming experience to enroll in your courses?

No, our courses are designed to accommodate all levels of learners. Whether you're a beginner looking to start your programming journey or an experienced developer wanting to enhance your skills, we have courses suitable for you.

What kind of support do I get during the course?

We provide extensive support to our students through discord. You'll have access to a community of learners and can ask questions, share your progress, and collaborate with fellow students. In addition, our instructors are available to help with any challenges you encounter during the course.

What is your refund policy?

We offer a 15-day refund policy. If you're not satisfied with your course within the first 15 days after purchase, we will provide a full refund, no questions asked. Your satisfaction is our priority.

Featured on

business-insider image
docker-captain image
linkedin image
head-first-java image

Relational Database and SQL Essentials

Engage in a dynamic and interactive learning experience as you complete exercises and projects.