SQL Databases Fundamentals for Data Analysis

Training SQL Databases Fundamentals for Data Analysis is designed to give you the foundation to work with databases with SQL so you can start analyzing data using your own database. You will begin to ask the right questions and get the right answers to bring valuable insights to your business.

Date 1
From 23/01/2023
to 24/01/2023
Date 2
Soon

v2

Price
390,00 EUR // 2938,45 HRK (tečaj konverzije 7,53450)
*per attendee, price without VAT 25%
Apply now

Choose the type of application, provide any optional details and we will contact you back soon.

A problem was detected in the following Form. Submitting it could result in errors. Please contact the site administrator.
Type of application:
Contact info:
Choose the date and number of attendees:
Options and Consent:

Overview

This training starts with the basics and assumes you do not have any knowledge or skills in SQL and you will gradually write simple and complex queries that will help you select data from the tables.

All workshops will be done on the Microsoft SQL Server database, the market leader in the database market for the last ten years. You can apply knowledge on this education to any other database (Oracle, MySQL, PostgreSQL, Amazon Redshift, Google Big Query).

Audience

Training is intended for all students who want to learn the basics of working with databases using SQL regardless of their previous experience. No prior knowledge of databases and SQL is required.

What you will learn

After training, you will be ready to work on query databases using SQL language and use analytic tools (Tableau, Power BI, Qlik) on the database.

Syllabus

in this module you will learn what relational databases are and what is sql (structured query language). you will learn how to use the select and from statements to select the table and columns you need in the query.

  • workshop

In this module, you will learn how to join multiple tables through INNER, LEFT, RIGHT and FULL OUTER JOIN and merge multiple tables using the UNION and UNION ALL statements. You will learn the differences between JOIN and UNION and when to use that statements through various exercises.

  • Workshop

In this module, you will learn how to filter qualitative and quantitative data using the WHERE, BETWEEN, LIKE, and IN commands, and how to sort the data in alphabetically or in size using the ORDER BY statement.

  • Workshop

In this module, you will learn how to group or aggregate detailed data using the GROUP BY statement and how to filter data using the HAVING statement to filter grouped data.

  • Workshop

In this module you will learn how to use basic aggregate functions like SUM, MIN, MAX, COUNT and DISTINCT, and how to do arithmetic calculations.

  • Workshop

In this module, you will learn how to type, modify, and delete data in the database using the CREATE, UPDATE, DELETE and TRUNCATE commands.

  • Workshop

In this module you will learn how to convert one type of data to another, for example, from the number to the text and vice versa using the CAST and CONVERT statements.

  • Workshop

In this module you will learn how to directly connect reporting tools like Tableau, Power BI or Excel to a database.

  • Workshop
How can I register for this training?

You can officially register for the training via the registration form at the top of this page. After successfully sending the application, we will get back to you within 24 hours of receiving the application.

I have not received any feedback from you. Who should I contact?

Mistakes in communication always happen, and if we don’t answer you, contact us directly at birdacademy@inteligencija.com

Can training be paid in several installments?

We currently do not support payment in multiple installments.

I don't live in Zagreb, but I would like to attend the training virtually. Is there such a possibility?

Of course, all our trainings can be followed virtually.

Is there a discount for students?

Students are entitled to a 10% discount on the price shown on this page.

I don't have my own laptop for this training. Do you provide me with a computer for training?

BIRD Academy provides a computer, lunch, coffee and water for each participant. We strive to be the best host possible in every segment!

BIRD Academy Trainings

Crafted by the Data Analytics experts