YoVDO

Intermediate PostgreSQL

Offered By: University of Michigan via edX

Tags

PostgreSQL Courses SQL Courses Stored Procedures Courses

Course Description

Overview

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.


Taught by

Charles Severance

Tags

Related Courses

Web Application Development: The Data Tier
University of New Mexico via Coursera
Desarrollo de Aplicaciones Web: Nivel de Datos
University of New Mexico via Coursera
Hacking PostgreSQL: Data Access Methods
Ural Federal University via edX
Spatial Data Science and Applications
Yonsei University via Coursera
RDBMS PostgreSQL
Indian Institute of Technology Bombay via Swayam