Database Design and Basic SQL in PostgreSQL
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.
Buy Now AED 171 + VAT
Monthly Subscription Starting at AED 99 + VAT
- Level Professional
- Duration 14 hours
- Course by University of Michigan
-
Offered by
About
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.
Modules
Lectures
-
4
Videos
-
3
Readings
4
Videos
- Welcome to PostgreSQL!
- History of Relational Databases
- Bonus Video: Elizabeth Fong and SQL Standards
- SQL Architecture
3
Readings
- Help Us Learn More About You
- Syllabus
- Elizabeth Fong and SQL Standards
Assignments
-
2
Videos
-
3
Readings
-
3
ExternalTool
-
1
Assignment
1
Assignment
- Introductory SQL
3
External Tool
- Initial Database Setup
- Making Our First Tables
- Inserting Some Data into a Table
2
Videos
- Using PythonAnywhere to Run SQL
- Using the DBeaver Client to Run SQL Commands
3
Readings
- Assessment Philosophy
- How Assignments Work
- Connecting to Your Database Server
Bonus
-
2
Videos
-
2
ExternalTool
2
External Tool
- A Class Photo Gallery
- A Map of Student Locations
2
Videos
- Dr. Chuck Goes Racing - Joliet, Illinois, USA
- Office Hours - London (Very close to PythonAnywhere)
Lectures
-
3
Videos
3
Videos
- Working with Tables and PostgreSQL
- Data Types in PostgreSQL
- Database Keys and Indexes in PostgreSQL
Assignments
-
1
Videos
-
2
ExternalTool
-
1
Assignment
1
Assignment
- Single Table SQL
2
External Tool
- SERIAL fields / Auto Increment
- Musical Track Database (CSV)
1
Videos
- Musical Track Database (CSV)
Bonus
-
2
Videos
2
Videos
- Dr. Chuck Sings the Blues in Geneva, Switzerland (Near CERN)
- Office Hours - Kyoto, Japan
Lectures
-
7
Videos
7
Videos
- Relational Database Design Part 1
- Relational Database Design Part 2
- Keys
- Database Normalization
- Building Tables
- Inserting Data
- Using JOIN Across Tables
Assignments
-
1
ExternalTool
-
1
Assignment
1
Assignment
- One to Many Data Models
1
External Tool
- Entering Many-to-One Data - Automobiles
Bonus
-
2
Videos
2
Videos
- Office Hours at Bletchley Park, Milton Keynes, England
- Office Hours, Philadelphia, Pennsylvania, USA
Lectures
-
2
Videos
2
Videos
- Many-to-Many Relationships
- Demonstration: Database Design and Many to Many
Assignments
-
1
ExternalTool
-
1
Assignment
1
Assignment
- Many-to-Many Data Models
1
External Tool
- Building a Many-to-Many Roster
Wrap up
-
1
Videos
-
1
Readings
1
Videos
- Up Next - Beyond CRUD (Create, Read, Update, Delete) and JOIN
1
Readings
- Post-Course Survey
Bonus
-
2
Videos
2
Videos
- Office Hours - Capetown, South Africa
- Office Hours - Raleigh, North Carolina, USA
Auto Summary
Discover the essentials of database design and SQL in PostgreSQL with this professional-level course by Coursera. Over 840 minutes, you'll master SQL commands, data modeling, and relational structures through hands-on assignments. Ideal for IT and computer science enthusiasts, this course offers practical skills in creating and managing databases. Available with a Starter subscription.
Charles Russell Severance