When it comes to data, SQL is a vast and powerful language. That being said, it is difficult to know and properly utilize all of its functionality, especially considering that each RDBMS has its own dialect and feature set. In this talk, we will review the advanced SQL functionality available for you within PostgreSQL, enabling you to become the SQL guru of your team. We will explore examples and use cases for Common Table Expressions(including recursive queries), Correlated and Uncorrelated Subqueries, Analytical Window Functions(ie: Percentile, Running Aggregates, Rank), Lateral, and other less commonly known, but incredibly useful, features supported by PostgreSQL. This talk will provide you with the tools you need to write (or rewrite) performant, readable, and efficient queries, solve complex analytical questions, and make large data sets and complex data/analysis requests more manageable.
A special rate for accommodation at Crowne Plaza Airport hotel is was available for all attendees of PG Day’17 Russia.
Text of the letter was copied to clipboard
Want your company to pay for your attendance at the conference?
Copy this letter form, fill in your personal details and send it to your chief executive.
I would like to attend PG Day’17 Russia conference,
devoted to databases, that will take place on 5-7 of July in St. Petersburg.
At the conference I will have an opportunity to:
Systematize my current knowledge about DBMS and obtain the new ones;
Receive guidelines on maintenance and operation of DBMS;
Improve my personal skills with DBMS;
Get the latest information about the community;
Improve my efficiency by means of taking advice from the most prominent DBMS experts and adopting best practices of colleagues from other companies;
Get new ideas and find out more about innovative modes of operation.
This is an estimate list of expenses:
Approximate cost of flight tickets —  rur
Approximate cost of accommodation —  rur
Conference attendance —  rur
Total amount —  rur
On return I will make an 1 hour report for my colleagues and highlight the most interesting issues of the conference and offer testimonials to help improve efficiency of the team.
Looking forward to hearing from you as soon as possible!
Calculate individual costs for corporate attendance
Fill out the form, and we will reply with details of the payment as soon as possible.
Enter your e-mail and we will send you payment details soon.