SQL Databases Fundamentals for Data Analysis

Duration: 16 hours / 2 days

Knowledge: Beginner

Potential trainer(s): Tomislav Hlupić, Ana Novosel, Velga Mitrić, Pavle Pavišić, Bojana Halić

Language: Croatian, English

Possible locations: PI EDU center, At client premises, Virtual education in case of large groups

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
Soon
Price
*
390.00 EUR
* Price per attendee, price without VAT 25%
Apply now
Choose the type of application, provide any optional details and we will contact you back soon.

Company
Individual
I would like more information
By submitting this form, you agree that we may use the data provided to contact you with the information related to your request/submission and products and services of Poslovna inteligencija. You can unsubscribe from Poslovna inteligencija marketing emails at any time by clicking the unsubscribe link in the email. For more information, please see our Privacy Policy.
Please don't insert text in the box below!

The fields marked with * are required

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

  • 1. Introduction to sql databases and select statement

    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
  • 2. Table joins and unions

    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
  • 3. Filtering and sorting the data

    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
  • 4. Data grouping

    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
  • 5. Using aggregate functions

    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
  • 6. Inserting, updating and deleting data

    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
  • 7. Converting data types

    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
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?

The preferred form of education delivery is in on-site due to the quality of delivery. However, in the case of larger groups where all participants would be online, we can also arrange online delivery.

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