Basics of Database Design and SQL in PostgreSQL


Deal Score+2



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

Join Other Email Learners

Follow the guide on landing page

About This Course

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.

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 1Introduction to SQL
  • Week 2Single Table SQL
  • Week 3One-to-Many Data Models
  • Week 4Many-To-Many Data Models

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.

Free Course on Basics of Database Design and SQL in PostgreSQL



DISCLAIMER: Courses on Future Syllabus are free but subject to return to their original prices on host platforms upon coupon expiration. Enrol while they are free. To report any error, use the "Further Actions" tab.




Further Actions

Add to wishlist0


Rate below:
2
Show full profile

Editor

Mass Communication Student, Federal University, Oye Ekiti and Content Creation Specialist. Join me on Twitter.

Stay active

Leave a Reply

Future Syllabus
Logo
Register New Account
Login/Register via your social accounts (fully secured)

or proceed manually
Reset Password