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.
This course is part of the PostgreSQL for Everybody Specialization
Offered By
About this Course
Completion of first two courses in the Python for Everybody specialization or an equivalent basic understanding of Python
Could your company benefit from training employees on in-demand skills?
Try Coursera for BusinessWhat you will learn
Utilize SQL commands for editing tables in a PostgreSQL database and produce properly normalized tables from CSV files.
Appropriately handle text and dates in databases and create stored procedures.
Identify hashtag algorithm and their attributes.
Construct regular expressions to select rows that match a pattern.
Completion of first two courses in the Python for Everybody specialization or an equivalent basic understanding of Python
Could your company benefit from training employees on in-demand skills?
Try Coursera for BusinessOffered by
Syllabus - What you will learn from this course
SQL Techniques
Using SQL Techniques
Text in PostgreSQL
Regular Expressions
Reviews
- 5 stars84.88%
- 4 stars11.55%
- 3 stars1.33%
- 2 stars1.33%
- 1 star0.88%
TOP REVIEWS FROM INTERMEDIATE POSTGRESQL
Another Amazing course By Dr Chuck. A must do course for anyone who wants to learn SQL.
Very down to earth and practical course on postgres. I especially liked the interactive graded assignments as well as friendly and informal attitude of mr. Severance.
It is a great course but it is shorter than others.
Amazing course. Lots of practices. Dr. Chuck makes it looks like it is easy. Very relevant techniques and concepts.
About the PostgreSQL for Everybody Specialization

Frequently Asked Questions
When will I have access to the lectures and assignments?
What will I get if I subscribe to this Specialization?
What is the refund policy?
Is financial aid available?
More questions? Visit the Learner Help Center.