Advanced SQL for Professional Developers by Tyler Clark

• Bulk Insert and Export Data with csv Files with Postgres copy Command
• On conflict Do Something Clause in Postgres
• Casting Types in SQL
• Create a Custom SQL Enum Type
• Profiling Queries with SQL Explain Analyze
• Common Table Expressions in SQL
• Filter Grouped and Aggregated Data with SQL Having
• Create Variables and Blocks with Do / Declare in SQL
• Conditional Returns with SQL case / then
• Perform Multiple Steps in One with SQL Transactions
• Create and Safely Handle Nulls in SQL
• Pattern Matching and Regular Expressions in SQL
• Aggregate Inline filters in SQL
• Work with JSON Data in SQL
• Introduction to Advanced SQL for Professional Developers