Simplify your SQL databases and improve performance with this Masterclass workshop from Lukas Eder. Too often, SQL databases are overly complex and poorly leveraged. Thanks to skills you will learn in this hands-on workshop, you can vastly improve your SQL code with a little extra expertise!
About this workshop
This workshop enables developers to use SQL as a first class language in their applications. Due to the historic divide between database and programming skills, the majority of SQL written by developers suffers from at least one of the following problems:
- Overly complex code
- Poor performance
- Reliance on outdated features
All of these issues can be fixed by encouraging developers to treat SQL with as much respect as their normal code. Developers can improve their database administration with more information about performance implications and database internals. Their code can be simplified via refactoring; the latest features available in commercial and open source databases can optimize performance. Developers can easily improve their overall SQL experience with this two-day course.
This course is ideal for developers planning to work extensively with SQL or those already working with SQL who want to improve their database performance.
Day 1 – SQL Functionality
- Revision of core SQL constructs
- Advanced constructs, such as row value expressions and hierarchical SQL
- Applying window functions for complex calculations within the database
- Modern use of DML (e.g. using MERGE instead of INSERT and UPDATE)
- Using esoteric data types (JSON, hstore, arrays, composite types, ranges etc…)
Day 2 – SQL Performance
- The cost based optimiser (CBO)
- The inner workings of an index
- Writing performant predicates
- Constraints, or why metadata matters
- Faster writes / data manipulation (DML)
- Antipatterns, myths, and best practices
This is a 2-day workshop delivered using the DB2 LuW, MySQL 8.0+, Oracle, PostgreSQL, or SQL Server databases. Delegates should be experienced at writing SQL queries. Delegates can bring their own laptop, in which case setup instructions will be provided.
Prior experience with SQL is recommended.
About the trainer
Data Geekery GmbH
Lukas Eder is the founder and CEO of Data Geekery GmbH. He is a Java Champion, located in Zurich, Switzerland. Data Geekery has been selling database products and services around Java and SQL since 2013.
Ever since his Master’s studies at EPFL in 2006, he has been fascinated by the interaction of Java and SQL. He credits his work in the Swiss E-Banking field through various variants (JDBC, Hibernate, mostly with Oracle) for his experience. He is happy to share this knowledge at various conferences, JUGs, in-house presentations and on his blog.
JAXenter Masterclass 2019 Tickets
. Book before March 28th and save up to £315 per ticket
More by JAXenter Masterclass
Park Plaza Victoria London
239 Vauxhall Bridge Road
London SW1V 1EQ United Kingdom
The four-star Park Plaza Victoria hotel in London, situated within walking distance of Victoria train, coach, bus and Underground stations, provides an excellent transportation link to London Heathrow and London Gatwick airports. Offering on-site meeting facilities, dining options, Amber Spa and an Executive Lounge, this Victoria Station hotel is thoughtfully designed to suit business, conference and leisure travelers alike.
Centrally located to some of the city’s main tourist and shopping attractions: Buckingham Palace, Harrods, the Houses of Parliament, Theatreland, Oxford Street