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.Lee mas.
Este recurso es ofrecido por un socio afiliado. Si paga por la capacitación, podemos ganar una comisión para respaldar este sitio.
The techniques and tools covered in Intermediate PostgreSQL are most similar to the requirements found in Analista de datos data science job advertisements.
Intermediate PostgreSQL is a part of uno structured learning path.
4 Courses
4 Months
PostgreSQL for Everybody
