[Coursera] PostgreSQL for Everybody Specialization

SQL: From Basic to Advanced. Learn SQL skills you can use in an actual, real-world environment

Explore the depth and breadth of PostgreSQL, including its architectural foundations and advanced features such as JSON support and natural language processing. This intermediate-level program, developed by the University of Michigan, weaves together principles of SQL and NoSQL, providing essential skills for data mining and application development.

Advance your subject-matter expertise

– Learn in-demand skills from university and industry experts
– Master a subject or tool with hands-on projects
– Develop a deep understanding of key concepts
– Earn a career certificate from University of Michigan

Specialization – 4 course series

Across these four courses, you’ll learn how to use the PostgreSQL database and explore topics ranging from database design to database architecture and deployment. You’ll also compare and contrast SQL and NoSQL approaches to database design. The skills in this course will be useful to learners doing data mining or application development.

Applied Learning Project

This course series utilizes a custom autograding environment for an authentic set of graded and practice assignments, including: creating and manipulating tables, designing data models, constructing advanced queries, techniques for working with text in databases, including regular expressions, and more.

1. Database Design and Basic SQL in PostgreSQL
2. Intermediate PostgreSQL
3. JSON and Natural Language Processing in PostgreSQL
4. Database Architecture, Scale, and NoSQL with Elasticsearch

Skills you will gain

– Json
– Database (DBMS)
– Natural Language Processing
– SQL

Instructor(s)

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. He was the chief architect for the Sakai Project, a learning management system used at about 300 schools worldwide and wrote the book Sakai: Free as in Freedom, that describes his experiences as one of the leaders of the project. In the mid-1990s he was the host of Internet:TCI, a national television talk show about the Internet that ran for several years on the TCI cable system. He was long-time a columnist for the IEEE Computer Magazine writing a monthly column called “Computing Conversations” that features video interviews with famous technology leaders and innovators.

Offered by University of Michigan

General Info:

Author(s): Charles Severance
Language: English
Updated: 6/2023
Videos Duration: 55h

Size: 4.70 GB