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
Complete your introductory knowledge of computer science with this final course on objects and algorithms. Now that you've learned about complex control structures and data structures, learn to... more
The success of machine learning, and in particular deep learning in image recognition and natural language processing applications, has created high expectations and their use has rapidly spread to... more
This course is part of W3C's "Front-End Web Developer" Professional Certificate. JavaScript lets you add interactive features to your Web sites, including dynamically updated content, controlled... more
In this course, we build upon the knowledge we built up on cache side-channel attacks and transient-execution attacks, as well as the side-channel and security mindset. We again go beyond... more
Building construction is one of the most waste producing sectors. In the European Union, construction alone accounts for approximately 30% of the raw material input. In addition, the different... more
Powered by
