Intermediate PostgreSQL

Por: Coursera . en: , ,

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