What you will learn
- Utilize psql and SQL commands to implement CRUD (Create, Read, Update, and Delete) operations for tables in a PostgreSQL database.
- Identify and utilize the functions of primary, logical, and foreign keys within a database.
- Design and implement data models using both one-to-many and many-to-many relationships within PostgreSQL.
- Learn about data indexes and query optimization for large scale data.
- Understand various SQL and NoSQL database architectures and how high-performance databases work in production environments.
Learn how to use the PostgreSQL open-source relational database management system (RDBMS) in order to explore topics ranging from database design to database architecture and deployment. Explore the benefits that PostgreSQL provides over other solutions, such as MySQL, when dealing with large datasets. These four specialized classes cover JSON, NoSQL, natural language processing, and more. The skills gained in these courses are useful for anyone interested in data mining, application development, or machine learning.
Courses in this program
MichiganX's PostgreSQL for Everybody Professional Certificate
- 2–4 hours per week, for 4 weeks
This first course in PostgreSQL for Everybody explores the use of SQL in the PostgreSQL environment and introduces SQL techniques and commands. This course also explores data modeling and database relationships, while introducing hands-on assignments to work within PostgreSQL.
- 2–4 hours per week, for 4 weeks
This second course in PostgreSQL for Everybody explores a wide range of SQL techniques to aggregate and transact data in PostgreSQL.This course also explores handling, reading, and parsing data with PostgreSQL and working with text in databases with regular expressions.
- 2–4 hours per week, for 4 weeks
In this third course in PostgreSQL for Everybody, learners will learn how PostgreSQL creates and uses JSON and natural language content. Learners will explore using multiple sources of data and how text is structured within PostgreSQL.
- 2–4 hours per week, for 3 weeks
In this fourth and final course in PostgreSQL for Everybody, learners will explore database architectures, CRUD operations and how ACID requirements are implemented in PostgreSQL. Learners will compare how to scale SQL and NoSQL database services and build NoSQL applications using ElasticSearch.
- Postgres is the fastest growing database management system in an approximately $80 billion market. (Source: Gartner)
- Postgres is the top choice for enterprises looking to accelerate innovation, modernize their database infrastructure, and reduce spending.
- According to StackOverflow surveys of developers, Postgres is the most loved, most used, and most wanted database in the world.
- Career prospects include PostgreSQL Developer, Database Administrator (DBA), and Database Engineer.
- The average salary for PostgreSQL Developers and Database Administrators in the US is $97K. (Source: Payscale.com)
Meet your instructor from The University of Michigan (MichiganX)
Experts from MichiganX committed to teaching online learning
Enrolling Now
Get started in computer science
Browse other computer science coursesPropelling
Drive your career forward with university-backed credit programs and verified certificatesConvenient
Study and demonstrate knowledge on your scheduleFlexible
Try a course before you paySupportive
Learn with university partners and peers from around the world