Building Your First Classification Model in Python with Scikit-learn

Free Live ML Workshop #4 on Oct 1 - Register Now

Description

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.Read more.

This resource is offered by an affiliate partner. If you pay for training, we may earn a commission to support this site.

Career Relevance by Data Role

The techniques and tools covered in Intermediate PostgreSQL are most similar to the requirements found in Data Analyst job advertisements.

Similarity Scores (Out of 100)

Learning Sequence

Intermediate PostgreSQL is a part of one structured learning path.

Coursera
University of Michigan

4 Courses 4 Months

PostgreSQL for Everybody