Diving into Data Training

  • Learn via: Classroom
  • Duration: 1 Day
  • Price: From $1,735+VAT
We can host this training at your preferred location. Contact us!

Are you someone who gets data delivered and spend hours knocking it into shape? Then this is the course you need. Designed for the data consumer and business user it is designed to help you understand the art of the possible in the way data is prepared for you.

We will arm you to be more informed and ask intelligent questions alongside your data specialists to ensure the value, accuracy and relevance of the data you need is delivering its full potential.

Audience:

Data users such as Project Managers, Accountants, Business Analysts, managers or any role that needs to get more out of data reports

This course enables absolute beginners who've never worked with relational databases to be fully self-sufficient in writing SQL queries & extracting data from enterprise level databases. Upon completion of this course, you will have attained the following skills:

1. Extracting data from relationship data bases with SQL
2. Filter data (Where and Operands)
3. Transforming data (Aggregate functions)
4. Grouping / pivoting data (Group By)
5. Sorting / Ordering data (Order By)
6. Bucketing data (Case statements)
7. Joining / Combing data (Joins)
8. Combing queries (Nested queries)
9. Processing text (Like function)
10. Slicing data (Having)
11. Processing timestamped data



Contact us for more detail about our trainings and for all other enquiries!

Upcoming Trainings

Join our public courses in our Istanbul, London and Ankara facilities. Private class trainings will be organized at the location of your preference, according to your schedule.

Classroom / Virtual Classroom
03 May 2024
Istanbul, Ankara, London
1 Day
Classroom / Virtual Classroom
15 May 2024
Istanbul, Ankara, London
1 Day
Classroom / Virtual Classroom
01 June 2024
Istanbul, Ankara, London
1 Day
Classroom / Virtual Classroom
03 June 2024
Istanbul, Ankara, London
1 Day
Classroom / Virtual Classroom
24 June 2024
Istanbul, Ankara, London
1 Day
Classroom / Virtual Classroom
16 July 2024
Istanbul, Ankara, London
1 Day
Classroom / Virtual Classroom
27 July 2024
Istanbul, Ankara, London
1 Day
Classroom / Virtual Classroom
09 August 2024
Istanbul, Ankara, London
1 Day
By using this website you agree to let us use cookies. For further information about our use of cookies, check out our Cookie Policy.