UNIVERSITY OF MICHIGAN · UNITED STATES
Database Design and Basic SQL in PostgreSQL
Certificate · Taught in en
At a glance
—
Duration
—
IELTS
—
Tuition / yr
en
Language
Certificate
Level
- 100% OnlineFormat
- Self-PacedExperience Type
- Intermediate LevelLevel
This course introduces the fundamental concepts of relational database design and provides hands-on practice with SQL (Structured Query Language) specifically within the PostgreSQL environment. You will learn how to create and manage databases, including defining schemas, inserting data, and querying information using common SQL commands. The course covers essential database modeling techniques, such as representing one-to-many and many-to-many relationships, and guides you through practical assignments to build and manipulate relational data.
Curriculum
The course is structured into four modules covering key aspects of SQL and database design.
- Module 1
- Introduction to SQL
- Introductory SQL Assessment
- Initial Database Setup
- Making Our First Tables
- Inserting Some Data into a Table
- Module 2
- Single Table SQL
- Single Table SQL Assessment
- SERIAL fields / Auto Increment
- Musical Track Database (CSV)
- Module 3
- One-To-Many Data Models
- One to Many Data Models Assessment
- Entering Many-to-One Data - Automobiles
- Module 4
- Many-To-Many Data Models
- Many-to-Many Data Models Assessment
- Building a Many-to-Many Roster
Careers
This course provides foundational skills in database design and SQL, which are essential for various data-related roles.
- Database Design
- SQL (Programming Language)
- PL/pgSQL
- PostgreSQL
Frequently asked questions
- What are the entry requirements for this certificate programme?
- This is an intermediate-level course. You are expected to have completed the first two courses in the "Python for Everybody" specialization or possess an equivalent basic understanding of Python.
- How much does the programme cost?
- The course is free for University of Michigan students, alumni, faculty, and staff. Pricing for individual learners on Coursera or edX is not specified.
- How can I enroll in this course?
- You can enroll as an individual learner on Coursera or edX. Current U-M affiliated individuals have free access through their university login.
- What will I learn in this course?
- This course introduces relational database design and hands-on practice with SQL in PostgreSQL. You will learn to create and manage databases, define schemas, insert data, and query information using common SQL commands.
- What are the career prospects after completing this course?
- This course provides foundational skills in database design and SQL, which are essential for data-related roles such as Database Design, SQL (Programming Language), PL/pgSQL, and PostgreSQL.
- Is the course offered online?
- Yes, this course is offered 100% online and is self-paced.
Entry requirements
Previous CoursesCompletion of the first two courses in the "Python for Everybody" specialization or an equivalent basic understanding of Python.
This is an intermediate-level course.
Fees
Tuition (international)Free for U-M students, alumni, faculty, and staff. Pricing for individual learners on Coursera/edX is not specified in the provided text. Organizations can inquire about special pricing.
Tuition (home)Free for U-M students, alumni, faculty, and staff. Pricing for individual learners on Coursera/edX is not specified in the provided text. Organizations can inquire about special pricing.
Living—
Individual learners can enroll on Coursera or edX. U-M affiliated individuals receive free access.
How to apply
1. Choose a PlatformDecide whether you want to enroll through Coursera or edX.
2. Enroll in the CourseClick the respective enrollment link for Coursera or edX.
3. Access for U-M AffiliatesIf you are a current U-M student, alumnus, faculty, or staff member, use the provided links for free access via your university login.
4. Sign Up or Log InIf you are a new user to Michigan Online, you may need to sign up for an account or log in to your existing account to customize your experience.
Frequently asked questions
What are the entry requirements for this certificate programme?
+
This is an intermediate-level course. You are expected to have completed the first two courses in the "Python for Everybody" specialization or possess an equivalent basic understanding of Python.
How much does the programme cost?
+
The course is free for University of Michigan students, alumni, faculty, and staff. Pricing for individual learners on Coursera or edX is not specified.
How can I enroll in this course?
+
You can enroll as an individual learner on Coursera or edX. Current U-M affiliated individuals have free access through their university login.
What will I learn in this course?
+
This course introduces relational database design and hands-on practice with SQL in PostgreSQL. You will learn to create and manage databases, define schemas, insert data, and query information using common SQL commands.
What are the career prospects after completing this course?
+
This course provides foundational skills in database design and SQL, which are essential for data-related roles such as Database Design, SQL (Programming Language), PL/pgSQL, and PostgreSQL.
Is the course offered online?
+
Yes, this course is offered 100% online and is self-paced.