Intermediate PostgreSQL

About

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.

What 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.

Skills you learn

• SQL (Programming Language)
• Parsing
• PostgreSQL
• Operations
• Stored Procedure
• Sorting

Auto Summary

Explore advanced SQL techniques with "Intermediate PostgreSQL" from edX. This course delves into data aggregation, transactions, and text handling using regular expressions in PostgreSQL. Ideal for IT and Computer Science enthusiasts, it offers flexible subscription options—Professional and Starter. Perfect for learners looking to deepen their SQL skills.