Explore

Database Design and Basic SQL in PostgreSQL

Approx. 13 hours to complete

Save Course

Go to Course

Course Summary

Learn how to design and implement a database using PostgreSQL. This course covers database modeling, normalization, schema creation, SQL statements, and more.

Key Learning Points

Understand the principles of database design and normalization
Learn how to create and manage schemas using PostgreSQL
Write complex SQL statements to query and manipulate data

Job Positions & Salaries of people who have taken this course might have

- USA: $77,080
- India: ₹5,00,000
- Spain: €32,000
- USA: $77,080
- India: ₹5,00,000
- Spain: €32,000
- USA: $62,453
- India: ₹4,00,000
- Spain: €28,000
- USA: $77,080
- India: ₹5,00,000
- Spain: €32,000
- USA: $62,453
- India: ₹4,00,000
- Spain: €28,000
- USA: $73,760
- India: ₹6,00,000
- Spain: €35,000

Learning Outcomes

Understand the fundamental principles of database design
Implement a database schema using PostgreSQL
Write complex SQL statements to query and manipulate data

Prerequisites or good to have knowledge before taking this course

Basic understanding of SQL
Familiarity with relational databases

Course Difficulty Level

Intermediate

Course Format

Online
Self-paced

Similar Courses

SQL for Data Analysis
Database Management Essentials

Related Education Paths

Related Books

Description

In this course you will learn more about the historical design of databases and the use of SQL in the PostgreSQL environment. Using SQL techniques and common commands (INSERT INTO, WHERE, ORDER BY, ON DELETE CASCADE, etc) will enable you to create tables, column types and define the schema of your data in PostgreSQL. You will learn about data modeling and how to represent one-to-many and many-to-many relationships in PostgreSQL. Students will do hands-on assignments creating tables, inserting data, designing data models, creating relational structures and inserting and querying relational data in tables.

Knowledge

Utilize psql and SQL commands to implement CRUD (Create, Read, Update, and Delete) operations for tables in a PostgreSQL database.
Identify and utilize the functions of primary, logical, and foreign keys within a database.
Build and differentiate between one-to-many and many-to-many relationships within PostgreSQL.
Recall key people, organizations, and innovations that were instrumental to building the SQL standard

Outline

Introduction to SQL
Welcome to PostgreSQL!
History of Relational Databases
Bonus Video: Elizabeth Fong and SQL Standards
SQL Architecture
Using PythonAnywhere to Run SQL
Using the DBeaver Client to Run SQL Commands
Dr. Chuck Goes Racing - Joliet, Illinois, USA
Office Hours - London (Very close to PythonAnywhere)
Help Us Learn More About You
Elizabeth Fong and SQL Standards
Assessment Philosophy
How Assignments Work
Connecting to Your Database Server
Introductory SQL

Single Table SQL
Working with Tables and PostgreSQL
Data Types in PostgreSQL
Database Keys and Indexes in PostgreSQL
Musical Track Database (CSV)
Dr. Chuck Sings the Blues in Geneva, Switzerland (Near CERN)
Office Hours - Kyoto, Japan
Single Table SQL

One-To-Many Data Models
Relational Database Design Part 1
Relational Database Design Part 2
Keys
Database Normalization
Building Tables
Inserting Data
Using JOIN Across Tables
Office Hours at Bletchley Park, Milton Keynes, England
Office Hours, Philadelphia, Pennsylvania, USA
One to Many Data Models

Many-To-Many Data Models
Many-to-Many Relationships
Demonstration: Database Design and Many to Many
Up Next - Beyond CRUD (Create, Read, Update, Delete) and JOIN
Office Hours - Capetown, South Africa
Office Hours - Raleigh, North Carolina, USA
Post-Course Survey
Many-to-Many Data Models

Summary of User Reviews

This course on database design using PostgreSQL has received high praise from users for its comprehensive content and practical approach. Many users found the instructor to be engaging and knowledgeable, making the course both informative and enjoyable.

Key Aspect Users Liked About This Course

The course content is comprehensive and practical

Pros from User Reviews

The instructor is engaging and knowledgeable
The course covers a wide range of topics related to database design
The course includes practical exercises and assignments that help reinforce the concepts learned
The course is suitable for both beginners and advanced learners
The course is well-structured and easy to follow

Cons from User Reviews

Some users found the course to be too basic and lacking in depth
Some users had technical issues with the platform or software used in the course
Some users found the pacing of the course to be too slow or too fast
Some users felt that the course could benefit from more interactive elements or live sessions
Some users found the course to be too theoretical and lacking in real-world examples

Recommended for you

SQL Developer Skills For Beginners

Learn SQL Developer Skills SQL Developers are in demand due to the increasing reliance on data. Becoming a SQL developer can be a very rewarding and fulfilling career....

Save Course

Data Engineering with Google BigQuery & Google Cloud

Building data pipeline with BigQuery, Data Studio, and other Google Cloud. Learn basic BigQuery sql & techniques. BigQuery is Google’s product for data warehouse....

Save Course