SQL Server Service Broker Core Skills (1 day)
SQL Server is easy to start working with but there can be a lot to learn before you can build the most useful applications on it.
One of the most powerful yet least understood features in SQL Server has been Service Broker. This course is designed to get you working productively with Service Broker as quickly as possible, while avoiding common pitfalls, particularly in relation to design.
The course is targeted at application developers that are creating systems that would be enhanced by the addition of message-based architectures. These can involve transactional queues, asynchronous triggers, internal and external activation procedures and many more. The course is also useful to existing SQL Server developers and DBAs who need to support applications built with Service Broker.
While our courses are based on SQL Server 2017, we realise that many customers are not yet running that version. Rather than provide you a course that only covers a single version of SQL Server, our courses are designed to be relevant (wherever possible) to a range of SQL Server versions including SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014 and SQL Server 2016. Where there are differences between versions, the differences are clearly highlighted.
|CITY||DATES||COURSE PRICE||EARLY BIRD PRICE|
|On-demand||Please contact us||
|DAY 1||SB301||SERVICE BROKER CORE CONCEPTS|
|Rationale for Service Broker|
|Alternatives to Service Broker|
|Service Broker Features|
|Service Broker Objects|
|LAB: Service Broker Core Concepts|
|DAY 1||SB302||IMPLEMENTING SERVICE BROKER OBJECTS|
|Creating Message Types|
|Sending and Receiving Messages|
|LAB: Implementing Service Broker Objects|
|DAY 1||SB303||DESIGNING SERVICE BROKER ACTIVATION AND ROUTING|
|LAB: Designing Service Broker Activation and Routing|
|DAY 1||SB304||SERVICE BROKER DESIGN PATTERNS, PERFORMANCE AND TROUBLESHOOTING|
|LAB: Service Broker Design Patterns, Performance and Troubleshooting|