University of Michigan - PostgreSQL for Everybody Specialization
offered by Coursera

Estd. 2012

PostgreSQL for Everybody Specialization
at
Coursera
Overview

Learn to be proficient in using PostgreSQL for a variety of data management and analysis tasks

Duration	1 month
Start from	Start Now
Mode of learning	Online
Difficulty level	Intermediate
Official Website	Go to Website
Credential	Certificate

PostgreSQL for Everybody Specialization
at
Coursera
Highlights

Earn a certificate after completion of the course
Financial aid facility available
Assignment for better practice

PostgreSQL for Everybody Specialization
at
Coursera
Course details

Who should do this course?

Aspiring Database Administrators

Data Scientists and Analysts

Software Developers

What are the course deliverables?

How to use the PostgreSQL database effectively

Explore database design principles

Dive into database architecture and deployment strategies

Compare and contrast SQL and NoSQL database design approaches and acquire skills applicable to data mining and application development

More about this course

This is a comprehensive program designed to teach participants how to use PostgreSQL, one of the most powerful and popular open-source relational database systems

This specialization covers fundamental and advanced concepts in PostgreSQL, equipping students with the skills needed to design, manage, and query databases effectively

Through a series of in-depth modules, students will learn to write SQL queries, perform data analysis, design database schemas, and optimize database performance using PostgreSQL

PostgreSQL for Everybody Specialization
at
Coursera
Curriculum

Database Design and Basic SQL in PostgreSQL

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

Build and differentiate between one-to-many and many-to-many relationships within PostgreSQL

Recall key people, organizations, and innovations that were instrumental to building the SQL standard

Intermediate PostgreSQL

Utilize SQL commands for editing tables in a PostgreSQL database and produce properly normalized tables from CSV files

Appropriately handle text and dates in databases and create stored procedures

Identify hashtag algorithm and their attributes

Construct regular expressions to select rows that match a pattern

JSON and Natural Language Processing in PostgreSQL

Compare Python, PostgreSQL, and JSON

Index and retrieve natural language text and JSON data; access API data and store it in a database

Create a GIN-based text[] reverse index and ts_vector index; build a search engine in PostgreSQL

Database Architecture, Scale, and NoSQL with Elasticsearch

Understand PostgreSQL architecture; analyze and compare SQL and NoSQL

Compare and contrast ACID and BASE style architectures and databases

Create and utilize an Elasticsearch index in different contexts

PostgreSQL for Everybody Specialization
at
Coursera
Faculty details

Charles Russell Severance

Charles Severance (a.k.a. Dr. Chuck) is a Clinical Professor at the University of Michigan School of Information, where he teaches various technology-oriented courses including programming, database design, and Web development. Chuck has written a number of books including Using Google App Engine, and Python for Everybody. His research field is in the building of learning management systems such as Sakai, Moodle, Blackboard, ANGEL, and others