10 Rules A Database Developer Must Know by Uwe Ricken

Sale!

10 Rules A Database Developer Must Know by Uwe Ricken

$169.00

10 Rules A Database Developer Must Know

8-hrs Virtual Classroom Training
LIVE Attendance + Class Recordings

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.

PS: 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.

Date & Time:
View in your own time zone
Go to Training Class Page

8-hrs Virtual Classroom Training
LIVE Attendance + Class Recordings

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.