Intermediate PostgreSQL (Coursera)

Intermediate PostgreSQL (Coursera)
Course Auditing
Categories
Effort
Certification
Languages
Completion of first two courses in the Python for Everybody specialization or an equivalent basic understanding of Python
Misc

MOOC List is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Intermediate PostgreSQL (Coursera)
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.

Class Deals by MOOC List - Click here and see Coursera's Active Discounts, Deals, and Promo Codes.

MOOC List is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

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.


What You Will Learn

- 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.

Course 2 of 4 in the PostgreSQL for Everybody Specialization


Syllabus


WEEK 1

SQL Techniques

In this first week, you'll be introduced to the course and look at SQL commands for editing columns and tables in a PostgreSQL Database. You'll learn to create stored procedures and also utilize the SELECT DISTINCT command.


WEEK 2

Using SQL Techniques

This week, we'll focus on producing properly normalized tables from CSV files and utilizing the ALTER TABLE command to adjust the schema of tables.


WEEK 3

Text in PostgreSQL

This week will focus on text in PostgreSQL, including utilizing character sets, identifying hashtag algorithms and attributes, as well as index choices and techniques.


WEEK 4

Regular Expressions

In our final week, we will focus on regular expressions: their functions, and how to construct them to select rows from a table that match a pattern.



0
No votes yet

MOOC List is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Course Auditing
32.00 EUR/month
Completion of first two courses in the Python for Everybody specialization or an equivalent basic understanding of Python

MOOC List is learner-supported. When you buy through links on our site, we may earn an affiliate commission.