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
La intención de este MOOC consiste en tener una mirada amplia teniendo en cuenta la naturaleza del planeta tierra, sus dinámicas, qué lo hacen un planeta vivo y complejo con millones de años de evo... more
Computational thinking is an invaluable skill that can be used across every industry, as it allows you to formulate a problem and express a solution in such a way that a computer can effectively... more
Para el proceso de minería de datos es fundamental conocer a priori qué productos compran nuestros clientes y hacer un análisis de la cesta de la compra con los datos de entrada disponibles. Es... more
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
The Internet of Things (IoT) is expanding at a rapid rate, and it is becoming increasingly important for professionals to understand what it is, how it works, and how to harness its power to... more
Powered by
