Hi!
What Oracle, Microsoft and NoSQL have in common? They will all unite under one roof in the next DevClub.lv event! We’ve asked experienced people in SQL field to share their knowledge.
Join SQL focused event at 23rd February 18:30, Zaļā iela 1, 4th floor (Microsoft Latvia office).
Agenda for SQL focused 52nd DevClub.lv:
- Sergejs Viņņiks from Intrum Justitia SDC will give a talk “PL/SQL legacy today: SPA UI application and automated testing with JavaScript.”
Businesses which run Oracle-based legacy systems sometimes wish to move to a modern WEB-GUI, without refactoring the business logic written completely in PL/SQL. Demand for implementing iterative agile development comes often hand-by-hand.
Sergejs will demonstrate two generic solutions, which have been developed by Intrum Justitia SDC to address the aforementioned topics:
1. Hapio – the HTTP adapter to the Oracle 12c database, which allows to call any SQL and PL/SQL methods directly from the browser;
2. Jasquel – the PL/SQL testing tool, which utilizes Hapio to help creating and automating PL/SQL module tests in JavaScript.
(Language — Latvian)
Tags: PLSQL, Testing, JavaScript
Sergejs is an experienced software developer, mainly focused on the databases and PL/SQL during the past years, as well as on training teens and adults in both programming basics and advanced features.
- Juris Rāts from Scope Technologies will give a talk “SQL Server 2016 – what’s new for developers”
SQL Server has been around for decades. Lots of developers have used it at some stage of their career. However, most use it just as another data store. With the rise of NoSQL is it even relevant anymore?
Well, I believe, it is. It still has plenty to go for, each version introduces new features and it covers a wide range of scenarios. And the latest version has some aces upon its sleeve. We will do a quick overview of what is SQL Server, then glance over some of the features of the latest version.
Finally – some notes from the field. How to approach a SQL Server database on a production server.
(Language — Latvian)
Tags: SQL Server 2016, In-Memory, Performance optimization
Juris is a team lead at Scope Technologies. DB wise his main focus has been SQL Server development and optimization. Lately has had some exposure to NoSQL in a couple of projects as well.
- Aivars Kalvāns from Tieto Latvia will give a talk “A NoSQL journey in Oracle SQL world”
A retrospective of over 15 years of product development and different approaches we saw and tried to add flexibility and extensibility to our products. Starting with extra columns for tables, different key-value stores and document stores on top of RDBMS tables and finally Oracle JSON support. I will look at tasks we were trying to solve and problems we introduced by doing that and how we tried to battle them.
(Language — English)
Tags: SQL, Schemaless, JSON, Oracle Database
Aivars is a software architect at Tieto Latvia and has worked on payment card software products for more than 15 years. He is using C++, Python and SQL with Oracle database and Tuxedo middleware to build online and batch processing systems. And Aivars loses sleep tinkering with the opposite needs of both worlds.
Tieto is an international IT company, it’s headquarters is located in Helsinki, Finland; more than 13 000 professionals are employed in almost 20 countries across the globe.
To join Tieto Latvia, please feel free to send your CV to darbs@tieto.com or check our webpages www.tieto.lv and www.tieto.com .
Come and see our stand at RTU Career Day on 2nd March, 2017
Scope Technologies’ aim is to make the “Connected Car” a reality, through providing innovative, cost-effective and reliable end-to-end telematics products and services. They are looking for C# Developers
Intexsys is looking for:
– PHP Developers – Junior, Mid, Senior – we got work for any level!
– DevOps Engineer – Chef/Puppet/Ansible lovers, we’re looking for you!
– QA Engineer – Can you assure our quality?
We promise – it will never be boring!
Intrum Justitia is looking for:
– Senior Backend Developer
– IT Operations Support Specialist
– Sr. Business Analyst
ALSO Cloud keeps doing awesome stuff and looking for awesome people.
Geta Digital is a international Digital Commerce Agency with offices in Norway, Latvia, Sweden, Netherlands and the U.S. They are looking for
– .NET Web Developers
– Front-end Developers
– Test Engineers
Thanks to our sponsors we are able to make DevClub.lv events and have drinks and snacks: