Contact sales

Pinal Dave

Pinal Dave

Pluralsight Author

Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 24 years of hands-on experience. He holds a Master of Science degree and numerous database certifications. Pinal has authored 14 SQL Server database books, 100 Pluralsight courses, 11 Code Labs, and 5 Skill Assessments. To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,800 database tech articles on his blog at https://blog.sqlauthority.com.

Topics Authored

Data Professional

Technology Leader

Software Development

IT Ops

Security Professional

Courses Authored

111

Total Ratings

7141

Avg Course Ratings

4.0

Courses by Pinal

All Courses Labs

Course

Filter and Manipulate Data with Aggregations in MongoDB

Intermediate

1h 20m

Oct 08, 2025

Course

Work with Dates, Arrays, and Nested Data in MongoDB

Intermediate

1h 18m

Sep 19, 2025

Course

Cost Optimization and Resource Management in Snowflake

Intermediate

1h 3m

Sep 08, 2025

Course

Modify Data for Analysis in MongoDB

Intermediate

1h 18m

Aug 19, 2025

Course

Query and Performance Tuning in Snowflake

Intermediate

56m

Jul 29, 2025

Course

Query Data in MongoDB

Intermediate

1h 24m

Jul 09, 2025

Course

First Look: Apache Airflow 3.0

Beginner

33m

Jun 24, 2025

Course

Up and Running with MongoDB for Data Analysts

Beginner

1h 14m

Jun 18, 2025

Course

Leveraging Apache Iceberg Catalogs

Intermediate

21m

May 29, 2025

Course

Effective Workflow Management with Apache Airflow

Intermediate

21m

May 15, 2025

Course

Up and Running with Apache Airflow

Intermediate

34m

Apr 28, 2025

(18)

Course

Packages, Macros, and Performance Optimization in dbt

Advanced

42m

Apr 23, 2025

Labs

Create Complex DAGs and Task Dependencies in Apache Airflow

Intermediate

38m

Apr 23, 2025

Labs

Manage Task Failures and Retries in Apache Airflow

Intermediate

26m

Apr 05, 2025

Course

SQL and Jinja for dbt

Beginner

43m

Apr 02, 2025

(12)

Labs

Integrate Databases with Apache Airflow

Intermediate

37m

Mar 20, 2025

Labs

Advanced Data Manipulation with PySpark

Intermediate

1h 10m

Mar 04, 2025

Labs

Create and Use User-defined Functions with PySpark

Intermediate

41m

Feb 28, 2025

Labs

Connect to Non-relational Databases with Python

Intermediate

20m

Feb 19, 2025

Labs

Connect to Relational Databases with Python

Intermediate

40m

Feb 18, 2025

Course

Database Connections and Data Extraction with Python

Intermediate

58m

Feb 13, 2025

(12)

Course

The Data Analysis Workflow

Beginner

44m

Feb 03, 2025

(13)

Labs

Basic Data Manipulation with PySpark

Intermediate

44m

Jan 29, 2025

Labs

Write and Run a Basic DAG in Apache Airflow

Intermediate

37m

Jan 22, 2025

Course

Performance Optimization in Apache Spark

Intermediate

39m

Jan 07, 2025

Course

Window and Join Operations in Apache Spark

Intermediate

18m

Dec 13, 2024

Course

Transform Data Using PySpark

Intermediate

43m

Dec 11, 2024

Course

Create and Use Custom Functions in R

Beginner

16m

Nov 25, 2024

Course

Write Complex Subqueries in SQL

Intermediate

13m

Oct 01, 2024

(58)

Course

Simplify SQL Queries with Common Table Expressions (CTEs)

Intermediate

13m

Sep 26, 2024

(47)

Course

Perform Complex JOINS in SQL

Intermediate

13m

Sep 23, 2024

(73)

Course

Clone Data in Snowflake

Intermediate

18m

Aug 26, 2024

Course

Scale Data in Snowflake

Intermediate

17m

Aug 08, 2024

Course

Query Data with Snowflake

Intermediate

36m

Jul 23, 2024

(11)

Course

Performance Optimization in Snowflake

Intermediate

15m

Jul 02, 2024

(13)

Course

Managing Modern Databases with Generative AI

Beginner

13m

Jun 26, 2024

(17)

Course

Data Show and Tell: Crafting the Ideal Basketball Team with Python

Advanced

9m

Jun 25, 2024

(16)

Course

Integrate Databases with Apache Airflow

Intermediate

14m

Jun 07, 2024

(19)

Course

Exploratory Data Analysis for Data Scientists

Intermediate

28m

May 29, 2024

(11)

Course

Preparing Data with Generative AI

Beginner

9m

May 28, 2024

(14)

Course

SnowPro Advanced Data Engineer: Performance Optimization

Intermediate

1h 4m

Mar 28, 2024

(12)

Course

Advanced Hierarchical Data Management in SQL Server

Beginner

32m

Mar 13, 2024

Course

Real-world Scenarios: SQL Server Query Tuning in Action

Beginner

29m

Mar 05, 2024

(13)

Course

Optimize Data Manipulation Performance in SQL Server

Beginner

27m

Feb 21, 2024

(11)

Course

Automate Data Workflows with SQL Server Stored Procedures

Beginner

24m

Feb 21, 2024

(22)

Course

SQL Server Functions for Smart Data Handling

Beginner

24m

Feb 16, 2024

(11)

Course

SQL Server Data Manipulation Essentials

Beginner

27m

Feb 13, 2024

(14)

Course

Advanced Data Retrieval Techniques in SQL Server

Beginner

26m

Feb 13, 2024

(13)

Course

Advanced Query Optimization Techniques in SQL Server

Beginner

30m

Jan 27, 2024

(20)

Course

Identifying and Understanding Business Problems for Data Scientists

Intermediate

26m

Jan 16, 2024

(11)

Course

Recurrent Neural Networks (RNNs): Deep Learning for Sequences and Time Series

Beginner

31m

Jan 03, 2024

(11)

Course

Introduction to LangChain for Data Professionals

Intermediate

38m

Dec 07, 2023

(38)

Labs

Guided: Build a CLI Game with Go

Intermediate

37m

Nov 30, 2023

Course

TensorFlow Developer Certificate - Time Series, Sequences, and Predictions

Beginner

1h 6m

Nov 27, 2023

(12)

Labs

Guided: Build a CLI Password Generator with Go

Intermediate

27m

Nov 21, 2023

Course

SnowPro Core: Snowflake Cloud Data Platform Features and Architecture

Beginner

1h 2m

Nov 01, 2023

(18)

Course

Behavior-driven Development (BDD) with Cucumber and Java

Intermediate

2h 12m

Oct 17, 2023

(33)

Course

Grouping Data into Bins and Categories

Beginner

53m

Oct 10, 2023

Course

Gherkin Fundamentals

Intermediate

2h 7m

Sep 11, 2023

(29)

Course

Working with Hierarchies in SQL Server

Beginner

49m

Aug 24, 2023

(29)

Course

MySQL Administration

Beginner

2h 1m

Aug 07, 2023

(26)

Course

SQL Server Security Fundamentals

Beginner

1h 29m

Jul 19, 2023

(26)

Course

Validate Data Cleanliness Using Asserts in Python

Intermediate

42m

May 01, 2023

Course

Profiling Go Applications

Advanced

1h 30m

Apr 25, 2023

(15)

Course

SnowPro Core: Data Protection and Data Sharing

Beginner

1h 2m

Feb 17, 2023

(13)

Course

Managing Go Projects

Intermediate

1h 35m

Feb 09, 2023

(45)

Course

SnowPro Core: Performance Concepts

Beginner

1h 17m

Dec 07, 2022

(14)

Course

Debugging in Go

Beginner

1h 12m

Nov 21, 2022

(42)

Course

Accessing Non-relational Databases in Go

Intermediate

47m

Oct 05, 2022

(20)

Course

Accessing Relational Databases in Go

Intermediate

1h 4m

Jul 21, 2022

(44)

Course

Impact with Slowloris

Intermediate

21m

May 20, 2021

(21)

Course

Open Source Cloud: Executive Briefing

Beginner

25m

Aug 06, 2020

(22)

Course

Capturing Logic with Stored Procedures in MariaDB

Advanced

1h 9m

Dec 02, 2019

(13)

Course

MariaDB Functions Playbook

Advanced

1h 41m

Nov 13, 2019

(12)

Course

MariaDB Data Manipulation Playbook

Intermediate

1h 34m

Nov 12, 2019

(12)

Course

Combining and Filtering Data with MariaDB

Beginner

2h 36m

Nov 08, 2019

(15)

Course

Querying Data from MariaDB

Beginner

59m

Nov 07, 2019

(19)

Course

Foundations of Document Databases with MongoDBRETIRED

Beginner

2h 28m

Nov 05, 2025

(237)

Course

Build Your First Data Visualization with Google ChartsRETIRED

Beginner

48m

Sep 12, 2025

(12)

Course

Build Your First Data Visualization with ChartBlocksRETIRED

Beginner

35m

Sep 12, 2025

(15)

Course

Build Your First Data Visualization with FusionChartsRETIRED

Beginner

47m

Sep 12, 2025

(11)

Course

Build Your First Data Visualization with EpochRETIRED

Beginner

40m

Sep 12, 2025

(15)

Course

Storing and Managing Data with Postgres on HerokuRETIRED

Intermediate

2h 27m

Dec 06, 2024

(18)

Course

Designing a Data Archiving Strategy on Microsoft AzureRETIRED

Advanced

1h 18m

Dec 06, 2024

(27)

Course

SQL Extensibility Features with Snowflake 5RETIRED

Intermediate

1h 2m

Dec 02, 2024

(25)

Course

Understanding Non-relational Data with AzureRETIRED

Intermediate

56m

Aug 22, 2024

(75)

Course

PostgreSQL: Advanced SQL QueriesRETIRED

Advanced

1h 42m

Jul 12, 2024

(105)

Course

Getting Started with MariaDBRETIRED

Beginner

2h 23m

Jul 12, 2024

(28)

Course

MySQL Query Optimization and Performance TuningRETIRED

Intermediate

1h 51m

Jul 12, 2024

(178)

Course

PostgreSQL: Index Tuning and Performance OptimizationRETIRED

Intermediate

3h 7m

Jul 12, 2024

(94)

Course

MySQL Backup and Recovery FundamentalsRETIRED

Intermediate

1h 15m

Jul 12, 2024

(143)

Course

MySQL Indexing for PerformanceRETIRED

Intermediate

1h 39m

Jul 12, 2024

(223)

Course

phpMyAdmin FundamentalsRETIRED

Intermediate

1h 41m

Jul 12, 2024

(92)

Course

PostgreSQL: Advanced Server ProgrammingRETIRED

Intermediate

2h 14m

Jul 12, 2024

(50)

Course

SQL Server Performance: Indexing BasicsRETIRED

Intermediate

1h 59m

Jul 12, 2024

(712)

Course

Monitoring MySQL with Performance SchemaRETIRED

Intermediate

1h 59m

Jul 12, 2024

(15)

Course

MySQL Fundamentals Part 2RETIRED

Intermediate

2h 43m

Jul 12, 2024

(397)

Course

MySQL FundamentalsRETIRED

Intermediate

2h 37m

Jul 12, 2024

(986)

Course

Analyzing SQL Server Query PlansRETIRED

Advanced

2h 30m

Jul 08, 2024

(101)

Course

Using Memory-optimized Tables and Native Stored ProceduresRETIRED

Intermediate

1h 58m

Jul 08, 2024

(46)

Course

SQL Server Performance: Introduction to Query TuningRETIRED

Intermediate

3h 55m

Jun 06, 2023

(551)

Course

Play by Play: SQL Server Administration with Pinal DaveRETIRED

Advanced

1h 43m

Jul 31, 2021

(243)

Course

Building a High Traffic, Profitable BlogRETIRED

Intermediate

1h 40m

Jul 31, 2021

(119)

Course

SQL Server 2014 Administration New FeaturesRETIRED

Intermediate

4h 17m

Jul 31, 2021

(189)

Course

Building a Successful BlogRETIRED

Beginner

2h 5m

Jul 31, 2021

(207)

Course

MySQL Workbench Guided TourRETIRED

Intermediate

1h 52m

Jul 31, 2021

(129)

Course

PostgreSQL: Introduction to SQL QueriesRETIRED

Beginner

2h 19m

Jul 31, 2021

(152)

Course

SQL Server Questions and AnswersRETIRED

Intermediate

2h 13m

Jul 31, 2021

(296)

Course

Introduction to SQuirreL Universal SQL ClientRETIRED

Beginner

1h 25m

Jul 31, 2021

(65)

Course

PostgreSQL: Getting StartedRETIRED

Beginner

1h 52m

Aug 13, 2020

(379)

Course

Introduction to ColdFusionRETIRED

Intermediate

2h 14m

Jan 28, 2020

(116)