TRAINING CLASS RECORDINGS (PRE-CONS & POST-CONS)


Title of the document

Training Class Recordings Are Available (12 Classes. Pre-Cons & Post-Cons)

Subscribe Now

At DPS 2021, Pre-Cons & Post-Cons were delivered (collectively called Training Classes). These were 8 hours, focused, deep-dive, demo-based virtual classroom training. Each Training Class was designed to offer intermediate & advanced-level training on a specific topic/subject. These classes offered more knowledge, skills and expertise beyond the summit content.

Recordings are now available. If you missed registering for the LIVE class, no worries, Subscribe Now to the recordings & get 12 Months On-Demand access.

Training Class Finer Details (See below)

Getting The Best Out Of SQL Managed Instance In 2021

Pre-Con Title

Getting The Best Out Of SQL Managed Instance In 2021

Track(s)

Data Administration

Tags

#SQLServer  #Azure #IaaS #Migration #BestPractices

Level

Intermediate

Trainer/Speaker

Niko Neugebauer, Vitor Tomaz, Vitor Pombeiro, Nevena Nikolic

Abstract

Learn about how to become succesfull by understanding and making the best out of the Azure SQL Managed Instance, Microsofts PaaS offering that is most compatible with SQL Server running either on-premises or on IaaS. Get the knowledge of how to connect, configure, tune, monitor & troubleshoot your Instances to get the very best out of them.

Modules/Topics

  NA

Attendee Pre-requisite (if any)

NA

Is this class being recorded?

Yes. This class will be recorded and the registered attendee will get 12 months streaming access to the recorded class. The recordings will be available within 30 days of class completion.

Additional Comments from Instructor/Speaker

No special instructions/comments from the Speaker

Additional Comments from the Organizers

The current pricing is always the lowest. If you like the content, Book Now and save.

Training Classes are instructor-led, demo-based, 8 hours (4 hrs each day).

Due to virtual mode delivery, training classes are not hands-on. The 8-hour delivery is designed for maximum coverage and demos by the instructor. However, delegates will get the training class material (PDFs, demos, scripts, etc, as shared by the instructor) to practice at their convenience.

More Questions?

Visit FAQ page.

BooK Now

[gdlr_button href="https://dataplatformgeeks.com/dps2021/product/getting-the-best-out-of-sql-managed-instance-in-2021-by-microsoft/" target="_blank" size="small" background="#FA3106" color="#ffffff" width="30%" height="200%"]Book Now[/gdlr_button]


Data Engineering Best Practices Using Azure Data Factory

Pre-Con Title

Data Engineering Best Practices Using Azure Data Factory

Track(s)

Business Intelligence & Advanced Analytics

Tags

#ADF  #Azure #IaaS #BestPractices

Level

Intermediate

Trainer/Speaker

Abhishek Narain, Sunil Sabat, Linda Wang

Abstract

In this workshop, we will cover data engineering best practices while using Azure Data Factory - Performance, Secuirty and Scalability being the key focus areas. We will build ETL pipelines as part of the workshop for hands-on leanring.

Modules/Topics

1. Data pipeline overview

  • What is data factory?
  • Data engineering common scenario
  • Getting started and environment setup

2. Data Integration: Connectivity and code-free transformation

  • Bringing data to data lake on Azure: On-premises and SaaS/PaaS datastore connectivity with a Copy activity
  • Transforming data using data flows

3. Best practices for operationalizing data pipelines

  • Govern data using Azure Purview Integration
  • Scalability and Performance considerations
  • Security
  • External integrations with compute engines (Databricks, SProc)
  • Continuous Integration and Continuous Deployment (CICD)

Attendee Pre-requisite (if any)

NA

Is this class being recorded?

Yes. This class will be recorded and the registered attendee will get 12 months streaming access to the recorded class. The recordings will be available within 30 days of class completion.

Additional Comments from Instructor/Speaker

No special instructions/comments from the Speaker

Additional Comments from the Organizers

The current pricing is always the lowest. If you like the content, Book Now and save.

Training Classes are instructor-led, demo-based, 8 hours (4 hrs each day).

Due to virtual mode delivery, training classes are not hands-on. The 8-hour delivery is designed for maximum coverage and demos by the instructor. However, delegates will get the training class material (PDFs, demos, scripts, etc, as shared by the instructor) to practice at their convenience.

More Questions?

Visit FAQ page.

BooK Now

[gdlr_button href="https://dataplatformgeeks.com/dps2021/product/data-engineering-best-practices-using-azure-data-factory-by-microsoft/" target="_blank" size="small" background="#FA3106" color="#ffffff" width="30%" height="200%"]Book Now[/gdlr_button]


It's Time To Learn DAX

Pre-Con Title

It's Time To Learn DAX

Track(s)

Business Intelligence & Advanced Analytics

Tags

#PowerBI #AnalysisServices #DAX #DataModel

Level

Advanced

Trainer/Speaker

Markus Ehrenmueller-Jensen

Abstract

If you want to show more than simply the data provided by the data source and implement calculations in Power BI or Analysis Services Tabular you have to learn to write Data Analysis Expression (DAX). This workshop starts at entry level and jump-starts you into the world of even complex calculations within 8h. In the first module Markus will introduce the basic syntax, functions and concepts (which are best of bread, taken from Excel, SQL and MDX). Then you will learn that you can exchange complexity in the data model with complexity in DAX (and the other way around) in real world examples. Beginners usually struggle to fully understand the differences between calculated columns and measures. That’s why we will dedicate two modules on them. In the last module Markus will pick your brain with complex challenges and advanced techniques, which you can then take as template to apply on your own use cases.

Modules/Topics

1. Syntax and Basic Functions
2. Data Model and DAX - A Symbiosis
3. Calculated Columns
4. Measures
5. Advanced Techniques

Attendee Pre-requisite (if any)

1. Experience with either Power BI Desktop or Analysis Services
2. Basic knowledge in data modelling

Is this class being recorded?

Yes. This class will be recorded and the registered attendee will get 12 months streaming access to the recorded class. The recordings will be available within 30 days of class completion.

Additional Comments from Instructor/Speaker

No special instructions/comments from the Speaker

Additional Comments from the Organizers

The current pricing is always the lowest. If you like the content, Book Now and save.

Training Classes are instructor-led, demo-based, 8 hours (4 hrs each day).

Due to virtual mode delivery, training classes are not hands-on. The 8-hour delivery is designed for maximum coverage and demos by the instructor. However, delegates will get the training class material (PDFs, demos, scripts, etc, as shared by the instructor) to practice at their convenience.

More Questions?

Visit FAQ page.

BooK Now

[gdlr_button href="https://dataplatformgeeks.com/dps2021/product/its-time-to-learn-dax-by-markus-ehrenmueller-jensen/" target="_blank" size="small" background="#FA3106" color="#ffffff" width="30%" height="200%"]Book Now[/gdlr_button]


The Future Of Deployment For Modern Data Platform Applications

Pre-Con Title

The Future Of Deployment For Modern Data Platform Applications

Track(s)

Architecture

Tags

#Arc #bdc #kubernetes #hybrid #dba

Level

Intermediate

Trainer/Speaker

Ben Weissman & Anthony Nocentino

Abstract

First, we will cover the basics of Kubernetes: What is it, who can use it, what can it be used for, why is this different or better than old school deployments through virtual machines. We will then build a Kubernetes cluster and learn how to deploy applications into this cluster. Building on those Kubernetes deployment fundamentals, we will then deploy a SQL Server Big Data Cluster to showcase how we can deploy a complex stateful application in Kubernetes.

We will close the day by working our way through the next gamechanger for Deployments: Azure Arc Data Services, a solution that allows us to deploy managed Azure Data Service to any hardware running Kubernetes (including any cloud vendor) on-premises or in the cloud.

You will leave with the knowledge, scripts, and tools to get started with Kubernetes and Kubernetes based applications today!

Modules/Topics

1. Kubernetes Fundamentals
2. SQL on Kubernetes
3. Big Data Clusters
4. Azure Arc enabled Data Services

Attendee Pre-requisite (if any)

NA

Is this class being recorded?

Yes. This class will be recorded and the registered attendee will get 12 months streaming access to the recorded class. The recordings will be available within 30 days of class completion.

Additional Comments from Instructor/Speaker

No special instructions/comments from the Speaker

Additional Comments from the Organizers

The current pricing is always the lowest. If you like the content, Book Now and save.

Training Classes are instructor-led, demo-based, 8 hours (4 hrs each day).

Due to virtual mode delivery, training classes are not hands-on. The 8-hour delivery is designed for maximum coverage and demos by the instructor. However, delegates will get the training class material (PDFs, demos, scripts, etc, as shared by the instructor) to practice at their convenience.

More Questions?

Visit FAQ page.

BooK Now

[gdlr_button href="https://dataplatformgeeks.com/dps2021/product/the-future-of-deployment-for-modern-data-platform-applications-by-ben-weissman-anthony-nocentino/" target="_blank" size="small" background="#FA3106" color="#ffffff" width="30%" height="200%"]Book Now[/gdlr_button]


Execution Plans In Depth

Pre-Con Title

Execution Plans In Depth

Track(s)

Development

Tags

#ExecutionPlans, #QueryTuning, #Performance

Level

Advanced

Trainer/Speaker

Hugo Kornelis

Abstract

For troubleshooting slow queries, looking at the execution plan is a good starting point. But sometimes, just looking at the plan does not help. Sometimes you need to dig deeper.

In this full-day workshop, you will learn everything you need to be take your understanding of execution plans to the next level. For most of the operators you’ll find in execution plans, we will look at the inner workings, and at properties that affect their behavior. We will also look at how the operators within a plan interact with each other. This will increase your understanding on why the optimizer picks a plan, and what you can do to make it pick a better plan.

Aside from explaining most operators, we will also look at how these operators interact, which will help you understand which areas in complex execution plans can cause performance issues.

If you have seen some execution plans but feel you need to bring your understanding to the next level, then this workshop is for you!

Modules/Topics

1. Common mistakes
2. Reading data
3. Combining data
4. Performance enhancements
5. Manipulating data
6. Ordering and grouping data
7. Parallelism
8. Changing data
9. Batch mode

Attendee Pre-requisite (if any)

Some prior experience in the area of performance tuning and execution plans is expected. This implies a fair understanding of T-SQL.

Is this class being recorded?

Yes. This class will be recorded and the registered attendee will get 12 months streaming access to the recorded class. The recordings will be available within 30 days of class completion.

Additional Comments from Instructor/Speaker

No special instructions/comments from the Speaker

Additional Comments from the Organizers

The current pricing is always the lowest. If you like the content, Book Now and save.

Training Classes are instructor-led, demo-based, 8 hours (4 hrs each day).

Due to virtual mode delivery, training classes are not hands-on. The 8-hour delivery is designed for maximum coverage and demos by the instructor. However, delegates will get the training class material (PDFs, demos, scripts, etc, as shared by the instructor) to practice at their convenience.

More Questions?

Visit FAQ page.

BooK Now

[gdlr_button href="https://dataplatformgeeks.com/dps2021/product/execution-plans-in-depthby-hugo-kornelis/" target="_blank" size="small" background="#FA3106" color="#ffffff" width="30%" height="200%"]Book Now[/gdlr_button]


Azure Synapse Analytics – From Data Ingestion To Visualization

Pre-Con Title

Azure Synapse Analytics – From Data Ingestion To Visualization

Track(s)

Business Intelligence & Advanced Analytics

Tags

#AzureSynapse #Azure #Analytics #DataLake #DataFactory #Spark #SQL #BigData

Level

Intermediate

Trainer/Speaker

Wolfgang Strasser

Abstract

The world of data is getting more and more distributed. On-premises sources, cloud services and IoT data needs to be merged, integrated and brought under a single umbrella for a comprehensive analysis.

With Azure Synapse Analytics, Microsoft adds a player into the cloud analytics field to address and deal with diverse sources, varying structures of data and diverging analytic needs.

Join this workshop to learn why Azure Synapse Analytics is needed to address current analytic needs. Get to know the different technologies that sum up into Azure Synapse. Learn best practices what to consider to execute successful Synapse projects. Create your own Synapse environment. Solve big data data tasks as well as traditional data warehousing question, and at the end of day have a feeling how Azure Synapse can help you in your future data platform/analytics projects.

Modules/Topics

1. Why is a new analytics player needed?
2. Data driven projects – Big data versus Data Warehousing
3. What is Azure Synapse Analytics?
4. Data Ingestion
5. Big Data Analytics
6. Solving Data Warehousing tasks
7. Management / Monitoring
8. Visualization / Data Models

Attendee Pre-requisite (if any)

Basic Azure knowledge is required.

Is this class being recorded?

Yes. This class will be recorded and the registered attendee will get 12 months streaming access to the recorded class. The recordings will be available within 30 days of class completion.

Additional Comments from Instructor/Speaker

No special instructions/comments from the Speaker

Additional Comments from the Organizers

The current pricing is always the lowest. If you like the content, Book Now and save.

Training Classes are instructor-led, demo-based, 8 hours (4 hrs each day).

Due to virtual mode delivery, training classes are not hands-on. The 8-hour delivery is designed for maximum coverage and demos by the instructor. However, delegates will get the training class material (PDFs, demos, scripts, etc, as shared by the instructor) to practice at their convenience.

More Questions?

Visit FAQ page.

BooK Now

[gdlr_button href="https://dataplatformgeeks.com/dps2021/product/azure-synapse-analytics-from-data-ingestion-to-visualization-by-wolfgang-strasser/" target="_blank" size="small" background="#FA3106" color="#ffffff" width="30%" height="200%"]Book Now[/gdlr_button]


PowerShell For The DBA – Let's Do It!

Pre-Con Title

PowerShell For The DBA – Let's Do It!

Track(s)

Data Administration

Tags

#PowerShell #SQLServer

Level

Intermediate

Trainer/Speaker

Ben Miller

Abstract

There are so many servers and so little time today. PowerShell for a DBA is a must in my book to enable you to get more done in less time and with much less clicking. Setup, configuration and management are at the heart of a DBAs work. PowerShell knowledge and know how are more important than ever. This class will give you the tools to get more done as well as enable you to advance in your work with techniques and keep you moving forward past the seemingly hard things of every day DBA work. I will show you how to get your environment set up and take you through remoting, parallel execution of tasks and all about the PowerShell modules that are out there to make your life great. Join me in the quest to become a PowerShell DBA.

Modules/Topics

1. Environment setup
2. PowerShell Module eco-system
3. DbaTools module
4. SqlServer module/05-ImportExcel module
6. SMO Primer
7. DBA work with PowerShell
8. Next Steps to maximize efficiency

Attendee Pre-requisite (if any)

Understanding of DBA work, easy huh?

Is this class being recorded?

Yes. This class will be recorded and the registered attendee will get 12 months streaming access to the recorded class. The recordings will be available within 30 days of class completion.

Additional Comments from Instructor/Speaker

No special instructions/comments from the Speaker

Additional Comments from the Organizers

The current pricing is always the lowest. If you like the content, Book Now and save.

Training Classes are instructor-led, demo-based, 8 hours (4 hrs each day).

Due to virtual mode delivery, training classes are not hands-on. The 8-hour delivery is designed for maximum coverage and demos by the instructor. However, delegates will get the training class material (PDFs, demos, scripts, etc, as shared by the instructor) to practice at their convenience.

More Questions?

Visit FAQ page.

BooK Now

[gdlr_button href="https://dataplatformgeeks.com/dps2021/product/powershell-for-the-dba-lets-do-it-by-ben-miller/" target="_blank" size="small" background="#FA3106" color="#ffffff" width="30%" height="200%"]Book Now[/gdlr_button]


Big Data & Analytics With SQL Server 2019 Big Data Cluster

Pre-Con Title

Big Data & Analytics With SQL Server 2019 Big Data Cluster

Track(s)

Data Science (AI/ML)

Tags

#bigdatacluster #bigdata #sqlserver #hadoop #spark #azure #analytics

Level

Advanced

Trainer/Speaker

Niels Berglund

Abstract

This training session covers big data, data virtualization and analytics in SQL Server 2019 Big Data cluster.

SQL Server 2019 Big Data Cluster, (BDC for short), is the evolution of SQL Server, and its goals are to be able to integrate, manage and analyze data in the peta byte range.

The session starts with an overview of what the BDC is, to get everyone on the same page. After the overview, we look at data virtualization; how we can use the BDC as a data hub. We then drill down and look at how storage pools, and data pools works BDC . From there we look at how we can ingest data into the BDC, and how to analyze the data using the built-in Apache Spark engine. Part of this also looks at using Apache Kafka and Apache Spark together to ingest data into the BDC.

We also see how we can "mount" external HDFS and Azure Data Lake sources in the Big Data Cluster.

Modules/Topics

1. Overview of SQL Server 2019 Big Data Cluster
2. Data Virtualization in the BDC
3. Storage Pools & Data Pools
4. Apache Spark
5. Data Ingestion into the BDC
6. Analytics with Apache Spark

Attendee Pre-requisite (if any)

NA

Is this class being recorded?

Yes. This class will be recorded and the registered attendee will get 12 months streaming access to the recorded class. The recordings will be available within 30 days of class completion.

Additional Comments from Instructor/Speaker

No special instructions/comments from the Speaker

Additional Comments from the Organizers

The current pricing is always the lowest. If you like the content, Book Now and save.

Training Classes are instructor-led, demo-based, 8 hours (4 hrs each day).

Due to virtual mode delivery, training classes are not hands-on. The 8-hour delivery is designed for maximum coverage and demos by the instructor. However, delegates will get the training class material (PDFs, demos, scripts, etc, as shared by the instructor) to practice at their convenience.

More Questions?

Visit FAQ page.

BooK Now

[gdlr_button href="https://dataplatformgeeks.com/dps2021/product/big-data-analytics-with-sql-server-2019-big-data-cluster-by-niels-berglund/" target="_blank" size="small" background="#FA3106" color="#ffffff" width="30%" height="200%"]Book Now[/gdlr_button]


Demystifying Design Principles And Building Impactful Reports In Power BI

Pre-Con Title

Demystifying Design Principles And Building Impactful Reports In Power BI

Track(s)

Business Intelligence & Advanced Analytics

Tags

#powerbi #visualizations #design #reporting #dataviz #aesthetics

Level

Intermediate

Trainer/Speaker

Reid Havens

Abstract

This training is developed and delivered by Microsoft MVP Reid Havens, and covers many essential design principles (and how to apply them) to build impactful reports in Power BI Desktop. Students will learn about how to enhance report design by adding elements such as: drillthrough, bookmarks, report page tooltips, conditional formatting, custom visuals, and more.

There is coverage on best practices and recommendations that build upon the functions and features available in Power BI Desktop, providing you with a strong design foundation upon which you can create your reports.

This course benefits both those new to Power BI and report design and those already familiar with Power BI. If you have a basic working knowledge of Power BI, this training will help fill in any gaps in your knowledge so you have a more complete set of skills.

Regardless of your experience in building visually attractive reports, this course will show you what a stunning Power BI report looks like. Reid will share the many things he does to make his reports stand out from the crowd.

When you apply what you learn to your own reports, you and your users are going to love the results.

Modules/Topics

1. Creating Reports

  • Introducing Reports
  • Introducing Power BI Desktop
  • Connecting to Datasets
  • Understanding the Field Pane
  • Developing Reports
  • Recommended Practices

2. Designing Advanced Reports

  • Conditional Formatting
  • Drillthrough Filters
  • Visual Interactions
  • Sync Slicers
  • Report Tooltips
  • Bookmarks
  • Custom Visuals
  • Quick Measures
  • Recommended Practices

3. Report Design Principles

  • Information Processing
  • Report Organization
  • S.C.R.A.P Methodology
  • Color Theory
  • Visual Cues
  • 8 Rules of Power BI Design

Attendee Pre-requisite (if any)

NA

Is this class being recorded?

Yes. This class will be recorded and the registered attendee will get 12 months streaming access to the recorded class. The recordings will be available within 30 days of class completion.

Additional Comments from Instructor/Speaker

No special instructions/comments from the Speaker

Additional Comments from the Organizers

The current pricing is always the lowest. If you like the content, Book Now and save.

Training Classes are instructor-led, demo-based, 8 hours (4 hrs each day).

Due to virtual mode delivery, training classes are not hands-on. The 8-hour delivery is designed for maximum coverage and demos by the instructor. However, delegates will get the training class material (PDFs, demos, scripts, etc, as shared by the instructor) to practice at their convenience.

More Questions?

Visit FAQ page.

BooK Now

[gdlr_button href="https://dataplatformgeeks.com/dps2021/product/demystifying-design-principles-and-building-impactful-reports-in-power-bi-by-reid-havens/" target="_blank" size="small" background="#FA3106" color="#ffffff" width="30%" height="200%"]Book Now[/gdlr_button]


An End To End Migration And Modernization Journey Of Your Applications And Workloads To Azure

Pre-Con Title

An End To End Migration And Modernization Journey Of Your Applications And Workloads To Azure

Track(s)

Data Administration

Tags

#SQLServer  #Azure #IaaS #Migration #BestPractices

Level

Intermediate

Trainer/Speaker

Ajay Jagannathan, Raj Pochiraju, Rajesh Setlem, Alexandra Ciortea, Mohamed Kabiruddin

Abstract

In this workshop you learn, “The migration driving factors, different migration strategies, phases in the migration journey, live demos of leveraging Microsoft migration tools, discover, assess, understand the Azure readiness, target deployment option and size recommendations, monthly estimates migrating your applications and SQL Server databases to Azure.

Modules/Topics
  1. Migration drivers & strategies, Migration life cycle (phases) and intro of tools and services
  2. Database discovery at scale
  3. Azure SQL readiness and target deployment options
  4. Use Microsoft tools for migration
  5. Customer best practices and success stories

Attendee Pre-requisite (if any)

NA

Is this class being recorded?

Yes. This class will be recorded and the registered attendee will get 12 months streaming access to the recorded class. The recordings will be available within 30 days of class completion.

Additional Comments from Instructor/Speaker

No special instructions/comments from the Speaker

Additional Comments from the Organizers

The current pricing is always the lowest. If you like the content, Book Now and save.

Training Classes are instructor-led, demo-based, 8 hours (4 hrs each day).

Due to virtual mode delivery, training classes are not hands-on. The 8-hour delivery is designed for maximum coverage and demos by the instructor. However, delegates will get the training class material (PDFs, demos, scripts, etc, as shared by the instructor) to practice at their convenience.

More Questions?

Visit FAQ page.

BooK Now

[gdlr_button href="https://dataplatformgeeks.com/dps2021/product/an-end-to-end-migration-and-modernization-journey-of-your-applications-and-workloads-to-azure-by-microsoft/" target="_blank" size="small" background="#FA3106" color="#ffffff" width="30%" height="200%"]Book Now[/gdlr_button]


SQL Server Performance Tuning – Fast Track


Pre-Con Title

SQL Server Performance Tuning – Fast Track

Track(s)

Data Administration

Tags

#Performance #SQLServer #Tuning #Troubleshooting #Query Tuning

Level

Intermediate

Trainer/Speaker

Amit R S Bansal

Abstract

One fine day you realize that you have to start tuning SQL Server for better performance. The need might have arisen from a recent performance issue, or the barrage of support tickets that are filling your inbox, or maybe your boss assigned this to you after realizing that SQL Server performance troubleshooting is not his cup of tea. Irrespective of the reason, the challenge is upon you to identify, diagnose and fix a variety of performance issue that is plaguing your SQL Server environment.

Performance troubleshooting can be categorized as proactive, real-time & reactive. If a well-defined methodology is followed during the proactive phase, you will have to fire-fight less during the real-time troubleshooting phase and you will have a lot of meaningful performance data to work within the reactive phase, which will further help you in preventing performance cases.

Join this demo-filled, full-day class, where you will learn the three approaches of SQL Server performance troubleshooting & tuning. You will learn the practical way, exactly like how you would troubleshoot in the real world with lots of code and scripts. Amongst many takeaways, here are some interesting ones:

  • Develop a performance troubleshooting methodology for the real-world
  • Learn how to benchmark and baseline (and also take away a framework, ready-to-use)
  • Analyzing and troubleshooting common wait types
  • Proactive, reactive, and real-time CPU troubleshooting
  • Troubleshooting IO performance bottlenecks
  • Tracking SQL Server memory consumption and fixing OOM errors
  • Dealing with Tempdb madness\Top 6 query tuning techniques that will solve 75% of performance issues (real-world query tuning)
  • Top 3 indexing strategies that will fix 60% indexing woes
  • Get rid of deadlocks (yes, you hear it right)
  • SQL Server 2019 performance enhancements

Modules/Topics

Module 1: SQL Server Wait Types & Statistics

  1. Query Lifecycle
  2. Connections -> Sessions -> Requests -> Tasks -> Workers -> Threads
  3. Common Wait Types in SQL Server, identification & diagnosis

Module 2: The Holy Trinity – CPU, Memory, IO

  1. Identifying, troubleshooting & tuning workload patterns that cause excessive CPU
  2. Identifying, troubleshooting & tuning workload patterns that cause excessive Memory Usage
  3. Identifying, troubleshooting & tuning workload patterns that cause excessive IO

Module 3: Query Execution & Query Plan Analysis

  1. Statistics & Cardinality Estimation
  2. Reading & Analysing Execution Plans
  3. Important Iterators

Module 4: Query Tuning

  1. Rewriting Transact-SQL
  2. Optimizing Stored Procedures
  3. Solving Parameter Sniffing Issues
  4. Parametrization Best Practices
  5. Tips with Procedural Code

Module 5: Index Tuning

  1. Demystifying Common Myths with Indexes
  2. Indexing Strategies
  3. Index Fragmentation
  4. Real-World Index Tuning Examples

Module 6: Dealing with Deadlocks

  1. SQL Server Concurrency, Isolation Levels, Locking Granularity & Hierarchy
  2. Common Deadlock Types
  3. Deadlock Best Practices
  4. Practical Deadlock Troubleshooting & Diagnosis

Attendee Pre-requisite (if any)

Pre-requisite: You need to have at least two years of genuine SQL Server experience to gain maximum from this pre-con.

Is this class being recorded?

Yes. This class will be recorded and the registered attendee will get 12 months streaming access to the recorded class. The recordings will be available within 30 days of class completion.

Additional Comments from Instructor/Speaker

No special instructions/comments from the Speaker

Additional Comments from the Organizers

The current pricing is always the lowest. If you like the content, Book Now and save.

Training Classes are instructor-led, demo-based, 8 hours (4 hrs each day).

Due to virtual mode delivery, training classes are not hands-on. The 8-hour delivery is designed for maximum coverage and demos by the instructor. However, delegates will get the training class material (PDFs, demos, scripts, etc, as shared by the instructor) to practice at their convenience.

More Questions?

Visit FAQ page.

BooK Now

[gdlr_button href="https://dataplatformgeeks.com/dps2021/product/sql-server-performance-tuning-fast-track-by-amit-bansal/" target="_blank" size="small" background="#FA3106" color="#ffffff" width="30%" height="200%"]Book Now[/gdlr_button]


10 Rules A Database Developer Must Know

Pre-Con Title

10 Rules A Database Developer Must Know

Track(s)

Development

Tags

#SQLServer #Development #Rules #Performance

Level

Advanced

Trainer/Speaker

Uwe Ricken

Abstract

Are you already an experienced programmer and know your way around the Microsoft SQL Server development language? Still, there are always problems with query runtimes that you cannot explain to yourself. Data is not written to database tables fast enough and you are looking for ways to optimize ETL processes?

These are all things that pose new challenges for a database developer daily. This workshop for database developers closes many of these gaps and uses practical examples to explain, analyze and solve the problems.

  • Parameter sniffing
  • Non SARGable queries
  • Sort spills
  • Implicit conversion
  • NOLOCK / TABLOCK
  • Temporary tables vs. Table variables
  • Recursive CTEs
  • partitioning
  • scalar functions

This workshop is suitable for database developers who are already beyond the basics and want to sharpen the nuances. Ideally, you already have experience with execution plans and are very familiar with the SQL Server Management Studio.

This workshop is most hands on with prepared labs for the participants. All demos and hands on will be handled wit a BIG database (17 GB) and not with only a few records.

Modules/Topics
  • Parameter sniffing
  • Non SARGable queries
  • Sort spills
  • Implicit conversion
  • NOLOCK / TABLOCK
  • Temporary tables vs. Table variables
  • Recursive CTEs
  • partitioning
  • scalar functions

Attendee Pre-requisite (if any)

The Instructor/Trainer has not specified any pre-requisites.

Is this class being recorded?

Yes. This class will be recorded and the registered attendee will get 12 months streaming access to the recorded class. The recordings will be available within 30 days of class completion.

Additional Comments from Instructor/Speaker

No special instructions/comments from the Speaker

Additional Comments from the Organizers

The current pricing is always the lowest. If you like the content, Book Now and save.

Training Classes are instructor-led, demo-based, 8 hours (4 hrs each day).

Due virtual mode delivery, Training Classes are not hands-on. The 8-hour delivery is designed for maximum coverage and demos by the instructor. However, delegates will get the pre-con material (PDFs, demos, scripts, etc, as shared by instructor) to practice at their convenience.

More Questions?

Visit FAQ page.

BooK Now

[gdlr_button href="https://dataplatformgeeks.com/dps2021/product/10-rules-a-database-developer-must-know-by-uwe-ricken/" target="_blank" size="small" background="#FA3106" color="#ffffff" width="30%" height="200%"]Book Now[/gdlr_button]