MichiganX: 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.
About this course
This course covers a wide range of SQL techniques, beyond basic CRUD (Create, Read, Update, and Delete) operations in PostgreSQL. You will learn the specifics of aggregation, transactions, reading and parsing CSV files and inserting data into a database. You’ll also take a look at how PostgreSQL handles and indexes text data.
Specifically, students will do assignments that alter table schemas, create stored procedures, construct advanced queries, explore sorting and grouping query data, and techniques for working with text in databases including regular expressions.
At a Glance:
Institution: MichiganX
Subject: Computer Science
Level: Intermediate
Prerequisites:
None
Language: English
Video Transcript: English
Associated programs:
Professional Certificate in PostgreSQL for Everybody
Associated skills:PostgreSQL, Operations, Stored Procedure, SQL (Programming Language), Parsing, Sorting
There are no reviews yet.