Online Course – Certified Professional PostgreSQL Internship for Everyone – University of Michigan

Learn SQL skills from basic to advanced. Learn SQL skills that can be used in a real-world environment.

Suggested by: Coursera (What is Coursera?)

Start your Coursera.com free trial today
קורס אונליין - התמחות מקצועית מוסמכת ב-PostgreSQL לכולם - אוניברסיטת מישיגן

Professional Certificate

Intermediate level

No prior knowledge required

Time to complete the course

7-day free trial

No unnecessary risks

Skills you will acquire in the course

  • Databases
  • SQL
  • Natural language processing

What you will learn in the course

Courses for which the course is suitable

  • Database developer
  • Data Engineer
  • Application developer
  • Data Analyst
  • SQL Expert
  • Database Administrator
  • Software developer
  • NoSQL expert

Internship – a series of four courses

In this four-course series, you will learn how to use the PostgreSQL database and explore topics ranging from database design to database architecture and deployment. You will make comparisons between SQL and NoSQL approaches to database design. The knowledge you gain in this course will be useful to those involved in data initiatives or application development.

Hands-on Learning Project

This course series uses an automated testing environment to assign grades and provide authentic practice tasks, including:

  • Creating and manipulating tables
  • Data modeling
  • Building advanced queries
  • Techniques for working with text in databases, including regular expressions
  • and more

Details of the courses that make up the specialization

Database design and basic SQL in PostgreSQL

Course 1

  • 13 hours
  • 4.8 (949 ratings)

Course Details

What you’ll learn
  • Use psql and SQL commands to perform CRUD (create, read, update, and delete) operations on 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 in PostgreSQL.
  • Remember key people, organizations, and innovations that helped build the SQL standard.
Skills you will gain
  • Category: Database Design (DB)

Database Design (DB)

  • Category: SQL

SQL

  • Category: Databases (DBSM)

Databases (DBSM)

PostgreSQL Medium

Course 2

  • 16 hours
  • 4.7 (298 ratings)

Course Details

What you’ll learn
  • Use SQL commands to edit tables in a PostgreSQL database and create properly normalized tables from CSV files.
  • Properly handle texts and dates in databases and create stored procedures.
  • Identify the hashtag algorithm and its characteristics.
  • Build regular expressions to select lines that match a pattern.
Skills you will gain
  • Category: SQL

SQL

  • Category: Databases (DBSM)

Databases (DBSM)

JSON and natural language processing in PostgreSQL

Course 3

  • 16 hours
  • 4.6 (125 ratings)

Course Details

What you’ll learn
  • 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 inverted index and a ts_vector index; build a search engine in PostgreSQL.
Skills you will gain
  • Category: JSON

JSON

  • Category: SQL

SQL

  • Category: Natural Language Processing

Natural language processing

  • Category: Databases (DBSM)

Databases (DBSM)

Database Architecture, Scala, and NoSQL with Elasticsearch

Course 4

  • 10 hours
  • 4.3 (127 ratings)

Course Details

What you’ll learn
  • Understand the architecture of PostgreSQL; analyze and compare SQL and NoSQL.
  • Compare and contrast ACID and BASE architectures and databases.
  • Create and use an Elasticsearch index in various contexts.
Skills you will gain
  • Category: Database Architecture

Database architecture

  • Category: SQL

SQL

  • Category: Databases (DBSM)

Databases (DBSM)

Related products