• University of Michigan logo
New

Database Design and Basic SQL in PostgreSQL

Build on your basic programming background as you learn database design and other basic skills in PostgreSQL.

372 enrolled on this course

Database Design and Basic SQL in PostgreSQL
  • Duration

    4 weeks
  • Weekly study

    2 hours
  • 100% online

    Learn at your own paceHow it works
  • Unlimited

    $23.33/monthLearn more

Understand and practice important PostgreSQL concepts

This four-week course from the University of Michigan is the first in the PostgreSQL and Python series, and delivers a solid foundation to PostgreSQL.

You’ll learn SQL fundamentals, basic CRUD (Create, Read, Update, Delete) operations in PostgreSQL, and the specifics of aggregation, transactions, reading, and parsing CSV files, and entering data into a database.

Finally, a look at how PostgreSQL handles and indexes data will complete your introduction to this relational database management system (RDBMS).

Learn all you need to know about SQL programming

You’ll start by exploring basic SQL commands to implement CRUD operations in PostgreSQL, and the functions of primary, logical, and foreign keys within a database.

From there you’ll build and differentiate between one-to-many and many-to-many relationships within PostgreSQL, giving you important insights into using this RDBMS for your own database design and creation.

Get hands-on practice in PostgreSQL

Throughout the course, you’ll practice the programming concepts as they are introduced to you, by completing different assignments.

By the end, you’ll be able to alter table schemas, create stored procedures, construct advanced queries, and work with text in databases using various techniques.

Study this RDBMS with leading experts

The University of Michigan is a highly-respected institution, with a long history of providing exceptional courses as well as academic support.

This course continues the University’s high standards, and is also convened by programming experts who understand the historical significance of PostgreSQL.

Not only will you learn and practice important aspects of the SQL, but you’ll also gain insights into the key players and innovations that brought about the game-changing SQL standard.

Syllabus

  • Week 1

    Introduction to SQL

    • Welcome

      Welcome to the course!

    • Lectures

      Getting started with SQL.

    • Assignments

      Assignment content for week 1.

    • Week Wrap-up

      Wrapping up the week.

  • Week 2

    Single Table SQL

    • Lectures

      Getting started with Single Table SQL

    • Assignments

      Assignment content for week 2.

    • Week Wrap-up

      Wrapping up the week.

  • Week 3

    One-to-Many Data Models

    • Lectures

      Getting started with One-to-Many data Models

    • Assignments

      Assignment content for week 3.

    • Week Wrap-up

      Wrapping up the week.

  • Week 4

    Many-To-Many Data Models

    • Lectures

      Getting started with Many-to-Many data models

    • Assignments

      Assignment content for week 4.

    • Week Wrap-up

      Wrapping up the week.

    • Wrap Up

      Wrapping up this course

When would you like to start?

Start straight away and learn at your own pace. If the course hasn’t started yet you’ll see the future date listed below.

  • Available now

Learning on this course

You can take this self-guided course and learn at your own pace. On every step of the course you can meet other learners, share your ideas and join in with active discussions in the comments.

What will you achieve?

By the end of the course, you‘ll be able to...

  • Apply psql and SQL commands to implement CRUD (Create, Read, Update, Delete) operations for tables in a PostgreSQL database
  • Identify and utilise the functions of primary, logical, and foreign keys within a database
  • Create and differentiate between one-to-many and many-to-many relationships within PostgreSQL
  • Explore the key people, organisations, and innovations that were instrumental to building the SQL standard

Who is the course for?

This course is designed for anyone with a background and working knowledge of Python or programming, who would like to upskill by learning PostgreSQL.

Who will you learn with?

Charles is a Clinical Professor and teaches in the School of Information at the University of Michigan. He is the Chair of the Sakai Project Management Committee (PMC).

Who developed the course?

University of Michigan

As the #1 public research university in the United States, U-M has been a leader in research, learning, and teaching for more than 200 years, with 102 Grad programs in the top 10 — U.S. News & World Report (2019).

  • Established

    1817
  • Location

    Ann Arbor, Michigan, USA
  • World ranking

    Top 30Source: Times Higher Education World University Rankings 2020
Recommended

Ways to learn

Upgrade this course

Unlimited

Basic access

Choose the best way to learn for you!

$64

$23.33/month

Billed at $279.99 for a year

Free

Unlock your expertiseEndless possibilities!Try before you upgrade
Access to this courseticktickLimited to 4 weeks
Access to ALL eligible short courses with additional benefits, for a yearcrosstickcross
Discuss your learning in commentstickticktick
Tests to check your learningticktickcross
Certificate when you're eligiblePrinted and digitalDigital onlycross
Join and Upgrade

Ways to learn

Buy Unlimited to access this course and hundreds of other short courses for a year or Upgrade just this course for extra benefits. Or, join with basic access.

Unlimited

$23.33/month

Billed at $279.99 for a year

Endless possibilities!

  • Access to this course
  • Access to ALL eligible short courses with additional benefits, for a year
  • Discuss your learning in comments
  • Tests to boost your learning
  • Digital certificate when you're eligible

Upgrade this course

$64

Unlock your expertise

  • All of the above* for this course only, plus a printed certificate when you’re eligible

*Excludes access to all eligible short courses with additional benefits for a year

Basic access

Free

Try before you buy

  • Limited access to course content for 4 weeks

Find out more about certificates, Upgrades or Unlimited.

Find out more about certificates, Upgrades or Unlimited.

Learning on FutureLearn

Your learning, your rules

  • Courses are split into weeks, activities, and steps, but you can complete them as quickly or slowly as you like
  • Learn through a mix of bite-sized videos, long- and short-form articles, audio, and practical activities
  • Stay motivated by using the Progress page to keep track of your step completion and assessment scores

Join a global classroom

  • Experience the power of social learning, and get inspired by an international network of learners
  • Share ideas with your peers and course educators on every step of the course
  • Join the conversation by reading, @ing, liking, bookmarking, and replying to comments from others

Map your progress

  • As you work through the course, use notifications and the Progress page to guide your learning
  • Whenever you’re ready, mark each step as complete, you’re in control
  • Complete 90% of course steps and all of the assessments to earn your certificate

Want to know more about learning on FutureLearn? Using FutureLearn

Do you know someone who'd love this course? Tell them about it...