Skip to main content

Explore Problems

Certifications Quiz Pricing

⌘K

Production SQL & Engineering

Course Contents

Introduction to Tables

CTAS vs CREATE/INSERT

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

Compare All Methods

Introduction to Stored Procedures

Basics of Stored Procedures

Multi-Queries in Stored Procedure

Control Flow IF ELSE

Error Handling TRY & CATCH

Styling Stored Procedures

What are Triggers

Triggers Use Case

Introduction Indexes

Types of Indexes

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

Choose Right Index

Monitor Missing Indexes

Monitor Duplicate Indexes

Update Statistics

Indexing Strategy

Introduction to Partitions

The Process of Partitions

Create Partitioned Tables

The Performance of Partitions

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

Introduction to AI & SQL

What is ChatGPT & Copilot

ChatGPT vs Copliot

How to Use Copilot

ChatGPT Prompt Structure

ChatGPT Prompts for SQL Developers

ChatGPT Prompts for SQL Learning

Fragmentations

Detect and fix index fragmentation — the types of fragmentation and what causes them, detecting it, REORGANIZE versus REBUILD, fill factor, and an automated maintenance script.

Loading...

Loading content...