kr3,249.69

Kevin Kline: From Beginning to Advanced SQL Developer in One Day

Event Information

Share this event

Date and Time

Location

Location

AC Group (Addskills/Cornerstone)

Sofierogatan 3B

412 51 Gothenburg

Sweden

View Map

Refund Policy

Refund Policy

Refunds up to 7 days before event

Event description

Description

Did you miss this pre-con at SQL Saturday Stockholm?

Now you have a second chance!

Level: 200-300

What are the most problematic patterns and anti-patterns that trip up SQL Server developers on a daily basis? What sort of SQL and Transact-SQL challenges does every SQL Server developer encounter at some point in their career? This full-day, pre-conference seminar takes a tour of the most common and challenging issues that database developers face. Learn how to conquer them in the lab today so that they won’t take you surprise in the future. Loaded with live demonstrations and useful techniques, this session will teach you how to take your SQL Server queries mundane to masterful.

In this session, you’ll learn:

  1. Internal operations of the SQL Server query optimizer and caching mechanisms and their impact on T-SQL code performance, including ways to shortcut default behavior using trace flags.
  2. Tricks, techniques, and metadata analysis needed to make T-SQL code, including queries and stored procedures, achieve top performance and maximum reliability.
  3. A variety of patterns and anti-patterns in T-SQL coding that are common challenges for all but the most advanced database developers.

With this massive coding toolkit of tips and techniques, you’ll be able to write T-SQL code that consumes less system CPU, memory, and IO, while being easier to maintain and offering faster performance.

Prerequisites: Beginning competence in SQL and Transact-SQL syntax, such as coding SELECT, INSERT, UPDATE, and DELETE statements, using cursors and variables, and invoking functions and procedures. Basic familiarity with reading execution plans is very helpful.

Presented by SQLUG and SQL Saturday Gothenburg.

FAQs

What's the refund policy?

Fee is fully refunded up until 7 days before the event

Is my registration fee or ticket transferrable?

Yes, you can pass the ticket on to another person if you are unable to attend.

Is it ok if the name on my ticket or registration doesn't match the person who attends?

Yes! The ticket number is the important part!

Share with friends

Date and Time

Location

AC Group (Addskills/Cornerstone)

Sofierogatan 3B

412 51 Gothenburg

Sweden

View Map

Refund Policy

Refunds up to 7 days before event

Save This Event

Event Saved