Data Science and Predictive Analytics
SQL Databases Fundamentals for Data Analysis
Apply for the training
Learn SQL from scratchWrite database queries independentlyApply SQL across different database systemsHands-on practice with Microsoft SQL ServerTrainers
TBA
DURATION
16 hours / 2 days
LEVEL
Beginner
LANGUAGES
Croatian, English
LOCATION
Virtual classroom (for larger groups)
Overview
The SQL Databases Fundamentals for Data Analysis course is designed for beginners who want a foundation in working with databases and using SQL to analyze data. Participants will learn how to construct basic and advanced SQL queries, enabling them to ask the right questions and get valuable insights from their data.
The course starts from the basics, requiring no prior experience, and gradually moves into more complex queries — involving multiple tables, arithmetic operations, and subqueries.
All exercises are conducted on the Microsoft SQL Server, a leader in database technology, and the skills learned can be transferred to other database systems — like Oracle, MySQL, and PostgreSQL. By the end of the training, the participants will be able to independently write database queries for their own use cases, improving their data analysis capabilities.
Audience
This course is intended for participants who want to learn the basics of SQL, regardless of prior experience with databases.
Syllabus
01
Simple SQL Queries
The first module teaches what relational databases are, and what SQL (Structured Query Language) is. You will learn how to use the SELECT and FROM commands to choose the tables and columns needed for your query, and filter qualitative and quantitative data using the WHERE, BETWEEN, LIKE, and IN commands.
You will also learn how to sort data alphabetically or by size using the ORDER BY command.
Practical exercises
02
Retrieving Data from Multiple Tables
In this module, you will learn how to connect multiple tables using INNER, LEFT, RIGHT, and FULL OUTER JOIN.
Practical exercises
03
Scalar and Arithmetic Functions
After establishing the fundamentals, in this module you will learn to use arithmetic operations in SELECT and WHERE clauses, and how to use basic scalar functions.
Practical exercises
04
Aggregate Functions and Grouping
This module teaches you how to use basic aggregate functions such as SUM, MIN, MAX, COUNT, and DISTINCT.
Practical exercises
05
Union
In the fifth module you will learn to merge the results of multiple queries using the UNION and UNION ALL commands. You will also learn the differences between the JOIN and UNION commands, and when to use each of them.
Practical exercises
06
Subqueries
Learn how to use subqueries in WHERE and HAVING clauses, with predicates, and with the IN command.
Practical exercises
07
Modifying Data
The final module teaches you how to insert, modify, and delete data in the database using the CREATE, UPDATE, DELETE, and TRUNCATE commands.
Practical exercises
Sign Up
Training