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.阅读更多.
此资源由附属合作伙伴提供。 如果您支付培训费用，我们可能会赚取佣金来支持该网站。
Intermediate PostgreSQL 中涵盖的技术和工具与 数据分析师 招聘广告中的要求最为相似。
Intermediate PostgreSQL is a part of 一 structured learning path.
4 Courses
4 Months
PostgreSQL for Everybody
