What you’ll learn:
- Bulk insert and export from csv
- Casting types in SQL
- Define Custom Types (like ENUMs) for data integrity
- Analyze query performance for optimal queries
- Write concise queries with CTE’s (Common Table Expressions) and do/declare blocks
- Filter Aggregate data with having
- Guarantee database interactions with Transactions
- Complex pattern matching
Bulk Insert and export from csv
This is the format when using Postgres:
copy <table name> <column names> from ‘<full file path to CSV file>’ DELIMITER ‘,’ CSV HEADER;