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 tech

• Utilize SQL commands to edit tables and normalize data from CSV files
• Manage text and date data and create stored procedures
• Identify hashtag algorithms and attributes
• Construct regular expressions to select matching rows