[et_pb_section fb_built=”1″ disabled_on=”off|off|off” admin_label=”Header” _builder_version=”3.10.1″ parallax=”on” max_width_last_edited=”on|desktop” custom_padding=”0||0|0px|false|false” top_divider_height=”0px”][et_pb_row custom_padding=”27px|0px|0|0px|false|false” _builder_version=”3.10.1″][et_pb_column type=”1_2″ _builder_version=”3.0.47″][et_pb_text _builder_version=”3.19″ text_font=”||||||||” text_font_size=”17px” text_line_height=”1.9em” header_font=”|300|||||||” header_font_size=”60px” header_font_size_tablet=”40px” header_font_size_phone=”32px” header_font_size_last_edited=”on|phone” header_line_height=”1.4em” header_2_font=”Roboto|300|||||||” header_2_font_size=”50px” header_2_line_height=”1.2em” header_4_font=”|600|||||||” header_4_text_color=”#666666″ header_4_line_height=”2em” max_width=”136%” custom_margin=”|||” locked=”off”]

Full-day

Workshop:

Modern SQL: Aggregation and Analysis

[/et_pb_text][/et_pb_column][et_pb_column type=”1_2″ _builder_version=”3.0.47″][et_pb_image src=”https://voxxedromania.ams3.cdn.digitaloceanspaces.com/2019VDBUH/speakers/markusworkshop.jpg” _builder_version=”3.19.5″ border_radii=”on|0%|0%|0%|0%” max_width=”80%”][/et_pb_image][/et_pb_column][/et_pb_row][et_pb_row custom_padding=”27px|0px|46px|0px|false|false” _builder_version=”3.10.1″][et_pb_column type=”4_4″ _builder_version=”3.0.47″][et_pb_text _builder_version=”3.19″ text_font=”|300|||||||” header_font=”||||||||” header_4_font=”||||||||”]

This course helps developers making better use of their SQL database.

[/et_pb_text][/et_pb_column][/et_pb_row][et_pb_row custom_padding=”0|0px|0|0px|false|false” _builder_version=”3.10.1″][et_pb_column type=”1_3″ _builder_version=”3.0.47″][et_pb_text _builder_version=”3.19″ text_font=”Sansation|300|||||||” link_font=”||||||||” ul_font=”||||||||” ol_font=”||||||||” quote_font=”||||||||” header_font=”||||||||”]

Why this workshop?

SQL is a powerful tool that can easily replace hundreds lines of code by a few lines of SQL—in the end, the SQL query will even run faster as the home-grown code.

This workshop gives a grounds-up introduction into window functions (aka. the OVER clause), one of the SQL features to leverage that benefit.

 

[/et_pb_text][/et_pb_column][et_pb_column type=”1_3″ _builder_version=”3.0.47″][et_pb_text _builder_version=”3.19″ text_font=”|300|||||||” custom_margin=”|||65px”]

What will you learn?

This workshop covers the full power of the OVER clause:

Naturally, it also covers all functions that can be used with the OVER clause:

Use cases we will discuss and explore in the exercises include:

[/et_pb_text][/et_pb_column][et_pb_column type=”1_3″ _builder_version=”3.0.47″][et_pb_text _builder_version=”3.19″ text_font=”Sansation|300|||||||” link_font=”||||||||” ul_font=”||||||||” ol_font=”||||||||” quote_font=”||||||||” header_font=”||||||||”]

Who is the trainer?

 

 Markus Winand is an independent author, trainer and consultant on all things SQL. His book “SQL Performance Explained” has just been translated into a fifth language. It can be purchased as a print edition, and it’s also available to read for free on his use-the-index-luke.com website. Markus is currently working on his second book centered on the idea that things have changed a lot since SQL-92. It is likewise available free of charge online (modern-sql.com).

Who is it for?

This workshop is for developers who feel comfortable with basic SQL (select, from, join, where, group by).

[/et_pb_text][/et_pb_column][/et_pb_row][/et_pb_section][et_pb_section fb_built=”1″ admin_label=”Speakers” _builder_version=”3.10.1″ background_color_gradient_direction=”121deg” background_size=”initial” background_position=”top_left” custom_padding=”0|0px|54px|0px|false|false”][et_pb_row custom_padding=”0|0px|27px|0px|false|false” _builder_version=”3.8″][et_pb_column type=”4_4″ _builder_version=”3.0.47″][et_pb_text _builder_version=”3.19″ text_font=”|300|||||||”]

WorkTechnical requirements:

Bring your own device with a database pre-installed. PostgreSQL 11 is the recommended database for this training, as it has the most complete implementation of window functions. Alternatively, the training can be taken on any of the following databases. Please make sure you have at least the mentioned version.

- MySQL 8.0
- MariaDB 10.2
- PostgreSQL 11
- SQLite 3.25
- SQL Server 2012
- Oracle 12
- Db2 (LUW) 11.1

Prior to the workshop, the trainer will provide a download of a VirtualBox appliance with free open-source databases pre-installed (PostgreSQL, MariaDB, MySQL). You still need to install the required client software on your device as the appliance does not include the client software.

[/et_pb_text][/et_pb_column][/et_pb_row][et_pb_row custom_padding=”0|0px|27px|0px|false|false” _builder_version=”3.8″][et_pb_column type=”4_4″ _builder_version=”3.0.47″][et_pb_text _builder_version=”3.16.1″ text_font=”|300|||||||”][/et_pb_text][et_pb_button button_url=”https://romania.voxxeddays.com/product/standard-price-combo-conference-pass-modern-sql-hands-on-workshop-voxxed-days-bucharest-2019/” button_text=”Buy combo ticket ” button_alignment=”center” _builder_version=”3.19.5″ custom_button=”on” button_text_size=”20px” button_text_color=”#ffffff” button_bg_color=”#18b9f0″ button_border_width=”8px” button_border_color=”rgba(0,0,0,0)” button_border_radius=”0px” button_letter_spacing=”0px” button_font=”|700||on|||||” button_use_icon=”off” box_shadow_style=”preset1″ custom_margin=”40px|||” button_text_color_hover=”#ffffff” button_border_radius_hover=”100px” button_letter_spacing_hover=”3px” locked=”off” button_text_size__hover_enabled=”off” button_one_text_size__hover_enabled=”off” button_two_text_size__hover_enabled=”off” button_text_color__hover_enabled=”on” button_text_color__hover=”#ffffff” button_one_text_color__hover_enabled=”off” button_two_text_color__hover_enabled=”off” button_border_width__hover_enabled=”off” button_one_border_width__hover_enabled=”off” button_two_border_width__hover_enabled=”off” button_border_color__hover_enabled=”off” button_one_border_color__hover_enabled=”off” button_two_border_color__hover_enabled=”off” button_border_radius__hover_enabled=”on” button_border_radius__hover=”0px” button_one_border_radius__hover_enabled=”off” button_two_border_radius__hover_enabled=”off” button_letter_spacing__hover_enabled=”on” button_letter_spacing__hover=”0px” button_one_letter_spacing__hover_enabled=”off” button_two_letter_spacing__hover_enabled=”off” button_bg_color__hover_enabled=”off” button_one_bg_color__hover_enabled=”off” button_two_bg_color__hover_enabled=”off”][/et_pb_button][/et_pb_column][/et_pb_row][et_pb_row custom_padding=”27px|0px|0|0px|false|false” _builder_version=”3.8″][et_pb_column type=”4_4″ _builder_version=”3.0.47″][et_pb_text _builder_version=”3.9″ text_font=”||||||||” text_font_size=”20px” text_line_height=”1.9em” header_font=”||||||||” header_2_font=”Roboto|300|||||||” header_2_font_size=”50px” header_2_font_size_tablet=”40px” header_2_font_size_phone=”32px” header_2_font_size_last_edited=”on|phone” header_2_line_height=”1.2em” max_width=”700px” max_width_last_edited=”on|desktop” locked=”off”]

Speaker

[/et_pb_text][/et_pb_column][/et_pb_row][et_pb_row _builder_version=”3.8″][et_pb_column type=”4_4″ _builder_version=”3.0.47″][et_pb_team_member name=”MARKUS WINAND” position=”Independent author, trainer, consultant & author of %22SQL Performance Explained%22″ image_url=”https://lh3.googleusercontent.com/R5xjskSOO4otsLzv0akRal7HvtV9f_VLHpsrNc-wIlhpboJpNqNOVFCfWa3muEUGiE5lq0pdoPxKgCp2pAaKf0hcOOTk5KmwsA6s6iPJ82CLMmpiS7tZnvndwqxJf3vnrBoM9Spi3WTDIxsDyIh7kSBt9uZKMH9N37b02qCzc-Je-RUURALUbxszZGncqNsxclfOUMdB5GRIGx6lurLegLAzqBrd3hYRw4dCLgOqIl3Nquyt6xt0R3qZ8Y6eTFMD1tqte_-OWdAAFeiQrnCY6qUg9zi8cYZvJaqqKJinPA0eJCIcE9Ejhz0NvXLttYn_yV2p30fRlAp1_gFYcGecVWV3nRDW5A9Jc0d6aL4jiioZmXCMG1nXYHAwRFqi4TXVYdF6d_ctSLuvJX8eMHK_bYSkdt3PxwCVFOPUNLyAy8pIaUuzspZz92oaeLN5Fk-G_uYJgg1yRM57xhlYaTta39hMlfaOTqeINhn7jNo9dtwn5I7CQEUBhzGVEFROU6ytXbMTocB_9t4V9zfMRT6WkwxDvkjR8HV8SvRFpvrXn6MrZg0EfBEn_6EkZk-RiBUtfBJ38vwW1qEpjJF2wgcbKN9e5vDzxCiuOLYPnaAyZlDZ43bqgQCFNKCCUJa60dbab4xTJFJzEEG-gNxxlC8dCcjN=w1000-no-tmp.jpg” _builder_version=”3.19″ header_level=”h5″ header_font=”Roboto||||||||” header_font_size=”24px” header_line_height=”1.2em” body_font=”||||||||” body_font_size=”16px” body_line_height=”1.9em” border_radii_image=”on|100%|100%|100%|100%” text_orientation=”left” animation_style=”zoom” animation_direction=”bottom” animation_delay=”150ms” animation_intensity_zoom=”10%” locked=”off”][/et_pb_team_member][/et_pb_column][/et_pb_row][et_pb_row _builder_version=”3.11.1″][et_pb_column type=”4_4″ _builder_version=”3.11.1″][et_pb_button button_url=”https://romania.voxxeddays.com/bucharest/2019-03-20/#speakers” url_new_window=”on” button_text=”SEE ALL OUR SPEAKERS” button_alignment=”center” _builder_version=”3.17.6″ custom_button=”on” button_font=”||||||||” button_use_icon=”off” box_shadow_style=”preset1″ button_text_color_hover=”#ffffff” button_bg_color_hover=”#18b9f0″ button_text_size__hover_enabled=”off” button_one_text_size__hover_enabled=”off” button_two_text_size__hover_enabled=”off” button_text_color__hover_enabled=”on” button_text_color__hover=”#ffffff” button_one_text_color__hover_enabled=”off” button_two_text_color__hover_enabled=”off” button_border_width__hover_enabled=”off” button_one_border_width__hover_enabled=”off” button_two_border_width__hover_enabled=”off” button_border_color__hover_enabled=”off” button_one_border_color__hover_enabled=”off” button_two_border_color__hover_enabled=”off” button_border_radius__hover_enabled=”off” button_one_border_radius__hover_enabled=”off” button_two_border_radius__hover_enabled=”off” button_letter_spacing__hover_enabled=”off” button_one_letter_spacing__hover_enabled=”off” button_two_letter_spacing__hover_enabled=”off” button_bg_color__hover_enabled=”on” button_bg_color__hover=”#18b9f0″ button_one_bg_color__hover_enabled=”off” button_two_bg_color__hover_enabled=”off”][/et_pb_button][/et_pb_column][/et_pb_row][/et_pb_section]