Skip to main content

Explore Problems

Certifications Quiz Pricing

⌘K

Production SQL & Engineering

Course Contents

0/15

Introduction to Tables CTAS vs CREATE/INSERT CTAS vs Views CTAS Syntax Use Case: Optimize Performance How DB Executes CTAS Use Case: Snapshots Use Case: Data Warehouse Introduction to TEMP Tables TEMP Syntax & Example How DB Executes TEMP Tables TEMP Table Use Cases My opinion about TEMP Tables Table Summary Compare All Methods

0/10

Introduction to Stored Procedures Basics of Stored Procedures Parameters Multi-Queries in Stored Procedure Variables Control Flow IF ELSE Error Handling TRY & CATCH Styling Stored Procedures What are Triggers Triggers Use Case

0/23

Introduction Indexes Types of Indexes Heap Structure Clustered Index NonClustered Index Clustered vs NonClustered Index How to Create INDEX Composite Index What is Columnstore Index?Process of Building Columnstore Index Columnstore vs Rowstore Index How to Create Columnstore Index Unique Index Filter Index Choose Right Index Monitor Usage Monitor Missing Indexes Monitor Duplicate Indexes Update Statistics Fragmentations Execution Plan SQL hints Indexing Strategy

0/4

Introduction to Partitions The Process of Partitions Create Partitioned Tables The Performance of Partitions

0/9

Introduction to Performance Tips Performance Tips for Fetching Data Performance Tips for Filtering Performance Tips for Joining Performance Tips for Aggregation Performance Tips for Subquiers Performance Tips for Table DDL Performance Tips for Indexing Performance Tips Summary

0/8

Introduction to AI & SQL 11-1 Intro AI What is ChatGPT & Copilot ChatGPT vs Copliot How to Use Copilot ChatGPT Prompt Structure ChatGPT Prompts for SQL Developers ChatGPT Prompts for SQL Learning

Loading...

Loading content...