
Pinal Dave
Pluralsight Author
Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 22 years of hands-on experience. He holds a Master of Science degree and numerous database certifications. Pinal has authored 14 SQL Server database books, 87 Pluralsight courses and 4 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
Technology Leader
Data Professional
Security Professional
Contents Authored
85
Total Ratings
4865
Avg Course Ratings
3.9
Courses by Pinal
-
Course
DataDatabase Connections and Data Extraction with PythonDataIntermediate
58m 53s
Feb 13, 2025
Course
DataThe Data Analysis WorkflowDataBeginner
44m 38s
Feb 03, 2025
Labs
DataBasic Data Manipulation with PySparkDataIntermediate
46m
Jan 29, 2025
Labs
DataWrite and Run a Basic DAG in Apache AirflowDataIntermediate
20m
Jan 22, 2025
Course
DataPerformance Optimization in Apache SparkDataIntermediate
39m 32s
Jan 07, 2025
Course
DataWindow and Join Operations in Apache SparkDataIntermediate
18m 15s
Dec 13, 2024
Course
DataTransform Data Using PySparkDataIntermediate
43m 35s
Dec 11, 2024
Course
DataCreate and Use Custom Functions in RDataBeginner
16m 9s
Nov 25, 2024
Course
DataWrite Complex Subqueries in SQLDataIntermediate
13m 59s
Oct 01, 2024
(25)Course
DataSimplify SQL Queries with Common Table Expressions (CTEs)DataIntermediate
13m 11s
Sep 26, 2024
(19)Course
DataPerform Complex JOINS in SQLDataIntermediate
13m 27s
Sep 23, 2024
(27)Course
DataClone Data in SnowflakeDataIntermediate
18m 32s
Aug 26, 2024
Course
DataScale Data in SnowflakeDataIntermediate
17m 21s
Aug 08, 2024
Course
DataQuery Data with SnowflakeDataIntermediate
36m 49s
Jul 23, 2024
Course
DataPerformance Optimization in SnowflakeDataIntermediate
15m 17s
Jul 02, 2024
Course
AIManaging Modern Databases with Generative AIAIBeginner
13m 21s
Jun 26, 2024
(15)Course
DataData Show and Tell: Crafting the Ideal Basketball Team with PythonDataAdvanced
9m 52s
Jun 25, 2024
(16)Course
DataIntegrate Databases with Apache AirflowDataIntermediate
14m 37s
Jun 07, 2024
(14)Course
DataExploratory Data Analysis for Data ScientistsDataIntermediate
28m 58s
May 29, 2024
Course
AIPreparing Data with Generative AIAIBeginner
9m 55s
May 28, 2024
(12)Course
DataSnowPro Advanced Data Engineer: Performance OptimizationDataIntermediate
1h 4m 33s
Mar 28, 2024
Course
DataAdvanced Hierarchical Data Management in SQL ServerDataBeginner
32m 8s
Mar 13, 2024
Course
DataReal-world Scenarios: SQL Server Query Tuning in ActionDataBeginner
29m 45s
Mar 05, 2024
Course
DataOptimize Data Manipulation Performance in SQL ServerDataBeginner
27m 46s
Feb 21, 2024
(11)Course
DataAutomate Data Workflows with SQL Server Stored ProceduresDataBeginner
24m 26s
Feb 21, 2024
(14)Course
DataSQL Server Functions for Smart Data HandlingDataBeginner
24m 58s
Feb 16, 2024
Course
DataSQL Server Data Manipulation EssentialsDataBeginner
27m 2s
Feb 13, 2024
(13)Course
DataAdvanced Data Retrieval Techniques in SQL ServerDataBeginner
26m 44s
Feb 13, 2024
(13)Course
DataAdvanced Query Optimization Techniques in SQL ServerDataBeginner
30m 18s
Jan 27, 2024
(18)Course
DataIdentifying and Understanding Business Problems for Data ScientistsDataIntermediate
26m 43s
Jan 16, 2024
Course
AIDataRecurrent Neural Networks (RNNs): Deep Learning for Sequences and Time SeriesAIDataBeginner
31m 49s
Jan 03, 2024
Course
DataIntroduction to LangChain for Data ProfessionalsDataIntermediate
38m 12s
Dec 07, 2023
(29)Labs
Core TechGuided: Build a CLI Game with GoCore TechIntermediate
23m
Nov 30, 2023
Course
DataTensorFlow Developer Certificate - Time Series, Sequences, and PredictionsDataBeginner
1h 6m
Nov 27, 2023
Labs
Core TechGuided: Build a CLI Password Generator with GoCore TechIntermediate
25m
Nov 21, 2023
Course
DataSnowPro Core: Snowflake Cloud Data Platform Features and ArchitectureDataBeginner
1h 2m 49s
Nov 01, 2023
(15)Course
Core TechBehavior-driven Development (BDD) with Cucumber and JavaCore TechIntermediate
2h 12m 11s
Oct 17, 2023
(27)Course
DataGrouping Data into Bins and CategoriesDataBeginner
53m 20s
Oct 10, 2023
Course
Core TechGherkin FundamentalsCore TechIntermediate
2h 7m 38s
Sep 11, 2023
(24)Course
DataWorking with Hierarchies in SQL ServerDataBeginner
49m 19s
Aug 24, 2023
(22)Course
DataMySQL AdministrationDataBeginner
2h 1m 22s
Aug 07, 2023
(12)Course
DataSQL Server Security FundamentalsDataBeginner
1h 29m 38s
Jul 19, 2023
(19)Course
DataValidate Data Cleanliness Using Asserts in PythonDataIntermediate
42m 52s
May 01, 2023
Course
Core TechProfiling Go ApplicationsCore TechAdvanced
1h 30m 56s
Apr 25, 2023
(15)Course
DataSnowPro Core: Data Protection and Data SharingDataBeginner
1h 2m 11s
Feb 17, 2023
(11)Course
Core TechManaging Go ProjectsCore TechIntermediate
1h 35m 54s
Feb 09, 2023
(37)Course
DataSnowPro Core: Performance ConceptsDataBeginner
1h 17m 11s
Dec 07, 2022
(13)Course
Core TechDebugging in GoCore TechBeginner
1h 12m 58s
Nov 21, 2022
(38)Course
Core TechAccessing Non-relational Databases in GoCore TechIntermediate
47m 51s
Oct 05, 2022
(19)Course
Core TechAccessing Relational Databases in GoCore TechIntermediate
1h 4m 3s
Jul 21, 2022
(43)Course
SecurityImpact with SlowlorisSecurityIntermediate
21m 59s
May 20, 2021
(21)Course
DataBuild Your First Data Visualization with EpochDataBeginner
40m 51s
Feb 01, 2021
(15)Course
DataBuild Your First Data Visualization with ChartBlocksDataBeginner
35m 45s
Dec 01, 2020
(15)Course
Core TechOpen Source Cloud: Executive BriefingCore TechBeginner
25m 51s
Aug 06, 2020
(22)Course
DataBuild Your First Data Visualization with FusionChartsDataBeginner
47m 7s
Jun 29, 2020
(11)Course
DataFoundations of Document Databases with MongoDBDataBeginner
2h 28m 45s
May 06, 2020
(230)Course
DataBuild Your First Data Visualization with Google ChartsDataBeginner
48m 59s
Mar 26, 2020
(12)Course
DataCapturing Logic with Stored Procedures in MariaDBDataAdvanced
1h 9m 1s
Dec 02, 2019
(11)Course
DataMariaDB Functions PlaybookDataAdvanced
1h 41m 52s
Nov 13, 2019
(11)Course
DataMariaDB Data Manipulation PlaybookDataIntermediate
1h 34m 48s
Nov 12, 2019
(11)Course
DataCombining and Filtering Data with MariaDBDataBeginner
2h 36m 39s
Nov 08, 2019
(14)Course
DataQuerying Data from MariaDBDataBeginner
59m 53s
Nov 07, 2019
(16)
-
Course
DataDatabase Connections and Data Extraction with PythonDataIntermediate
58m 53s
Feb 13, 2025
Course
DataThe Data Analysis WorkflowDataBeginner
44m 38s
Feb 03, 2025
Course
DataPerformance Optimization in Apache SparkDataIntermediate
39m 32s
Jan 07, 2025
Course
DataWindow and Join Operations in Apache SparkDataIntermediate
18m 15s
Dec 13, 2024
Course
DataTransform Data Using PySparkDataIntermediate
43m 35s
Dec 11, 2024
Course
DataCreate and Use Custom Functions in RDataBeginner
16m 9s
Nov 25, 2024
Course
DataWrite Complex Subqueries in SQLDataIntermediate
13m 59s
Oct 01, 2024
(25)Course
DataSimplify SQL Queries with Common Table Expressions (CTEs)DataIntermediate
13m 11s
Sep 26, 2024
(19)Course
DataPerform Complex JOINS in SQLDataIntermediate
13m 27s
Sep 23, 2024
(27)Course
DataClone Data in SnowflakeDataIntermediate
18m 32s
Aug 26, 2024
Course
DataScale Data in SnowflakeDataIntermediate
17m 21s
Aug 08, 2024
Course
DataQuery Data with SnowflakeDataIntermediate
36m 49s
Jul 23, 2024
Course
DataPerformance Optimization in SnowflakeDataIntermediate
15m 17s
Jul 02, 2024
Course
AIManaging Modern Databases with Generative AIAIBeginner
13m 21s
Jun 26, 2024
(15)Course
DataData Show and Tell: Crafting the Ideal Basketball Team with PythonDataAdvanced
9m 52s
Jun 25, 2024
(16)Course
DataIntegrate Databases with Apache AirflowDataIntermediate
14m 37s
Jun 07, 2024
(14)Course
DataExploratory Data Analysis for Data ScientistsDataIntermediate
28m 58s
May 29, 2024
Course
AIPreparing Data with Generative AIAIBeginner
9m 55s
May 28, 2024
(12)Course
DataSnowPro Advanced Data Engineer: Performance OptimizationDataIntermediate
1h 4m 33s
Mar 28, 2024
Course
DataAdvanced Hierarchical Data Management in SQL ServerDataBeginner
32m 8s
Mar 13, 2024
Course
DataReal-world Scenarios: SQL Server Query Tuning in ActionDataBeginner
29m 45s
Mar 05, 2024
Course
DataOptimize Data Manipulation Performance in SQL ServerDataBeginner
27m 46s
Feb 21, 2024
(11)Course
DataAutomate Data Workflows with SQL Server Stored ProceduresDataBeginner
24m 26s
Feb 21, 2024
(14)Course
DataSQL Server Functions for Smart Data HandlingDataBeginner
24m 58s
Feb 16, 2024
Course
DataSQL Server Data Manipulation EssentialsDataBeginner
27m 2s
Feb 13, 2024
(13)Course
DataAdvanced Data Retrieval Techniques in SQL ServerDataBeginner
26m 44s
Feb 13, 2024
(13)Course
DataAdvanced Query Optimization Techniques in SQL ServerDataBeginner
30m 18s
Jan 27, 2024
(18)Course
DataIdentifying and Understanding Business Problems for Data ScientistsDataIntermediate
26m 43s
Jan 16, 2024
Course
AIDataRecurrent Neural Networks (RNNs): Deep Learning for Sequences and Time SeriesAIDataBeginner
31m 49s
Jan 03, 2024
Course
DataIntroduction to LangChain for Data ProfessionalsDataIntermediate
38m 12s
Dec 07, 2023
(29)Course
DataTensorFlow Developer Certificate - Time Series, Sequences, and PredictionsDataBeginner
1h 6m
Nov 27, 2023
Course
DataSnowPro Core: Snowflake Cloud Data Platform Features and ArchitectureDataBeginner
1h 2m 49s
Nov 01, 2023
(15)Course
Core TechBehavior-driven Development (BDD) with Cucumber and JavaCore TechIntermediate
2h 12m 11s
Oct 17, 2023
(27)Course
DataGrouping Data into Bins and CategoriesDataBeginner
53m 20s
Oct 10, 2023
Course
Core TechGherkin FundamentalsCore TechIntermediate
2h 7m 38s
Sep 11, 2023
(24)Course
DataWorking with Hierarchies in SQL ServerDataBeginner
49m 19s
Aug 24, 2023
(22)Course
DataMySQL AdministrationDataBeginner
2h 1m 22s
Aug 07, 2023
(12)Course
DataSQL Server Security FundamentalsDataBeginner
1h 29m 38s
Jul 19, 2023
(19)Course
DataValidate Data Cleanliness Using Asserts in PythonDataIntermediate
42m 52s
May 01, 2023
Course
Core TechProfiling Go ApplicationsCore TechAdvanced
1h 30m 56s
Apr 25, 2023
(15)Course
DataSnowPro Core: Data Protection and Data SharingDataBeginner
1h 2m 11s
Feb 17, 2023
(11)Course
Core TechManaging Go ProjectsCore TechIntermediate
1h 35m 54s
Feb 09, 2023
(37)Course
DataSnowPro Core: Performance ConceptsDataBeginner
1h 17m 11s
Dec 07, 2022
(13)Course
Core TechDebugging in GoCore TechBeginner
1h 12m 58s
Nov 21, 2022
(38)Course
Core TechAccessing Non-relational Databases in GoCore TechIntermediate
47m 51s
Oct 05, 2022
(19)Course
Core TechAccessing Relational Databases in GoCore TechIntermediate
1h 4m 3s
Jul 21, 2022
(43)Course
SecurityImpact with SlowlorisSecurityIntermediate
21m 59s
May 20, 2021
(21)Course
DataBuild Your First Data Visualization with EpochDataBeginner
40m 51s
Feb 01, 2021
(15)Course
DataBuild Your First Data Visualization with ChartBlocksDataBeginner
35m 45s
Dec 01, 2020
(15)Course
Core TechOpen Source Cloud: Executive BriefingCore TechBeginner
25m 51s
Aug 06, 2020
(22)Course
DataBuild Your First Data Visualization with FusionChartsDataBeginner
47m 7s
Jun 29, 2020
(11)Course
DataFoundations of Document Databases with MongoDBDataBeginner
2h 28m 45s
May 06, 2020
(230)Course
DataBuild Your First Data Visualization with Google ChartsDataBeginner
48m 59s
Mar 26, 2020
(12)Course
DataCapturing Logic with Stored Procedures in MariaDBDataAdvanced
1h 9m 1s
Dec 02, 2019
(11)Course
DataMariaDB Functions PlaybookDataAdvanced
1h 41m 52s
Nov 13, 2019
(11)Course
DataMariaDB Data Manipulation PlaybookDataIntermediate
1h 34m 48s
Nov 12, 2019
(11)Course
DataCombining and Filtering Data with MariaDBDataBeginner
2h 36m 39s
Nov 08, 2019
(14)Course
DataQuerying Data from MariaDBDataBeginner
59m 53s
Nov 07, 2019
(16)
-
Labs
DataBasic Data Manipulation with PySparkDataIntermediate
46m
Jan 29, 2025
Labs
DataWrite and Run a Basic DAG in Apache AirflowDataIntermediate
20m
Jan 22, 2025
Labs
Core TechGuided: Build a CLI Game with GoCore TechIntermediate
23m
Nov 30, 2023
Labs
Core TechGuided: Build a CLI Password Generator with GoCore TechIntermediate
25m
Nov 21, 2023
-
Course
CloudStoring and Managing Data with Postgres on HerokuRETIREDCloudIntermediate
2h 27m 11s
Dec 06, 2024
(18)Course
DataSQL Extensibility Features with Snowflake 5RETIREDDataIntermediate
1h 2m 21s
Dec 02, 2024
(25)Course
DataMonitoring MySQL with Performance SchemaRETIREDDataIntermediate
1h 59m 30s
Jul 12, 2024
(15)Course
DataMySQL Query Optimization and Performance TuningRETIREDDataIntermediate
1h 51m 1s
Jul 12, 2024
(174)Course
DataSQL Server Performance: Indexing BasicsRETIREDDataIntermediate
1h 59m 8s
Jul 12, 2024
(711)Course
DataPostgreSQL: Advanced Server ProgrammingRETIREDDataIntermediate
2h 14m 55s
Jul 12, 2024
(50)Course
DataGetting Started with MariaDBRETIREDDataBeginner
2h 23m 27s
Jul 12, 2024
(28)Course
DataphpMyAdmin FundamentalsRETIREDDataIntermediate
1h 41m 19s
Jul 12, 2024
(92)Course
DataPostgreSQL: Index Tuning and Performance OptimizationRETIREDDataIntermediate
3h 7m 13s
Jul 12, 2024
(94)Course
DataPostgreSQL: Advanced SQL QueriesRETIREDDataAdvanced
1h 42m 13s
Jul 12, 2024
(104)Course
DataAnalyzing SQL Server Query PlansRETIREDDataAdvanced
2h 30m 37s
Jul 08, 2024
(98)Course
DataUsing Memory-optimized Tables and Native Stored ProceduresRETIREDDataIntermediate
1h 58m 57s
Jul 08, 2024
(42)Course
DataSQL Server Performance: Introduction to Query TuningRETIREDDataIntermediate
3h 55m 31s
Jun 06, 2023
(551)Course
DataSQL Server 2014 Administration New FeaturesRETIREDDataIntermediate
4h 17m 48s
Jul 31, 2021
(189)Course
DataPostgreSQL: Introduction to SQL QueriesRETIREDDataBeginner
2h 19m 22s
Jul 31, 2021
(151)Course
Core TechIntroduction to SQuirreL Universal SQL ClientRETIREDCore TechBeginner
1h 25m 25s
Jul 31, 2021
(65)Course
DataPlay by Play: SQL Server Administration with Pinal DaveRETIREDDataAdvanced
1h 43m 26s
Jul 31, 2021
(243)Course
Core TechBuilding a Successful BlogRETIREDCore TechBeginner
2h 5m 59s
Jul 31, 2021
(207)Course
Core TechBuilding a High Traffic, Profitable BlogRETIREDCore TechIntermediate
1h 40m 10s
Jul 31, 2021
(119)Course
DataMySQL Workbench Guided TourRETIREDDataIntermediate
1h 52m 59s
Jul 31, 2021
(128)Course
DataSQL Server Questions and AnswersRETIREDDataIntermediate
2h 13m 45s
Jul 31, 2021
(296)Course
DataPostgreSQL: Getting StartedRETIREDDataBeginner
1h 52m 52s
Aug 13, 2020
(379)Course
Core TechIntroduction to ColdFusionRETIREDCore TechIntermediate
2h 14m 44s
Jan 28, 2020
(116)