PostgreSQL for Everybody

Go to class
Write Review

PostgreSQL for Everybody provided by edX is a comprehensive online course, which lasts for 15 weeks long, 2-4 hours a week. PostgreSQL for Everybody is taught by Charles Severance. Upon completion of the course, you can receive an e-certificate from edX. The course is taught in Englishand is $196.00. Visit the course page at edX for detailed price information.

Overview
  • 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.

Syllabus
  • Courses under this program:
    Course 1: Database Design and Basic SQL in PostgreSQL

    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.



    Course 2: Intermediate PostgreSQL

    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.



    Course 3: JSON and Natural Language Processing in PostgreSQL

    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.



    Course 4: Database Architecture, Scale, and NoSQL with Elasticsearch

    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.