Intermediate PostgreSQL
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.
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.
Syllabus
Syllabus - What you will learn from this course
Week 1
SQL Techniques
Week 2
Using SQL Techniques
Week 3
Text in PostgreSQL
Week 4
Regular Expressions
FAQ
When will I have access to the lectures and assignments?
Access to lectures and assignments depends on your type of enrollment. If you take a course in audit mode, you will be able to see most course materials for free. To access graded assignments and to earn a Certificate, you will need to purchase the Certificate experience, during or after your audit. If you don't see the audit option:
What will I get if I subscribe to this Specialization?
When you enroll in the course, you get access to all of the courses in the Specialization, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile. If you only want to read and view the course content, you can audit the course for free.
What is the refund policy?
If you subscribed, you get a 7-day free trial during which you can cancel at no penalty. After that, we don’t give refunds, but you can cancel your subscription at any time. See our full refund policy.
Is financial aid available?
Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.
Reviews
This course was very helpful. Before taking this course, I only knew simple CRUD operations, but there is more information there. I got new knowledge. Thank you. Hope will take more Chuck courses.
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.
https://imgs.xkcd.com/comics/exploits_of_a_mom.png
The best intermediate PostgreSQL ever. I really learn a lot.
