10 Rules A Database Developer Must Know by Uwe Ricken (Recordings)

10 Rules A Database Developer Must Know by Uwe Ricken (Recordings)

$298.00

Use 50% Discount Code: DPS50 (Now: US$ 298 . After Discount: US$ 149)

10 Rules A Database Developer Must Know

8-hrs Video Course (Recorded Class)

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.

Description

10 Rules A Database Developer Must Know

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.

Reviews

There are no reviews yet.

Only logged in customers who have purchased this product may leave a review.