Intermediate PostgreSQL
Learn advanced SQL techniques in PostgreSQL with this comprehensive course. From aggregation to transactions, CSV parsing to text indexing, you’ll gain valuable skills. Explore table schemas, stored procedures, advanced queries, sorting, grouping, and text manipulation using regular expressions. Boost your database expertise now!
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.
User Reviews
Be the first to review “Intermediate PostgreSQL”
You must be logged in to post a review.
There are no reviews yet.