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
New to the cloud and not sure where to begin? This introductory course, taught by cloud experts from The Linux Foundation, will help you grasp the basics of cloud computing and comprehend the... more
L'UX vous intrigue et vous avez un esprit scientifique? L’UX a besoin de vous! L’évaluation UX est une pratique empirique; cette expertise est la plus répandue et la plus recherchée parmi les di... more
Android es la plataforma libre desarrollada por Google, ampliamente utilizada en multitud de dispositivos como móviles, tabletas, TV, wearables e Internet de las cosas. Su expansión ha sido e... more
For over 25 years, SOLIDWORKS has been the trusted industry standard in mechanical design and engineering. Intuitive 3D modeling and product development solutions from SOLIDWORKS help you... more
This course is part of W3C's "Front-End Web Developer" Professional Certificate. JavaScript lets you add interactive features to your Web sites, including dynamically updated content, controlled... more
Powered by
