Don’t settle for the “SELECT * FROM table” level, but deepen your skills, be surprised by the versatility of SQL! SQL is a good tool for editing data.

Many spend a lot of time editing data with different tools or programming languages. Processing data with SQL saves a lot of time. You can also dig examples from the internet, but is there time for that? In this course you learned good methods at once, in this course you can try and internalize different sentence structures.

“Must-have course” for authors of downloads and reports of Data Warehouse stocks. Even if you use an ETL tool, you should know SQL well! Also popular with testing experts.

For those who already know the basics of SQL, we offer in-depth knowledge and skills in this unique course based on practical experience. Comes with newer features of SQL as well as plenty of handy examples of expressive statements that can save you a lot of unnecessary work. We comprehensively go through the different connections and all the different types of subqueries. Other examples: table-level comparisons, updating from one table to another, versatile subqueries, age calculation, double-row handling, and maximum n values. In addition, we make a wide range of so-called. data download exercise with its histories, we practice the so-called profiling commands as well as examples of new analytical functions. The course is product independent and we compare the SQL dialects of different products according to the needs of the participants.

Ari Hovi has developed this course over the years and it is based on his popular SQL Guide book, supplemented with many new examples and exercises. Lauri Pietarinen, one of Finland’s leading SQL experts, is now taking the course in his interactive style, which takes into account the needs of students. He got a score of 4.7 / 5 from the last SQL course.

Plenty of training tasks on our own workstations, in our own SQL training environment, without installations via a browser. You can do the exercises of your choice with SQL Server, Oracle or PostgreSQL. Participants will receive plenty of examples, tips based on practical experience and comprehensive course material.

The course is often also ordered on a company-specific basis; you should order in time to fit in the calendar, the exercises can be done on your own machines using Ari Hovi’s cloud-based training environment.

To whom:

For anyone who wants to quickly get deeper into SQL skills. For data warehouse designers and implementers, testers, Data Scientists, BI and reporting people, application programmers, DBAs, migrators.

Prerequisites:

Simple basic SQL skills; or e.g. our SQL basics course.

Training time
Daily start and end of training event: training 9:00-16:15

Contents of this course:

• Repetition of basic SQL queries
• Functions
• Grouping
• CASE statement
• Joints; new and old syntax
• External connection; problem cases
• Subquery in FROM statement
• UNION
• Subqueries; ordinary and correlated; EXISTS
• Comparison of two tables (changed, new, deleted)
• SQL statements needed to handle Type-2 history
• Making summary tables
• Database data quality control with SQL
• Useful upgrade commands
• Processing and modifying strings
• Performance considerations