Database applications gain more performance, safety, and integrity
Database applications gain more performance, safety, and integrity
More than 20 Chemtech professionals participated in the last days of the “Data Base and Advanced SQL” course, by Joe Celko, one of the best reputed SQL experts in the world.
“Joe really has tremendous knowledge and likes teaching. I have been working with SQL for sometime and during the course I had the opportunity to see some techniques I had never seen before. First, Joe gave an overview on SQL, and then he showed some tricks and algorithms that can be solved during consultation, such as problems where tree structures and hierarchy need to be implemented. With the algorithm the access to this information is extremely quick and scalable”, declared Chemtech project leader Alex Salgado.
The course took place at the Chemtech offices in Rio de Janeiro and in Belo Horizonte, Brazil. Timeline techniques that use calendars, RANK and Windowing functions – such as ROWNUM(), RANK(), DENSE_RANK() and NTILE() – that solve problems involving summarization were shown.
The constant specialization and upgrading in the qualification of Chemtech professionals is a certainty that its clients can always count on the best services and solutions by a highly qualified team. One of the techniques learned at the course is already being implemented at a client’s site and will help reduce the 15-minute consultation processing to less than one minute.
The course objective was not limited to SQL; it also taught how to solve problems without using C#, Java, VB and other languages, but with the database and the help of the SQL. This enables gains in performance, safety, and integrity. Chemtech professionals have already ensured the achievement of this goal. According to Joe Celko, our professionals had a very good performance in the course: “Chemtech students were sharper than the students that usually attend my courses”, he said.
About Chemtech
Chemtech (www.chemtech-siemens.com) was founded by three chemical engineers, in Rio de Janeiro, in 1989. It is specialized in services and IT solutions for process industries (oil & gas, petrochemical and chemical, metals and mining, paper & pulp, food & beverages). In March 2001, the company became a member of the Siemens group and it is now part of the IP (Industrial Plants) division of the I&S (Industrial Solutions and Services) group. Since then, Chemtech has started to interact with other Siemens divisions and to offer more complete and sophisticated solutions to its clients.
Chemtech has its head office in Rio de Janeiro and support offices in São Paulo, Belo Horizonte, Salvador, and Houston.
Among Chemtech clients are Exxon Mobil, Saudi Aramco, and Petrobras. It also works with the 10 largest companies in the petrochemical and chemical industry in Brazil, with the 5 largest paper companies, the 4 largest mining companies, 3 of the 5 largest steel companies, and 4 of the 6 largest consumer product companies, according to the ranking of Exame magazine.
In 2004, thanks to believing in the importance of constant training and improvement of its professional team, Chemtech was chosen as one of the 150 best companies to work in in Brazil and one of the 9 best in Rio de Janeiro by the Guia Exame – Você S/A, a publication well known and reputed within the entrepreneurial and business environment.
In 2005, was chosen again as one of the 150 best companies, by the same publication.
