Ir al contenido principal

Intermediate PostgreSQL

This second course in PostgreSQL for Everybody explores a wide range of SQL techniques to aggregate and transact data in PostgreSQL.This course also explores handling, reading, and parsing data with PostgreSQL and working with text in databases with regular expressions.

...
Intermediate PostgreSQL

Hay una sesión disponible:

¡Ya se inscribieron 677 usuarios!
Una vez finalizada la sesión del curso, será archivadoAbre en una pestaña nueva.
Comienza el 3 dic

Intermediate PostgreSQL

This second course in PostgreSQL for Everybody explores a wide range of SQL techniques to aggregate and transact data in PostgreSQL.This course also explores handling, reading, and parsing data with PostgreSQL and working with text in databases with regular expressions.

Intermediate PostgreSQL
4 semanas
2–4 horas por semana
A tu ritmo
Avanza a tu ritmo
Gratis
Verificación opcional disponible

Hay una sesión disponible:

Una vez finalizada la sesión del curso, será archivadoAbre en una pestaña nueva.
Comienza el 3 dic

Sobre este curso

Omitir Sobre este curso

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.

De un vistazo

Lo que aprenderás

Omitir Lo que aprenderás
  • Utilize SQL commands for editing tables in a PostgreSQL database and produce properly normalized tables from CSV files.

  • Appropriately handle text and dates in databases and create stored procedures.

  • Identify hashtag algorithm and their attributes.

  • Construct regular expressions to select rows that match a pattern.

Acerca de los instructores

¿Te interesa este curso para tu negocio o equipo?

Train your employees in the most in-demand topics, with edX For Business.