Client feedback shows that delegates on our courses will best engage when they can relate course topics to their own day-to-day practices and requirements. Where possible, we run this course as a consultative, workshop-style event, in which discussion of relevant topics takes place in relation to the delegates' own applications and scenarios.
To facilitate this type of event, a subject matter expert leads the training, hands-on labs and discussions to ensure course topics are covered in a meaningful, relevant and timely manner. Delegates may be able to bring their own practical requirements and work to the course if the subjects and course topics are suitable.
Relational Database Overview
The Query optimiser, compilation and caching.
Locking and Logging and how updates happen.
How backups work, how DTS packages work.
Using File groups to Position Objects
The affect of normalisation and de-normalisation.
Analysis Services – a reporting solution in waiting?
Task Manager & Performance Monitor – General counters to look out for, tips and techniques.
Current Activity Window & SQL Profiler – Zooming in on problem queries
Query Analyser – Decrypting the showplan and trace output. Other set commands.
Transact SQL diagnostic commands. Various DBCC commands, some undocumented.
Index selection – How the optimiser decides.
Statistics – Auto and Manual.
Clustered versus Non-Clustered – Pros and Cons
The Fillfactor factor
Index optimiser hints
Index tuning wizard, when to use it.
Index Maintenance. Dangers and pitfalls.
Table defrag with clustered indexes. When and when not to do it.
Indexed Views – Advanced index builds.
The City Analogy & Keeping the traffic flowing
Transaction isolation levels and locking hints
Table restructuring & de-normalisation, replication and data warehousing solutions
SARGS and the WHERE clause.
Covered indexes from the other side.
Stored procedures: Problems solved and created
Trigger problems and solutions
Cursors and Temporary tables
Tips and tricks.
Most of this course focuses on the server side application. However there is also a number of potential problems that may occur from the client side too. This section makes no assumption on which client you will be using, except that it will use ActiveX Data objects.
Default recordset options.
Send SQL versus Stored Procedures
Efficient use of recordsets and connections.
Timeout management and giving the user the perception of better performance
Receive the latest version of this course into your inbox
23/10/2017: Debates on the present state of C++ in the programming world divide the participants into two camps: some dislike C++ and predict it's imminent...
12/10/2017: Microsoft recently released the public road map that gives the holistic approach to Integration and the key product offerings that contribute...
05/10/2017: MVC The Model View Controller (MVC) architectural pattern has a long history (together with its variants) and has been used in many languages...
16/01/2018: Data Analysts at a Government establishment required the ability to respond rapidly to ad-hoc requests for information, including parliamentary...
03/10/2017: When a leading High Street Retailer (and purveyor of fine foods) recognised that teams of software engineers were writing overcomplicated and...
07/10/2019: In recent years, the introduction of microservices has allowed businesses to build and scale large software applications using independent teams....
Bring a JBI course to your office
and train a whole team onsite
0800 028 6400 or request quote
0800 028 6400
Why JBI ?
"great technology tips"
"Access to exclusive content"
"Short course means less time off"
"Joined via web"
"Knowledgable sales staff"
Subscribe to our Newsletter – Receive the latest info on Tech courses & insights Subscribe