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.
Intermediate PostgreSQL
Ends soon! Save on skills that make you shine with 40% off 3 months of Coursera Plus. Save now
Intermediate PostgreSQL
This course is part of PostgreSQL for Everybody Specialization
Instructor: Charles Russell Severance
24,294 already enrolled
Included with
Gain insight into a topic and learn the fundamentals.
338 reviews
Intermediate level
Recommended experience
Flexible schedule
2 weeks at 10 hours a week
Learn at your own pace
91%
Most learners liked this course
What you'll 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.
Skills you'll gain
Tools you'll learn
Details to know
Shareable certificate
Add to your LinkedIn profile
Assessments
3 assignments
Taught in English
See how employees at top companies are mastering in-demand skills
Build your subject-matter expertise
This course is part of the PostgreSQL for Everybody Specialization
When you enroll in this course, you'll also be enrolled in this Specialization.
- Learn new concepts from industry experts
- Gain a foundational understanding of a subject or tool
- Develop job-relevant skills with hands-on projects
- Earn a shareable career certificate
There are 4 modules in this course
Earn a career certificate
Add this credential to your LinkedIn profile, resume, or CV. Share it on social media and in your performance review.
Instructor
Instructor ratings
(73 ratings)Offered by
Explore more from Software Development
Status: Free Trial
Status: Free Trial
Status: Free Trial
Status: Free TrialUniversity of Michigan
Why people choose Coursera for their career
Felipe M.
Learner since 2018
"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."
Jennifer J.
Learner since 2020
"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."
Larry W.
Learner since 2021
"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."
Chaitanya A.
"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."
Learner reviews
- 5 stars
83.43%
- 4 stars
10.94%
- 3 stars
2.36%
- 2 stars
1.18%
- 1 star
2.07%
Showing 3 of 338
KB
Reviewed on Nov 12, 2021
Great lecture material, the assignments seem overwhelming at first but are actually quite easy if you pay attention to the lectures.
JH
Reviewed on Oct 11, 2022
Dr Chuck is the best. He makes learning enjoyable. Way to go.
AM
Reviewed on Dec 23, 2021
It was an engaging course, but I feel that SQL coverage was cursory and the haphazard explanation style of the instructor was not helpful. Still, much useful and practical information.
