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.
That's awesome, I had enjoyed the every module of the course.
This course was super useful for me and I've learned incredible topics and materials from this course, Thanks a lot.
Great course for intermediate level, I loved it! Quite short though. I want more!
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?
Is financial aid available?
More questions? Visit the Learner Help Center.