Database Design and Basic SQL in PostgreSQL
About this Course
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.Created by: The University of Michigan
Level: Intermediate
Related Online Courses
Explore open source networking projects, from The Linux Foundation and beyond, that are shaping the future of networking and telecoms. Designed for open source enthusiasts, university... more
Is your team beginning to use Kubernetes for container orchestration? Do you need guidelines on how to start transforming your organization with Kubernetes and cloud native patterns? Would you like... more
Modern software is under constant attack, but many software developers have never been told how to effectively counter those attacks. This course works to solve that problem, by explaining the... more
Software testing gets a bad rap for being difficult, time-consuming, redundant, and above all - boring. But in fact, it is a proven way to ensure that your software will work flawlessly and can... more
This course is designed to show you how to teach computational thinking to children aged 7-12+. The course will be valuable to you, whether you are new to this approach or an enthusiastic... more
Powered by
