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, 91 Pluralsight courses and 11 Code Labs. 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

Software Development

Data Professional

Technology Leader

Security Professional

Courses Authored

96

Total Ratings

5073

Avg Course Ratings

4.0

Courses by Pinal

All Courses Labs

Course

Effective Workflow Management with Apache Airflow

Intermediate

21m 5s

May 15, 2025

Course

Up and Running with Apache Airflow

Intermediate

34m 42s

Apr 28, 2025

Labs

Create Complex DAGs and Task Dependencies in Apache Airflow

Intermediate

43m

Apr 23, 2025

Course

Packages, Macros, and Performance Optimization in dbt

Advanced

42m 27s

Apr 23, 2025

Labs

Manage Task Failures and Retries in Apache Airflow

Intermediate

40m

Apr 05, 2025

Course

SQL and Jinja for dbt

Beginner

43m 26s

Apr 02, 2025

Labs

Integrate Databases with Apache Airflow

Intermediate

46m

Mar 20, 2025

Labs

Advanced Data Manipulation with PySpark

Intermediate

54m

Mar 04, 2025

Labs

Create and Use User-defined Functions with PySpark

Intermediate

43m

Feb 28, 2025

Labs

Connect to Non-relational Databases with Python

Intermediate

33m

Feb 19, 2025

Labs

Connect to Relational Databases with Python

Intermediate

1h 2m

Feb 18, 2025

Course

Database Connections and Data Extraction with Python

Intermediate

58m 53s

Feb 13, 2025

Course

The Data Analysis Workflow

Beginner

44m 38s

Feb 03, 2025

Labs

Basic Data Manipulation with PySpark

Intermediate

40m

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 32s

Jan 07, 2025

Course

Window and Join Operations in Apache Spark

Intermediate

18m 15s

Dec 13, 2024

Course

Transform Data Using PySpark

Intermediate

43m 35s

Dec 11, 2024

Course

Create and Use Custom Functions in R

Beginner

16m 9s

Nov 25, 2024

Course

Write Complex Subqueries in SQL

Intermediate

13m 59s

Oct 01, 2024

(40)

Course

Simplify SQL Queries with Common Table Expressions (CTEs)

Intermediate

13m 11s

Sep 26, 2024

(28)

Course

Perform Complex JOINS in SQL

Intermediate

13m 27s

Sep 23, 2024

(47)

Course

Clone Data in Snowflake

Intermediate

18m 32s

Aug 26, 2024

Course

Scale Data in Snowflake

Intermediate

17m 21s

Aug 08, 2024

Course

Query Data with Snowflake

Intermediate

36m 49s

Jul 23, 2024

(11)

Course

Performance Optimization in Snowflake

Intermediate

15m 17s

Jul 02, 2024

(13)

Course

Managing Modern Databases with Generative AI

Beginner

13m 21s

Jun 26, 2024

(17)

Course

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

Advanced

9m 52s

Jun 25, 2024

(16)

Course

Integrate Databases with Apache Airflow

Intermediate

14m 37s

Jun 07, 2024

(18)

Course

Exploratory Data Analysis for Data Scientists

Intermediate

28m 58s

May 29, 2024

(11)

Course

Preparing Data with Generative AI

Beginner

9m 55s

May 28, 2024

(14)

Course

SnowPro Advanced Data Engineer: Performance Optimization

Intermediate

1h 4m 33s

Mar 28, 2024

(12)

Course

Advanced Hierarchical Data Management in SQL Server

Beginner

32m 8s

Mar 13, 2024

Course

Real-world Scenarios: SQL Server Query Tuning in Action

Beginner

29m 45s

Mar 05, 2024

(11)

Course

Automate Data Workflows with SQL Server Stored Procedures

Beginner

24m 26s

Feb 21, 2024

(20)

Course

Optimize Data Manipulation Performance in SQL Server

Beginner

27m 46s

Feb 21, 2024

(11)

Course

SQL Server Functions for Smart Data Handling

Beginner

24m 58s

Feb 16, 2024

(11)

Course

SQL Server Data Manipulation Essentials

Beginner

27m 2s

Feb 13, 2024

(14)

Course

Advanced Data Retrieval Techniques in SQL Server

Beginner

26m 44s

Feb 13, 2024

(13)

Course

Advanced Query Optimization Techniques in SQL Server

Beginner

30m 18s

Jan 27, 2024

(19)

Course

Identifying and Understanding Business Problems for Data Scientists

Intermediate

26m 43s

Jan 16, 2024

Course

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

Beginner

31m 49s

Jan 03, 2024

(11)

Course

Introduction to LangChain for Data Professionals

Intermediate

38m 12s

Dec 07, 2023

(33)

Labs

Guided: Build a CLI Game with Go

Intermediate

38m

Nov 30, 2023

Course

TensorFlow Developer Certificate - Time Series, Sequences, and Predictions

Beginner

1h 6m

Nov 27, 2023

Labs

Guided: Build a CLI Password Generator with Go

Intermediate

26m

Nov 21, 2023

Course

SnowPro Core: Snowflake Cloud Data Platform Features and Architecture

Beginner

1h 2m 49s

Nov 01, 2023

(17)

Course

Behavior-driven Development (BDD) with Cucumber and Java

Intermediate

2h 12m 11s

Oct 17, 2023

(29)

Course

Grouping Data into Bins and Categories

Beginner

53m 20s

Oct 10, 2023

Course

Gherkin Fundamentals

Intermediate

2h 7m 38s

Sep 11, 2023

(27)

Course

Working with Hierarchies in SQL Server

Beginner

49m 19s

Aug 24, 2023

(26)

Course

MySQL Administration

Beginner

2h 1m 22s

Aug 07, 2023

(17)

Course

SQL Server Security Fundamentals

Beginner

1h 29m 38s

Jul 19, 2023

(24)

Course

Validate Data Cleanliness Using Asserts in Python

Intermediate

42m 52s

May 01, 2023

Course

Profiling Go Applications

Advanced

1h 30m 56s

Apr 25, 2023

(15)

Course

SnowPro Core: Data Protection and Data Sharing

Beginner

1h 2m 11s

Feb 17, 2023

(12)

Course

Managing Go Projects

Intermediate

1h 35m 54s

Feb 09, 2023

(39)

Course

SnowPro Core: Performance Concepts

Beginner

1h 17m 11s

Dec 07, 2022

(13)

Course

Debugging in Go

Beginner

1h 12m 58s

Nov 21, 2022

(41)

Course

Accessing Non-relational Databases in Go

Intermediate

47m 51s

Oct 05, 2022

(20)

Course

Accessing Relational Databases in Go

Intermediate

1h 4m 3s

Jul 21, 2022

(44)

Course

Impact with Slowloris

Intermediate

21m 59s

May 20, 2021

(21)

Course

Build Your First Data Visualization with Epoch

Beginner

40m 51s

Feb 01, 2021

(15)

Course

Build Your First Data Visualization with ChartBlocks

Beginner

35m 45s

Dec 01, 2020

(15)

Course

Open Source Cloud: Executive Briefing

Beginner

25m 51s

Aug 06, 2020

(22)

Course

Build Your First Data Visualization with FusionCharts

Beginner

47m 7s

Jun 29, 2020

(11)

Course

Foundations of Document Databases with MongoDB

Beginner

2h 28m 45s

May 06, 2020

(233)

Course

Build Your First Data Visualization with Google Charts

Beginner

48m 59s

Mar 26, 2020

(12)

Course

Capturing Logic with Stored Procedures in MariaDB

Advanced

1h 9m 1s

Dec 02, 2019

(12)

Course

MariaDB Functions Playbook

Advanced

1h 41m 52s

Nov 13, 2019

(11)

Course

MariaDB Data Manipulation Playbook

Intermediate

1h 34m 48s

Nov 12, 2019

(11)

Course

Combining and Filtering Data with MariaDB

Beginner

2h 36m 39s

Nov 08, 2019

(14)

Course

Querying Data from MariaDB

Beginner

59m 53s

Nov 07, 2019

(18)

Course

Storing and Managing Data with Postgres on HerokuRETIRED

Intermediate

2h 27m 11s

Dec 06, 2024

(18)

Course

SQL Extensibility Features with Snowflake 5RETIRED

Intermediate

1h 2m 21s

Dec 02, 2024

(25)

Course

PostgreSQL: Index Tuning and Performance OptimizationRETIRED

Intermediate

3h 7m 13s

Jul 12, 2024

(94)

Course

PostgreSQL: Advanced SQL QueriesRETIRED

Advanced

1h 42m 13s

Jul 12, 2024

(104)

Course

MySQL Query Optimization and Performance TuningRETIRED

Intermediate

1h 51m 1s

Jul 12, 2024

(174)

Course

SQL Server Performance: Indexing BasicsRETIRED

Intermediate

1h 59m 8s

Jul 12, 2024

(711)

Course

Monitoring MySQL with Performance SchemaRETIRED

Intermediate

1h 59m 30s

Jul 12, 2024

(15)

Course

PostgreSQL: Advanced Server ProgrammingRETIRED

Intermediate

2h 14m 55s

Jul 12, 2024

(50)

Course

Getting Started with MariaDBRETIRED

Beginner

2h 23m 27s

Jul 12, 2024

(28)

Course

phpMyAdmin FundamentalsRETIRED

Intermediate

1h 41m 19s

Jul 12, 2024

(92)

Course

Analyzing SQL Server Query PlansRETIRED

Advanced

2h 30m 37s

Jul 08, 2024

(101)

Course

Using Memory-optimized Tables and Native Stored ProceduresRETIRED

Intermediate

1h 58m 57s

Jul 08, 2024

(46)

Course

SQL Server Performance: Introduction to Query TuningRETIRED

Intermediate

3h 55m 31s

Jun 06, 2023

(551)

Course

PostgreSQL: Introduction to SQL QueriesRETIRED

Beginner

2h 19m 22s

Jul 31, 2021

(152)

Course

MySQL Workbench Guided TourRETIRED

Intermediate

1h 52m 59s

Jul 31, 2021

(129)

Course

Building a Successful BlogRETIRED

Beginner

2h 5m 59s

Jul 31, 2021

(207)

Course

Building a High Traffic, Profitable BlogRETIRED

Intermediate

1h 40m 10s

Jul 31, 2021

(119)

Course

SQL Server Questions and AnswersRETIRED

Intermediate

2h 13m 45s

Jul 31, 2021

(296)

Course

SQL Server 2014 Administration New FeaturesRETIRED

Intermediate

4h 17m 48s

Jul 31, 2021

(189)

Course

Introduction to SQuirreL Universal SQL ClientRETIRED

Beginner

1h 25m 25s

Jul 31, 2021

(65)

Course

Play by Play: SQL Server Administration with Pinal DaveRETIRED

Advanced

1h 43m 26s

Jul 31, 2021

(243)

Course

PostgreSQL: Getting StartedRETIRED

Beginner

1h 52m 52s

Aug 13, 2020

(379)

Course

Introduction to ColdFusionRETIRED

Intermediate

2h 14m 44s

Jan 28, 2020

(116)