Intermediate PostgreSQL
About this Course
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.Created by: The University of Michigan
Level: Intermediate
Related Online Courses
Please Note: Learners who successfully complete this IBM course can earn a skill badge — a detailed, verifiable and digital credential that profiles the knowledge and skills you’ve acquired in thi... more
"Introduction to WebAssembly" is designed for web, cloud, and blockchain developers, architects, and CTOs interested in learning about WebAssembly’s strengths and limitations, and its potential a... more
This course introduces the concept of a designer working for themselves and creating their own design-driven brand. It requires learners to apply ideas to a real-life setting. By the end of this... more
Code and run your first C++ program in minutes without installing anything! This course is designed for learners with limited coding experience, providing a solid foundation of not just C++, but... more
Welcome to this Spark AR Studio advanced course. In this course, you will build on your advanced skills and techniques to continue with your very own Spark AR journey! The goal of this course is to... more
Powered by
