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
The Internet of Things (IoT) is expanding at a rapid rate, and it is becoming increasingly important for professionals to understand what it is, how it works, and how to harness its power to... more
I sistemi di database sono diventati fondamentali nei sistemi di gestione delle informazioni, contribuendo allo sviluppo di una società sempre più basata sulla conoscenza. Tutte le moderne a... more
What is good game design? How do you come up with good game ideas? How do you start documenting your ideas? How do you create an experience? How do you write a rule book? These are some of the... more
The modern data analysis pipeline involves collection, preprocessing, storage, analysis, and interactive visualization of data. The goal of this course, part of the Analytics: Essential Tools and... more
Building on your prior knowledge of variables and operators, this course gets into the meat of programming. Organized into five chapters, this course starts by covering the fundamentals of what... more
Powered by
