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
Side channels have become increasingly important over the past two decades in our digital world. With attacks like Meltdown and Spectre, which internally use side channels, they have gained... more
This course will provide you with technical hands-on knowledge of NoSQL databases and Database-as-a-Service (DaaS) offerings. With the advent of Big Data and agile development methodologies, NoSQL... more
Este curso propone y aplica una metodología innovadora para analizar y organizar la arquitectura contemporánea latinoamericana con base en las variables que los arquitectos contemplan cuando d... more
Data is the most important asset in the Cloud Computing era. This course focuses on the collection, storage and management of big data. It provides a comprehensible frame structure for Data... more
La ciencia de los datos es soportada por diversas áreas de conocimiento, siendo el aprendizaje automático una de las más relevantes. ¿Y qué es esto? Es la creación de modelos predictivos, regre... more
Powered by
