Skip to content
- 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.