University of Michigan - Database Design and Basic SQL in PostgreSQL
5.0 /5- Offered byCoursera
Database Design and Basic SQL in PostgreSQL at Coursera Overview
Duration | 13 hours |
Start from | Start Now |
Total fee | Free |
Mode of learning | Online |
Difficulty level | Intermediate |
Official Website | Explore Free Course  |
Credential | Certificate |
Database Design and Basic SQL in PostgreSQL at Coursera Highlights
- Shareable Certificate Earn a Certificate upon completion
- 100% online Start instantly and learn at your own schedule.
- Course 1 of 4 in the PostgreSQL for Everybody Specialization
- Flexible deadlines Reset deadlines in accordance to your schedule.
- Intermediate Level Completion of the first two courses in the Python for Everybody specialization or an equivalent basic understanding of Python
- Approx. 13 hours to complete
- English Subtitles: English
Database Design and Basic SQL in PostgreSQL at Coursera Course details
- 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.
Database Design and Basic SQL in PostgreSQL at Coursera Curriculum
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
Database Design and Basic SQL in PostgreSQL at Coursera Admission Process
Important Dates
Other courses offered by Coursera
Student Forum
Anything you would want to ask experts?