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.