5-Day SQL-Update for Developers and Analysts
Notice: Due to low demand since the outbreak of Covid-19 I don’t offer this format at the moment. Please consider my open online SQL trainings as an alternative. Private on-site as well as online trainings are available for three or more participants.
After this 5-day training, the participants clearly stand out from the field: they master modern SQL, know design principles for scalable databases and have gained practical experience through numerous exercises. During these five days, Markus Winand conveys the extensive SQL experience that he’s accumulated during his eight years as a developer with an international bank and a further eight years as an independent SQL trainer and consultant for companies of all sizes.
The next dates:
September 19-September 23 2022 (English, enroll)
If these trainings don’t fit: contact me for alternatives (online, in-house, you name it).
What Participants Say
“The best SQL training developers can get“
Jean-Claude Brantschen, Software Engineer @ PuzzleITC
“A truly productive training”
Niclas Vester, Owner @ 800 rader
Contents
SQL-Performance Kick-Start
In this module, developers learn how to resolve the most common cause of SQL performance issues: the index/query mismatch. After this training, developers can do more than just solve performance problems—they can proactively avoid them during their everyday work.
Topics:
How does an index work?
Multi-column, partial and function-based indexes
Execution plans
Join algorithms
Building and using data clusters
Indexing sort and grouping operations
Optimizing top-n and pagination queries
Drawbacks of indexes
SQL Reloaded
This module clarifies the most common uncertainties developers have when working with SQL, and it teaches them to find the right solution more quickly. This training also introduces some less well-known design principles that have nevertheless proven themselves over the past decade.
Topics:
Syntactic components: keywords, names, values
Type safety and the predefined data types
Queries: structure and logical order of execution
Joins
NULL and the three-valued logic of SQL
Collations
Analysis and Aggregation
Online analytical processing (OLAP) can simplify and accelerate many applications—also those processing transactions. Using these features not only reduces development time, it also improves the performance of the application.
Topics:
Avoiding self-joins
Multiple groupings
Window functions
Ranking
Grouping consecutive events
Recursive Queries
Modern SQL can process hierarchies and graphs directly in the database. This often means that you can avoid the need to cross a technology border, thus reducing the complexity and error-proneness of the application.
Topics:
The WITH clause (non-recursive)
The WITH RECURSIVE clause
Use cases and examples
Covered Databases
This training covers the following databases: MariaDB, MySQL, SQL Server, PostgreSQL, and the Oracle database. IBM Db2 (LUW), Google BigQuery and SQLite on request.
The databases actually used in the training is adjusted to the participants.
This training covers window function and the WITH clause and is therefore a great update for MySQL/MariaDB users.
All exercises are available for all covered databases.
Price
The course fee is €2990 (plus 20% VAT, €3588) per participant.
Book more than three month in advance and save €500 net per participant.
Foreign companies might be entitled for a full VAT refund from Austrian tax authorities. See VAT-Refund Procedure at the website of the Austrian Ministry of Finance for prerequisites and further details.
In the Package
This is what you get for your money:
5 full days (Mon-Fri; 9am–5pm) training with Markus Winand
No more than 8 participants
The venue is the Hotel am Parkring in Vienna, Austria.
Catering: Lunch, snacks during the breaks, drinks all day long
One hard copy and PDF of “SQL Performance Explained” (choose: English, German, French, Japanese or Spanish)
PDF and wire-bound print of the current draft of my next book covering the other topics of the training (choose: English or German)
Training exercises and solutions (runnable scripts for all covered databases)
Teammate on demand voucher: 2 times 30 minutes remote coaching valid 6 month after the training.
Certificate of completion (singed PDF and hard copy).
Prerequisites
This training is for developers with some SQL experience.
Bring your own device (with a database installed) or ask for a rental device. Detailed requirements will be shared several weeks before the training.
A VirtualBox appliance with a preconfigured free open source databases will be made available for download before the training. Client not included—install your preferred client before the training.
Yes, I want to join!
If these trainings don’t fit: contact me for alternatives (online, in-house, you name it).
Procedure
Please complete the form above if you are interested in this training. I’ll e-mail you a quote along with the invoice for a 20% advance payment to guarantee your seat.
Note that there is a free cancellation period both parties (you and me). The last date of free cancellation will be stated on the invoice. Please keep the possibility of a cancellation from my side in mind when you are doing your travel plans.
What Participants Say
In this intensive training we learned the basic blocks of database tuning in a great depth and practiced the analysis and tuning of different SQL statements. In addition we looked at typical SQL traps and learned how to avoid them. The last part of the training was a journey into a world of “new” SQL with advanced grouping/aggregation, window functions and recursive queries. The training was rounded off by very good documentation and a real SQL master as a trainer. In summary: the best SQL training developers can get.
Jean-Claude Brantschen, Software Engineer @ PuzzleITC
A truly productive training. The biggest win for me with the training is increased confidence in the SQL arena. Before I have sometimes managed to come up with solutions that work, buts still feels clumsy, now I always know what to do.
Niclas Vester, Owner @ 800 rader
Environment
Climate protection is important. I therefore compensate the climate impacts of your trip to Vienna at atmosfair.de. Please consider the climate balance of the respective means of transport during your travel planning. Avoiding emissions is still the best climate protection.
SQL Renaissance Ambassador
As the SQL Renaissance Ambassador, it’s my mission to make developers aware of the evolution of SQL in the 21st century. My book “SQL Performance Explained” has been published in five languages and can be read online free of charge at use-the-index-luke.com. My next book is currently in the works and can already be read online as it’s being written (modern-sql.com). I am available as a trainer, speaker and consultant for all companies and developers interested in SQL. You’ll find more info at winand.at.