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
El internet de las Cosas (IoT) está alrededor de nosotros y rápidamente se está expandiendo, a penas estamos viendo sus beneficios. El IoT ayuda a los individuos a mejorar su calidad de vida, ad... 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
Welcome to Machine learning with Python for finance professionals, provided by ACCA (Association of Chartered Certified Accountants), the global body for professional accountants. This course is... more
Este curso ofrece un enfoque interdisciplinario de la sostenibilidad en Arquitectura. Los alumnos conocerán los elementos básicos de las evaluaciones de sostenibilidad (primera capa del modelo), a... more
The Python programming language is extremely powerful and commonly used to automate time-intensive activities/tasks for users. This makes Python a good skill to have for any job that requires... more
Powered by
