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
Develop a good working knowledge of Linux using both the graphical interface and command line, covering the major Linux distribution families. Linux powers 100% of the world’s supercomputers, m... more
RISC-V is a free and open instruction set architecture (ISA) enabling a new era of processor innovation through open standard collaboration. This course will guide you through the various aspects... more
Este curso forma parte de una serie de 5 cursos de introducción al uso de sistemas de información en las empresas que te introducirá en el apasionante mundo de las TIC. La serie de cursos está pen... more
Gain essential skills in today’s digital age to store, process and analyse data to inform business decisions. In this course, part of the Big Data MicroMasters program, you will develop your k... more
The SRE Capstone is the third and final offering of the Site Reliability Engineering Professional Certificate program. The course includes valuable study materials for certification exam... more
Powered by
